The SAS Output Delivery System and reporting techniques

Creating new sheets in ODS EXCEL

Accepted Solution Solved
Reply
PROC Star
Posts: 1,167
Accepted Solution

Creating new sheets in ODS EXCEL

[ Edited ]

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


Accepted Solutions
Solution
‎08-03-2016 06:30 PM
Super User
Posts: 19,791

Re: Creating new sheets in ODS EXCEL


All Replies
Solution
‎08-03-2016 06:30 PM
Super User
Posts: 19,791

Re: Creating new sheets in ODS EXCEL

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

PROC Star
Posts: 1,167

Re: Creating new sheets in ODS EXCEL

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

Super User
Posts: 19,791

Re: Creating new sheets in ODS EXCEL

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 Smiley Happy

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 412 views
  • 1 like
  • 2 in conversation