R help - Dec 2010 - Importing Sas files to R

Dear All,

Am trying to import SAS files to R.

For that i used library "Hmisc" and

try<-sas.get("C:\\ex.sas7bdat") . But it shows error that

Error in sas.get("C:\\ex.sas7bdat") : SAS member name is required
In addition: Warning message:
In sas.get("C:\\ex.sas7bdat") :
  C:\ex.sas7bdat/formats.sc? or formats.sas7bcat  not found. Formatting
ignored.




Thanks in Advance.


-- 
*Best Regards,
Reka.


*

	[[alternative HTML version deleted]]

> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at
r-project.org]
> On Behalf Of Rekha
> Sent: Monday, December 27, 2010 8:33 PM
> To: r-help at r-project.org
> Subject: [R] Importing Sas files to R
> 
> Dear All,
> 
> Am trying to import SAS files to R.
> 
> For that i used library "Hmisc" and
> 
> try<-sas.get("C:\\ex.sas7bdat") . But it shows error that
> 
> Error in sas.get("C:\\ex.sas7bdat") : SAS member name is required
> In addition: Warning message:
> In sas.get("C:\\ex.sas7bdat") :
>   C:\ex.sas7bdat/formats.sc? or formats.sas7bcat  not found. Formatting
> ignored.
> 
> 
> 
> 
> Thanks in Advance.
> 
> 
> --
> *Best Regards,
> Reka.
> 
I presume you have SAS installed on your system and the path to the SAS.exe
executable is in your Windows path environment variable, and the file,
ex.sas7bdat, is in the root directory of your C: dive.  You might try something
like

try<-sas.get("C:/", "ex")

If SAS is not in your path then you will need to specify where to find it.  This
would work on my system, your SAS location might be different.  The first
parameter is libraryName and should contain the Windows directory where your
dataset is located.  The second parameter is member and should contain the
dataset name (without the sas7bdat extension)

try<-sas.get("C:/", "ex", sasprog= "C:/Program
Files/SAS/SASFoundation/9.2/sas.exe")

If you don't have access to SAS on your system, this will not work.


Hope this is helpful,

Dan  

Daniel Nordlund
Bothell, WA USA

Reka,

If you do not have SAS available, there is also a free program provided by
SAS called the SAS System Viewer, which will export sas7bdata files to csv. 
N.b. that I've heard it can be buggy if any character variables contain
unmatched quotes.  I've also read in a previous post
(http://r.789695.n4.nabble.com/Reading-sas7bdat-files-directly-td1469515.html)
of a program written by Chris Long called dsread
(http://www.oview.co.uk/dsread), which will do the trick.  I haven't used it
yet, but it sounds a lot better than fumbling through the SAS System Viewer.

Jeremy

Jeremy T. Hetzel
Boston University
-- 
View this message in context:
http://r.789695.n4.nabble.com/Importing-Sas-files-to-R-tp3165690p3168660.html
Sent from the R help mailing list archive at Nabble.com.