Hello
In following code I export multiple tables to multiple sheets.
In sheet1 there will be 2 tables
In sheet2 there will be 2 tables
My question is how to tell SAS to locate the tables in following location:
Sheet1-table1 will be located from cell A1,table2 will be located from cell A15
Sheet2-table1 will be located from cell A1,table2 will be located from cell A15
Title;
ods tagsets.excelxp file="path/test1.xls" style=minimal
options(sheet_interval="none" sheet_name='Sheet1');
proc print data=sashelp.class(obs=5)noobs;
run;
proc print data=sashelp.air(obs=5) noobs;
run;
ods tagsets.excelxp options(sheet_interval="none" sheet_name='Sheet2');
proc print data=sashelp.orsales(obs=5)noobs;
run;
proc print data=sashelp.prdsale(obs=5)noobs;
run;
ods tagsets.excelxp close;
