Now it sounds like a consense that it is not advisable to do everything in R but to use a database system and scripting language instead for the rough work.

Thanks for all of your suggestions!
  Werner
  

Steve Miller <steve.miller@jhu.edu> schrieb: 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@stat.math.ethz.ch
[mailto:r-help-bounces@stat.math.ethz.ch] On Behalf Of bogdan romocea
Sent: Friday, April 21, 2006 7:59 AM
To: pensterfuzzer@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@stat.math.ethz.ch
> [mailto:r-help-bounces@stat.math.ethz.ch] On Behalf Of Werner
> Wernersen
> Sent: Friday, April 21, 2006 7:09 AM
> To: r-help@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@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@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



		
---------------------------------

	[[alternative HTML version deleted]]


