sas数据集怎么导出_求助：怎样使大量SAS数据完整导出到EXCEL里？

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  da