Hi, I'm trying to create a report containing multiple sheets and with tables side by side in one sheet. From what i read so far, best way is to use tagsets because normally ods excell will overwrite the sheet where i try to put tables horizontally. Tagsets on the other hand have problems with multiple sheets, so i need to make the sheets in html format and then link them as sources of sheets(like in the code below)? Is this the best way to do this? I managed to do it in batch mode but when i try to open the excell file i get the message that the path to htmls is wrong. How to set path to htmls so the excell can be just copied between systems? ods msoffice2k path="C:\temp"(url=none) file="file1.html" newfile=output;
proc gchart data=sashelp.prdsale;
pie product;
run;
quit;
proc print data=sashelp.prdsale;
run;
ods msoffice2k close;
ods path(prepend) work.templat(update);
filename temp url "http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/msoffice2k_x.sas"; %include temp;
ods tagsets.msoffice2k_x path="c:\temp" file="test.xls" style=statistical
options(worksheet_source="c:\temp\file1.html,c:\temp\file2.html");
data _null_;
file print;
put _all_;
run;
ods tagsets.msoffice2k_x close;
ods tagsets.msoffice2k_x path="c:\temp" file="test.xls" style=statistical
options( worksheet_source="Graph_ouput#c:\temp\file1.html,
Table_outpu#c:\temp\file2.html" );
data _null_;
file print;
put _all_;
run;
ods tagsets.msoffice2k_x close;
... View more