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
*
********************************************
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
*
********************************************
