The SAS Output Delivery System and reporting techniques

How to create multiple sheets in one Excel speadsheet with ODS

Reply
N/A
Posts: 0

How to create multiple sheets in one Excel speadsheet with ODS

I use proc tabulate to create tables and then use ODS to convert the tables into Excel speadsheet. Now I have several tables and want to have them in one Excel file workbook as different sheets, how can I do that?

Your help is greatly appreciated!
SAS Employee
Posts: 174

Re: How to create multiple sheets in one Excel speadsheet with ODS

Take a look at the PowerPoint presentation:

Creating Multi-Sheet Excel Workbooks with ODS

You can find it at the ODS section of the Base focus area of support.sas.com:

http://support.sas.com/rnd/base/ods/index.html

-- David Kelley, SAS
Ask a Question
Discussion stats
  • 1 reply
  • 113 views
  • 0 likes
  • 2 in conversation