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
I think this is what you're looking for - though it might be fixed?
I think this is what you're looking for - though it might be fixed?
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
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 🙂
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.