如何批量导出表到EXCEL

shiyiming

设有表1000个，表名分别为：table1，table2 ......，table1000，如何批量导出表到EXCEL，文件名分别为table1.xls，table2.xls ......，table1000.xls?

shiyiming

%macro excel;
do% i=1 %to 1000;
proc export data=ds&i;
outfile="c\table&i.xls";
dbms=excel;
%let i=%eval(&i+1);
%end;
%mend;
%excel