[R] Reading SAS data into R

Peter Dalgaard P.Dalgaard at biostat.ku.dk
Thu May 15 15:00:11 CEST 2008


Shubha Vishwanath Karanth wrote:
> Hi R,
>
>  
>
> Suppose that SAS dataset 'tsubset1' is stored in the path, "Z:/data".
> Then I give the below read.ssd() command to read SAS dataset,
> 'tsubset1.sas7bat' into R.
>
>  
>
>   
>> library(foreign)
>>     
>
>   
>> s=read.ssd("Z:/data","tsubset1",sascmd = "C:/Program Files/SAS/SAS
>>     
> 9.1/sas.exe")
>
>   
>> s
>>     
>
>   A B C
>
> 1 3 4 5
>
> 2 6 7 8
>
> 3 3 4 5
>
>  
>
> It reads perfect! It reads well for "tsubset1","tsubset2",.....,
> "tsubset9" datasets. But then onwards it gives an error as below:
>
>  
>
> *       s=read.ssd("Z:/data","tsubset10",sascmd = "C:/Program
> Files/SAS/SAS 9.1/sas.exe")
>
>  
>
> SAS failed.  SAS program at
> C:\DOCUME~1\SHUBHA~1.AMB\LOCALS~1\Temp\1\RtmpObHuqk\file6df11649.sas 
>
> The log file will be file6df11649.log in the current directory
>
> Warning message:
>
> In read.ssd("Z:/data", "tsubset1011", sascmd = "C:/Program Files/SAS/SAS
> 9.1/sas.exe") :
>
>   SAS return code was 2
>
>  
>
> Why is this? Are two numerical digits in a filename of a SAS dataset
> cannot be read by R? The error prevails for "tsubset201", "tsubset35462"
> etc.... Can somebody point out to me where actually the error is?
>
>  
What is in the SAS log file?

-- 
   O__  ---- Peter Dalgaard             Øster Farimagsgade 5, Entr.B
  c/ /'_ --- Dept. of Biostatistics     PO Box 2099, 1014 Cph. K
 (*) \(*) -- University of Copenhagen   Denmark      Ph:  (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk)              FAX: (+45) 35327907



More information about the R-help mailing list