[R] suggestions about import SAS results to R.

[Ista Zahn]

Well it was worth a try. If you haven't solved the problem some other
way I suggest exporting from SAS to a plain text format like .csv and
read into R with read.table.

Best,
Ista

On Wed, Jan 2, 2013 at 5:44 PM, Yuan, Rebecca
<rebecca.yuan at bankofamerica.com> 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
> ----------------------
>
> 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
>> r...{{dropped:2}}
>>
>> ______________________________________________
>> R-help at r-project.org mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide
>> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>
> ----------------------------------------------------------------------
> This message, and any attachments, is for the intended...{{dropped:6}}