proc tabulate page break

[VISHNU239]

How to avoid page breaks in sas proc tabulate?i  want all the tables in one page. i am using ODS excel.

[Reeza]

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.

---

[VISHNU239]

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.

[ballardw · Accepted solution]

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.

[Cynthia_sas]

Hi:
OR use sheet_interval='none' -- whether you use PROC or NONE, depends on your code and what your end result is and what your TABLE statement is.
Cynthia

[VISHNU239]

thanks Cynthia it worked.