[R] read sas data into R

[Wensui Liu]

Mary,
My feeling is to tell other language read SAS data is like the pain on
the A**. Instead, a solution I'd like to use is to use some
lightweight DB to do the data transfer. For instance, SAS shouldn't
have no problem to libname to a sqlite DB using ODBC and then R is
able to easily read sqlite data.

wensui

On 10/8/07, Mary Royerr <mroyerr at gmail.com> wrote:
> Hi
>
> I am having trouble using read.ssd. Can someone help?
>
> The code that I have written is
>
> *sashome<-"C:/Mary/Datasets"*
> *read.ssd(read.ssd(file.path(sashome, "core", "sashelp"), "surv_1v",*
> *sascmd = file.path(sashome, "sas.exe"))*
>
> Here the path that I have given is correct, where the dataset
> surv_1v.sas7bdat is kept. The message that R gives me is this:
>
> *SAS failed.  SAS program at
> C:\DOCUME~1\Royerm02\LOCALS~1\Temp\Rtmpdi2Osb\file4ff053f7.sas
> The log file will be file4ff053f7.log in the current directory
> NULL
> Warning messages:
> 1: "C:/Mary/Datasets /sas.exe" not found in: system(paste(sascmd, tmpProg))
> 2: SAS return code was -1 in: read.ssd(file.path("C:/Mary/Datasets",
> >
> *
> what do I do? The help for read.ssd does not help either. So any help will
> be greatly appreciated.
>
> Mary
>
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
>


-- 
===============================
WenSui Liu
Statistical Project Manager
ChoicePoint Precision Marketing
(http://spaces.msn.com/statcompute/blog)