Skip to content
Back to formatted view

Raw Message

Message-ID: <419EED2318C2164DB95FBB20AA8810D8D0CF@smtp_mail.bankofamerica.com>
Date: 2013-01-02T22:15:01Z
From: Yuan, Rebecca
Subject: suggestions about import SAS results to R.
In-Reply-To: <CAPtbhHxADoCOF59JXOMA6WKBt5kbbYkEA-t0kahkuBxu0mp0pA@mail.gmail.com>

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}}