Hi All, I am new here and a beginner for R. Can I use SQL procedure in R environment as it can be done in SAS starting with?PROC SQL; Thanks for helps! Amoy [[alternative HTML version deleted]]
Very general question...try searching "R SQL" on google for a start. On Fri, Jan 15, 2016 at 9:59 AM, Amoy Yang via R-help <r-help at r-project.org> wrote:> Hi All, > I am new here and a beginner for R. Can I use SQL procedure in R > environment as it can be done in SAS starting with PROC SQL; > Thanks for helps! > > Amoy > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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.-- Dan Dalthorp, PhD USGS Forest and Rangeland Ecosystem Science Center Forest Sciences Lab, Rm 189 3200 SW Jefferson Way Corvallis, OR 97331 ph: 541-750-0953 ddalthorp at usgs.gov [[alternative HTML version deleted]]
Check sqldf On Friday, January 15, 2016, Amoy Yang via R-help <r-help at r-project.org> wrote:> Hi All, > I am new here and a beginner for R. Can I use SQL procedure in R > environment as it can be done in SAS starting with PROC SQL; > Thanks for helps! > > Amoy > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org <javascript:;> mailing list -- To UNSUBSCRIBE and > more, see > 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.-- WenSui Liu https://statcompute.wordpress.com/ [[alternative HTML version deleted]]
If you're wanting to retrieve data from external databases (I vaguely recall that is what SAS's proc sql does), then start by looking at the DBI package, which provides support for ROracle, RMySQL, and several more. There is also RODBC. -- Don MacQueen Lawrence Livermore National Laboratory 7000 East Ave., L-627 Livermore, CA 94550 925-423-1062 On 1/15/16, 9:59 AM, "R-help on behalf of Amoy Yang via R-help" <r-help-bounces at r-project.org on behalf of r-help at r-project.org> wrote:> Hi All, >I am new here and a beginner for R. Can I use SQL procedure in R >environment as it can be done in SAS starting with PROC SQL; >Thanks for helps! > >Amoy > [[alternative HTML version deleted]] > >______________________________________________ >R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see >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.