[R] suggestions about import SAS results to R.

Ista Zahn istazahn at gmail.com
Wed Jan 2 23:25:12 CET 2013


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.




More information about the R-help mailing list