Help using Base SAS procedures

using a list in a macro variable to create datasets

Reply
Occasional Contributor
Posts: 12

using a list in a macro variable to create datasets

I would like to create a permanent datasets that contains the first 1000 records of all the datasets in the work directory. I came up with this code:

%let workdsets =

will,

tom,

danny,

timmy

;


data datas.&workdsets._1000;
set work.&workdsets. (obs=1000);
run;

proc export data = datas.&workdsets._1000
outfile = "/xxx/xxxx/xxx/&workdsets._1000.csv"
dbms = csv replace;
run;

it didnt work. what can I do to efficiently create those data sets.

thanks,

will

Super User
Super User
Posts: 7,401

Re: using a list in a macro variable to create datasets

Well:

data _null_;

     set sashelp.vtable (where=(libname="WORK"));

     call execute('proc export data=work.'||strip(memname)||' (obs=1000) outfile="...\'||strip(memname)||'.csv" dbms=csv replace; run;');

run;

The ... indicates path to location.

Occasional Contributor
Posts: 12

Re: using a list in a macro variable to create datasets

thanks RW9 it worked.

Ask a Question
Discussion stats
  • 2 replies
  • 179 views
  • 1 like
  • 2 in conversation