Creating new sheets in ODS EXCEL

[TomKari]

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

[Reeza · Accepted solution]

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/highl...

[TomKari]

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

[Reeza]

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 🙂