topic Re: Using ODS EXCEL to produce PROC FREQ results on one page - help in New SAS User

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

joesmama — Mon, 06 May 2019 16:40:10 GMT

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.

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

Reeza — Mon, 06 May 2019 16:44:02 GMT

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

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

joesmama — Mon, 06 May 2019 16:51:37 GMT

Thank you. It worked like a charm!

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

ballardw — Mon, 06 May 2019 19:49:58 GMT

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.

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

joesmama — Mon, 06 May 2019 20:01:52 GMT

Thank you. That will come in very handy.