R help - May 2008 - Reading SAS data into R

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?

 

Many Thanks,

Shubha

This e-mail may contain confidential and/or privileged i...{{dropped:13}}

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