suggestions about import SAS results to R.
On Jan 2, 2013, at 2:44 PM, Yuan, Rebecca wrote:
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
----------------------
That does not mean that "big files" are not supported.
David. > > 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... >> >> ---------------------------------------------------------------------- > David Winsemius Alameda, CA, USA