wslirunping 发表于 2010-3-14 22:56
对,数据的变量有480多个,我只能导出256个,我就是不知道怎么导出到几张表格里?望赐教!Here is an example.
Hope this helps.
data tmp;
array var(500);
do i = 1 to 500;
var(i)=i;
end;
keep var:;
run;
proc print; run;
proc sql noprint;
select name into: vlist1 separated by ' '
from dictionary.columns
where upcase(libname)='WORK' and upcase(memname)='TMP'
and varnum<=256
;
select name into: vlist2 separated by ' '
from dictionary.columns
where upcase(libname)='WORK' and upcase(memname)='TMP'
and varnum>256
;
quit;
%put >>>> &vlist1 ;
%put >>>> &vlist2 ;
PROC EXPORT DATA=tmp(keep= &vlist1)
OUTFILE="c:\downloads\ExcelFile.xls"
DBMS=EXCEL
REPLACE
;
SHEET="var1_256";
RUN;
PROC EXPORT DATA=tmp (keep= &vlist2)
OUTFILE="c:\downloads\ExcelFile.xls"
DBMS=EXCEL
REPLACE
;
SHEET="var256_up";
RUN;
**********************log*************************
258 d