topic Re: proc download in SAS Programming

proc download

SASPhile — Fri, 06 Aug 2010 14:41:34 GMT

how do to download all the datasets from server which have _sk in their dataset names to a library on my local machine.
for instance:
dataset RTLWP_FF00016I_sk needs to be downloaded to wfr library.
I have around 20 datasets which have _sk

There is a chance to miss out some of the datasets if i have to type them in as i did below.
proc download data=RTLWP_FF00016I_sk out=wfr.RTLWP_FF00016I_sk; run;

Re: proc download

darrylovia — Fri, 06 Aug 2010 17:16:12 GMT

i would set up a libname statement to connect the DB. then use the SAS DICTIONARY tables to get a listing of the tables in the DB. After that you'll have a table with the contents of the database.

for example:
proc sql;
create table db_contents as
select *
from DICTIONARY.TABLES
where libname='SASHELP';
quit;

Re: proc download

darrylovia — Fri, 06 Aug 2010 17:24:32 GMT

For an example with ORACLE. I tried this and it works.

libname ora ORACLE user=&user password=&pw path=&path schema=&schema;

proc sql;
create table ora_contents as
select *
from DICTIONARY.TABLES
where libname='ORA';
quit;