The argument for SAS (and Stata) when working with large dataset comes up fairly often. I have not had much experience in this area, but have been pleasantly surprised using R in combination with an SQL interface, in situations with modestly large, messy datasets. I certainly would appreciate comments on the relative merits from anyone that has more experience in this area.
Paul Gilbert Walter Paczkowski wrote: > Good morning, > > I use SAS and R/S-Plus as my primary tools so I have a lot of experience with > these programs. By far and away, SAS is superior for handling the "messy" > datasets, but also the very large ones. I work at times with datasets in the > hundreds of thousands (and on occasion, millions) of records. SAS, and > especially PROC SQL, are invaluable for this. But once I get to datasets > manageable for R/S-Plus, then I ship to these tools for the programming and > graphics. This seems to work great. > > Walt Paczkowski > Data Analytics Corp. > > > -----Original Message----- > >>From: Rob Robinson <[EMAIL PROTECTED]> >>Sent: Jan 17, 2008 4:31 AM >>To: [EMAIL PROTECTED] >>Subject: Re: [R] things that are difficult/impossible to do in SAS or SPSSbut >>simple in R >> >> >>I wonder if those who complain about SAS as a programming environment have >>discovered SAS/IML which provides a programming environment akin to Matlab >>which is more than capable (at least for those problems which can be treated >>with a matrix like approach). As someone who uses both SAS and R - graphical >>output is so much easier in R, but for handling large 'messy' datasets SAS >>wins hands down... >>Cheers >>Rob >> >>*** Want to know about Britain's birds? Try www.bto.org/birdfacts *** >> >>Dr Rob Robinson, Senior Population Biologist >>British Trust for Ornithology, The Nunnery, Thetford, Norfolk, IP24 2PU >>Ph: +44 (0)1842 750050 E: [EMAIL PROTECTED] >>Fx: +44 (0)1842 750030 W: http://www.bto.org >> >>==== "How can anyone be enlightened, when truth is so poorly lit" ===== >> >> >> >>>-----Original Message----- >>>From: [EMAIL PROTECTED] >>>[mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey J. Hallman >>>Sent: 16 January 2008 22:38 >>>To: [EMAIL PROTECTED] >>>Subject: Re: [R] things that are difficult/impossible to do >>>in SAS or SPSSbut simple in R >>> >>>SAS has no facilities for date arithmetic and no easy way to >>>build it yourself. In fact, that's the biggest problem with >>>SAS: it stinks as a programming environment, so it's always >>>much more difficult than it should be to do something new. >>>As soon as you get away from the canned procs and have to >>>write something of your own, SAS falls down. >>> >>>I don't know enough about SPSS to comment. >>>-- >>>Jeff >>> >>>______________________________________________ >>>R-help@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. >>> >> >>______________________________________________ >>R-help@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. > > > ______________________________________________ > R-help@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. ==================================================================================== La version française suit le texte anglais. ------------------------------------------------------------------------------------ This email may contain privileged and/or confidential information, and the Bank of Canada does not waive any related rights. Any distribution, use, or copying of this email or the information it contains by other than the intended recipient is unauthorized. If you received this email in error please delete it immediately from your system and notify the sender promptly by email that you have done so. ------------------------------------------------------------------------------------ Le présent courriel peut contenir de l'information privilégiée ou confidentielle. La Banque du Canada ne renonce pas aux droits qui s'y rapportent. Toute diffusion, utilisation ou copie de ce courriel ou des renseignements qu'il contient par une personne autre que le ou les destinataires désignés est interdite. Si vous recevez ce courriel par erreur, veuillez le supprimer immédiatement et envoyer sans délai à l'expéditeur un message électronique pour l'aviser que vous avez éliminé de votre ordinateur toute copie du courriel reçu. ______________________________________________ R-help@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.
