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 🙂
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.