How to avoid page breaks in sas proc tabulate?i want all the tables in one page. i am using ODS excel.
Show your code.
Include our ODS Excel statement.
If you have sheet_interval='TABLE', which is the default, and proc tabulate generates two or more tables then you have told it to place the results on two or more sheets.
Likely you need to add the option sheet_interval='PROC' to sent all output from the proc to a single sheet.
Does the information fit on a single page?
If not, you need to modify the style/font to force it to fit, if possible. Or are you getting page breaks somewhere else? Do you have PAGE variable in your table? If you can provide some more details we can probably offer some options.
PS. I'm moving your post to the ODS and Base Reporting forum.
@VISHNU239 wrote:
How to avoid page breaks in sas proc tabulate?i want all the tables in one page. i am using ODS excel.
yes. I want all the information in a single sheet and using options(sheet_interval='none') after ods excel statement worked for me in enterprise guide.
Show your code.
Include our ODS Excel statement.
If you have sheet_interval='TABLE', which is the default, and proc tabulate generates two or more tables then you have told it to place the results on two or more sheets.
Likely you need to add the option sheet_interval='PROC' to sent all output from the proc to a single sheet.
thanks Cynthia it worked.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.