proc download

[SASPhile]

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;

[darrylovia]

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;

[darrylovia]

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;