k*****8
发帖数: 91 | 1 想把两个数据放入同一个Excel的不同工作簿里面。用了两种方法但是都是第二个
dataset把之前的一个dataset覆盖了（i.e.output里面只有demog这个dataset）。请问
这是什么原因？还有什么其他的方法能够实现在一个Excel里面建立多个工作簿？
data test demog;
input id $ sex $ age;
if sex='f' then output test;
else output demog;
datalines;
001 f 9
394 m 10
204 f 20
395 f 3
;
run;
/*Method 1*/
ods listing close;
ods tagsets.excelxp file="c:\temp\test4.xml" style=minimal;
ods tagsets.excelxp options(Sheet_Name='Class Data');
proc print data=test;
run;
ods tagsets.excelxp options(Sheet_Name='Demog Data');
proc print data=demog;
run;
quit;
ods tagsets.excelxp close;
/*method 2*//*I have tried to create an empty excel file with two sheets
named "Sheet 1" and "Sheet 2" respectively, but it gives out only one sheet
within that excel file*/
PROC EXPORT DATA =test
OUTFILE="c:\temp\test.xlsx"
DBMS= xlsx
REPLACE;
sheet = "Sheet1";
RUN;
PROC EXPORT DATA =demog
OUTFILE="c:\temp\test.xlsx"
DBMS= xlsx
REPLACE;
sheet = "Sheet2";
RUN; | l*********y
发帖数: 7 | 2 I just tried the second method you mentioned, and it worked. |
|
