[R] Considering port of SAS application to R

Steve Miller steve.miller at jhu.edu
Fri Apr 21 15:09:12 CEST 2006


Good suggestion. Multiple gigabytes is stretching it with R. Use PostgreSQL
Python, and Python DBI database connectivity to replace your SAS data step,
then use the RODBC package to import data into R "convenience stores" as
appropriate.

Steve Miller

-----Original Message-----
From: r-help-bounces at stat.math.ethz.ch
[mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of bogdan romocea
Sent: Friday, April 21, 2006 7:59 AM
To: pensterfuzzer at yahoo.de
Cc: r-help
Subject: Re: [R] Considering port of SAS application to R

Forget about R for now and port the application to MySQL/PostgreSQL
etc, it is possible and worthwhile. In case you happen to use (and
really need) some SAS DATA STEP looping features you might be forced
to look into SQL cursors, otherwise the port should be (very)
straightforward.


> -----Original Message-----
> From: r-help-bounces at stat.math.ethz.ch
> [mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Werner
> Wernersen
> Sent: Friday, April 21, 2006 7:09 AM
> To: r-help at stat.math.ethz.ch
> Subject: [R] Considering port of SAS application to R
>
> Hi there!
>
> I am considering to port a SAS application to R and I would
> like to hear your opinion if you think this is possible and
> worthwhile. SAS is mainly used to do data management and then
> to do some aggregations and simple computations on the data
> and to output a modified data set. The main problem I see is
> the size of the data file. As I have no access to SAS yet I
> cannot give real details but the SAS data file is about 7
> gigabytes large. (It's only the basic SAS system without any
> additional modules)
>
> What do you think, would a port to R be possible with
> reasonable effort? Is R able to handle that size of data? Or
> is R prepared to work together with some database system?
>
> Thanks for your thoughts!
>
> Best regards,
>   Werner
>
> 		
> ---------------------------------
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html
>

______________________________________________
R-help at stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html




More information about the R-help mailing list