Creating an Excel file report

[kajal_30]

Hi Team,

I am creating one excel report from a dataset with two months of data set and I want to create 2 tables on one tab in excel file for each months data.

Please help

Thanks

[PaigeMiller]

---

@kajal_30 wrote:

Hi Team,

I am creating one excel report from a dataset with two months of data set and I want to create 2 tables on one tab in excel file for each months data.

If you are using ODS EXCEL, you can use the option sheet_interval='NONE' which forces all output onto one tab (until you change it).

[Cynthia_sas]

Since there's no date, here's an example using SASHELP.CLASS and using BY group processing for 2 age values:

If you don't like the BY line, you can turn that off using system options.

Hope this helps,

Cynthia

[kajal_30]

Thanks For your reply.

While using the same approach it says 

ERROR: Unable to load module 'SpreadsheetML' from template store!

EROR: No body file.EXCEL output will not be created.

[Cynthia_sas]

Hi:
What version of SAS are you running? To find out, do this:
proc setinit;
run;
The version information will be at the top of the details written to the SAS log.

Cynthia