[R] suggestions about import SAS results to R.

Yuan, Rebecca rebecca.yuan at bankofamerica.com
Wed Jan 2 23:44:05 CET 2013


Hello Ista,

Thanks for mention this package, however, it will not support big file, where I got the error message:

----------------------
Error in read.sas7bdat("C:/Documents and Settings/test.sas7bdat") : 
  big endian files are not supported
----------------------

Cheers,

Rebecca

-----Original Message-----
From: Ista Zahn [mailto:istazahn at gmail.com] 
Sent: Wednesday, January 02, 2013 5:25 PM
To: Yuan, Rebecca
Cc: R help; sas-l at listserv.uga.edu
Subject: Re: [R] suggestions about import SAS results to R.

Hi Rebecca,

I've had success with the sas7bdat package ( http://cran.r-project.org/web/packages/sas7bdat/ )

Best,
Ista

On Wed, Jan 2, 2013 at 5:15 PM, Yuan, Rebecca <rebecca.yuan at bankofamerica.com> wrote:
> Hello all,
>
> Thanks for the suggestions.
>
> I tried to import data from sas to R using foreign package. In the 
> first step, I tried to use read.ssd() to convert the sas file 
> sales.sas7bdat to SAS Transport formats. But I got an error message as
> ---------------------------------------------------------------
>> source("testss.r")
> Error in file.symlink(oldPath, linkPath) :
>   symbolic links are not supported on this version of Windows
> ---------------------------------------------------------------
>
> While in testss.r,
>
> ---------------------------------------------------------------
> require(foreign)
> rm(list=ls())
> sashome <- "C:/Program Files/SAS/SASFoundation/9.2/"
> checkfile <- read.ssd("C:/Documents and Settings/test","sales",sascmd 
> = file.path(sashome, "sas.exe"))
> ---------------------------------------------------------------
>
> I am using windows xp and R 2.15.2.
>
> Thanks!
>
> Rebecca
>
>
>
>
> -----Original Message-----
> From: mehmet.suzen at gmail.com [mailto:mehmet.suzen at gmail.com] On Behalf 
> Of Suzen, Mehmet
> Sent: Wednesday, January 02, 2013 4:14 PM
> To: David Winsemius
> Cc: Yuan, Rebecca; R help; sas-l at listserv.uga.edu
> Subject: Re: [R] suggestions about import SAS results to R.
>
>> On Jan 2, 2013, at 12:37 PM, Yuan, Rebecca wrote:
>>> I am wondering if there is an efficient way to read SAS data directly in R, or what would be a better connection between SAS and R if I need to use R to deal with data achieved from SAS?
>>>
>
> You may try foreign and SASxport packages:
> http://cran.r-project.org/web/packages/foreign/index.html
> http://cran.r-project.org/web/packages/SASxport/index.html
>
> But I heard that there might be some issues with the newest SAS version but give it a try...
>
> ----------------------------------------------------------------------
> This message, and any attachments, is for the intended...{{dropped:13}}




More information about the R-help mailing list