[R] Use SQL in R environment

MacQueen, Don macqueen1 at llnl.gov
Tue Jan 19 19:26:12 CET 2016


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.



More information about the R-help mailing list