Re: [R] Use SQL in R environment

2016-01-19 Thread MacQueen, Don
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 700

Re: [R] Use SQL in R environment

2016-01-15 Thread Wensui Liu
Check sqldf On Friday, January 15, 2016, Amoy Yang via R-help 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]] > > __

Re: [R] Use SQL in R environment

2016-01-15 Thread Dalthorp, Daniel
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 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! > > A