libnameを定義して、DBをSASのオブジェクトだと考える。
libname (libname) oracle user=(uname) pass(pw) path=(orclパス); proc print data=(libname).(tablename) (obs=1); run;
DBがOS認証の場合は、orclパスだけ指定すればいい。
libname (libname) oracle path=(orclpath); proc print data=(libname).all_tables(obs=1); run;
パススルー機能(SASから直接DBをたたける)を利用
proc sql; connect to oracle(user=(uname) pass=(pw) path=(orclpath)); select * from connection to oracle ( (SQL) ); quit;
proc sql; connect to oracle(user=... pass=... path=...); create table test.testtable as select * from connection to oracle ( (SQL) ); quit;
/* SASライブラリ*/ libname sasdata "XXX"; /* Oracleライブラリ */ libname oradata oracle user=XXX pass=XXX path=XXX; /* Oracleテーブルを作成 */ data oradata.summary; set sasdata.summary; run;
libname (libname) oracle user=... pass=... path=...; proc access dbms=oracle; create (libname).test.access; table=dwh_product_cd; path=(orclpath); list; run;
proc sql; connect to mysql (user=... password=... server=... database=... port=(port#)); execute (select * from tmp) by mysql; disconnect from mysql; quit;