DATA Step, Macro, Functions and more

proc download

Reply
Super Contributor
Posts: 647

proc download

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;
Frequent Contributor
Posts: 139

Re: proc download

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;
Frequent Contributor
Posts: 139

Re: proc download

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;
Ask a Question
Discussion stats
  • 2 replies
  • 177 views
  • 0 likes
  • 2 in conversation