topic Re: Creating new sheets in ODS EXCEL in ODS and Base Reporting

Creating new sheets in ODS EXCEL

TomKari — Tue, 02 Aug 2016 18:44:52 GMT

Hi, all

I'm creating reports for a client using PROC REPORT. It's going great, but I'd like to direct the output to Excel using "ODS EXCEL".

Ideally, I'd like to have all of the reports for a "chapter" (user-defined) come out on one spreadsheet, one after the other, and then start a new spreadsheet for reports for the next chapter.

So far, I can EITHER get all the reports on one sheet, one after the other, OR I can get every report on a new sheet.

All help would be appreciated!

Tom

Re: Creating new sheets in ODS EXCEL

Reeza — Tue, 02 Aug 2016 19:19:28 GMT

I think this is what you're looking for - though it might be fixed?

https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-excel-amp-multiple-sheets/m-p/261953/highlight/true#M15551

Re: Creating new sheets in ODS EXCEL

TomKari — Wed, 03 Aug 2016 22:32:14 GMT

Thank you Reeza!

As usual, your brilliant comment saves the day. I never would have thought of this in 8 million years.

I've tested it with quite an extensive set of reports that I had already created, and it works perfectly.

Tom

Re: Creating new sheets in ODS EXCEL

Reeza — Wed, 03 Aug 2016 22:42:33 GMT

I can't take the credit, it was from somewhere else, the links in the question.

I'm very lucky to have a memory that remembers a lot of random info though 🙂