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 🙂
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.