测试代码:
- options noxwait noxsync;
- data _null_;
- rc = system('start excel');
- rc = sleep(2);
- run;
- filename myxls DDE 'EXCEL|System' notab;
- %let file=cc;
- data _null_;
- file myxls;
- put '[close()]';
- put "[open(""d:\test.xls"")]";
- put '[workbook.name("Table 1 - 详细报表与 或汇总报表", "sheet1")]';
- put '[file.close(true)]';
- put '[quit()]';
- run;
- filename myxls clear;