[R vs SAS] 데이터베이스에서 읽기(ODBC Connection)

1. SAS

libname mydblib odbc dsn='dsname' user='username' pw='psswd';

data dsname;

set mydblib.Table1;

run;

2. R

library(RODBC)

mydbcon <- odbcconnect("dsname", uid="username", pwd="passwd")

qrystr <- "select * from Table1"

dsname <- sqlQuery(mydbcon, qrystr, as.is=TRUE)