操作同一目录下的所有数据集

让一个程序应用于一个目录中所有的数据集

 1 libname data 'C:\';
 2 proc sql noprint;
 3 select distinct 'data.'||memname into:name1-:name999 
 4 from sashelp.vtable where libname='DATA';
 5 quit;
 6 
 7 %macro loop;
 8 %do i=1 %to &sqlobs.;
 9 data h&i;
10 set &&name&i;
11 a=1;
12 run;
13 %end;
14 %mend;
15 %loop;

合并同一目录下的所有数据集

1 libname data 'C:\';
2 proc sql noprint;
3 select distinct 'DATA.'||memname into:name separated by ' ' 
4 from sashelp.vtable where libname='DATA';
5 quit;
6 
7 data want;
8 set &name;
9 run;