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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of bogdan romocea Sent: Friday, April 21, 2006 7:59 AM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Werner > Wernersen > Sent: Friday, April 21, 2006 7:09 AM > To: [email protected] > 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]] > > ______________________________________________ > [email protected] mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html > ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
