Using ODS EXCEL to produce PROC FREQ results on one page - help

[joesmama]

Hello.

Looking to export several PROC FREQ tables onto one sheet in an Excel workbook. I've looked around for possible suggestions to help but can;t find anything. Am I missing an option somewhere? I am using ODS EXCEL to produce the file but each table is on a seperate sheet and I'd like to figure out how to get everything on one sheet. 

Any help would be appreciated.  Thank you. 

[Reeza · Accepted solution]

Look at the SHEET_INTERVAL option on ODS EXCEL. Set it to none to have all go to a single sheet.

[joesmama]

Thank you. It worked like a charm!

[ballardw]

You may be interested in knowing that you can change the interval setting between output generating processes by inserting additional ODS Excel with different sheet_interval options.

[joesmama]

Thank you. That will come in very handy.