Rather than use ods html to create a .xls file, check out ods
tagsets.ExcelXP and the SHEET_INTERVAL='Bygroup' option. If you modify
your proc report to use age as a by variable rather than a group
variable, you might get the results you're hoping for.
I'm interested to hear how it goes.
On Sep 6, 1:51 pm, datan...@GMAIL.COM ("data _null_;") wrote:
> I want to create an "XL" spread sheet that has some fancy header info.
> Using PROC REPORT as below I can achieve the desired output. This
> example uses technique I learn here on SAS-L. Using HTML and giving
> filetype XLS to the output file.
> But, I would also like to have each level of AGE begin a different
> SHEET. So I have a TAB for every level of AGE.
> I could get a similar result with XL libname engine or PROC EXPORT but
> I want the fancy columns headers that PROC REPORT produces.
> Can it be done?
> ods listing close;
> ods noresults;
> ods html file="class.xls";
> proc report nowd data=sashelp.class;
> column ('Other spanning' age name ('vital statistics' Height weight));
> define age / group noprint;
> define name / order;
> define height / display;
> define weight / display;
> break before age / page;
> compute before _page_;
> line 'Some spanning text';
> line 'AGE=' age 5.;
> ods html close;