topic Re: Creating an Excel file report in SAS Programming

Creating an Excel file report

kajal_30 — Thu, 23 Jul 2020 10:28:32 GMT

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

Re: Creating an Excel file report

PaigeMiller — Thu, 23 Jul 2020 10:31:06 GMT

@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).

Re: Creating an Excel file report

Cynthia_sas — Thu, 23 Jul 2020 17:31:31 GMT

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

Re: Creating an Excel file report

kajal_30 — Fri, 24 Jul 2020 15:13:03 GMT

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.

Re: Creating an Excel file report

Cynthia_sas — Fri, 24 Jul 2020 16:44:57 GMT

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