'ODBC'에 해당되는 글 2건

  1. 2007.04.25 connect to odbc
  2. 2007.04.25 library setting
04.IT Knowledge/SAS2007. 4. 25. 14:05

connect to odbc

proc sql;
    connect to odbc(datasrc=odbc_name schema=schema_name user=user_name password=passwd);
        create table library.target_table as
        select *
          from connection to odbc(
SELECT * FROM source_table
);
    disconnect from odbc;
quit;

********************************************
*
* Do your best!!
*
* Homepage : http://www.javarang.net
* Javarang Lee
*
********************************************
Posted by 아주 오래된 미래
04.IT Knowledge/SAS2007. 4. 25. 13:56

library setting

/* Oracle Library setting */
libname library_name oracle readbuff=2500 direct_exe=delete path=dbname schema=user_id user=user_id password="userpassword"

/* MS Access Library setting */
libname library_name access 'file full path'

/* DBF */
filename dataset_name "file full path";
proc dbf db3=dataset_name out=lib_name.dataset_name;
run;

/* ODBC */
libname library_name odbc datasrc=data_source_name user=user_id password=user_password;


********************************************
*
* Do your best!!
*
* Homepage : http://www.javarang.net
* Javarang Lee
*
********************************************

Posted by 아주 오래된 미래

티스토리툴바