on 11/14/2008 09:12 AM Brigid Mooney wrote: > Hi All, > > Most of the work I am doing with R uses data which I am pulling from various > SQL queries. > > To streamline the process even more, I was wondering if it was possible to > embed SQL queries in R - that way avoiding the need to first get the data, > then move to R to process it. > > I haven't found anything out there on this yet, so if you know of a good > resource that includes this topic, I would really appreciate it. > > Thanks again for all your help!
You can secure data directly from most common relational data sources within R. This is covered in the R Data Import/Export Manual: http://cran.r-project.org/doc/manuals/R-data.html and is also available with your R installation. There is also a R e-mail list specifically on database interfaces: https://stat.ethz.ch/mailman/listinfo/r-sig-db HTH, Marc Schwartz ______________________________________________ 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.