I hope any one can help me on this.
I formatted my report and exported to Excel using the following code. I get two excel files with the format and style I wanted.
ods html file="="C:\report1.xls" style=minimal;
ods noptitle;
proc report data=report1 …..;
SAS code ….
ods html file="C:\report2.xls" style=minimal;
ods noptitle;
proc report data=report2 ….;
SAS code ….
title1 font=calibri bold "CUSTOMER DATA";
title2 font=calibri bold “FY2009" ;
title3 font=calibri bold “Region2”;
run ;
ods html close;
However, I want to put “report1” and “report2” into the same excel file with two tabs. So I used the tagsets.excelxp as show. However, I lost the most all my styles and formats from code above.
ODS tagsets.excelxp file = ="C:\report.xls"
proc report data=report1 …..;
SAS code ….
proc report data=report2 ….;
SAS code ….
title1 font=calibri bold "CUSTOMER DATA";
title2 font=calibri bold “FY2009" ;
title3 font=calibri bold “Region2”;
run ;
ods tagsets.excelxp close;
... View more