操作同一目录下的所有数据集
让一个程序应用于一个目录中所有的数据集
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;