求助：SAS2EXCEL？

shiyiming

如何将SAS数据集中的18位身份证号（全为数字）和相应的变量描述正确地到导出到Excel？

shiyiming

First, change the ID column to text format on Excel, then save it.

SAS code:

filename myid DDE 'Excel|c:\mydir\[myexcelname.xls]sht1!r2c1:r10c5';
data _null_;
set idset;
file myid;
put id '09'x age '09'x.......;
run;

Good luck!