Hi, I am using Base SAS 9,2. I've tried to run the following two basic examples using tagsets.excelxp and tagsets.msoffice2k_x in order to get two or more excel tables side by side in the same sheet, but they do not work. Instead of writing the tables in the same sheet, they generate one file for each table. Does anybody know the solution for this issue ? Thank you. Example of code using TAGSETS.MSOFFICE2K_X : ------------------------------------------------------------------------- ods tagsets.msoffice2k_x file="c:\temp\panels.xls"
options(panelcols="3") style=normal;
proc print data=sashelp.prdsale(obs=10);
var actual predict country region;
where country="CANADA";
title "Canada Sales";
run;
proc print data=sashelp.prdsale(obs=10);
var actual predict country region;
where country="U.S.A.";
title "USA Sales";
run;
proc print data=sashelp.prdsale(obs=10);
var actual predict country region;
where country="GERMANY";
title "Germany Sales";
run;
ods tagsets.msoffice2k_x options(panelcols="2") ;
proc print data=sashelp.prdsale(obs=20);
where region="EAST";
title "East Sales";
run;
proc print data=sashelp.prdsale(obs=20);
where region="WEST";
title "West Sales";
run;
ods tagsets.msoffice2k_x close; Example of code using TAGSETS.EXCELXP: ------------------------------------ ods tagsets.ExcelXP file="c:\temp\file1.xlsx" options(sheet_interval="none"); proc gchart data=sashelp.prdsale; pie product; run; quit; proc print data=sashelp.prdsale; run; ods excel options(sheet_interval="now"); proc print data=sashelp.class; run; ods tagsets.ExcelXP close;
... View more