topic Re: proc tabulate page break in ODS and Base Reporting

proc tabulate page break

VISHNU239 — Mon, 11 Jun 2018 00:18:16 GMT

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

Re: proc tabulate page break

Reeza — Mon, 11 Jun 2018 01:17:50 GMT

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.

Re: proc tabulate page break

ballardw — Mon, 11 Jun 2018 14:49:40 GMT

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.

Re: proc tabulate page break

Cynthia_sas — Mon, 11 Jun 2018 14:58:42 GMT

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

Re: proc tabulate page break

VISHNU239 — Tue, 12 Jun 2018 03:24:25 GMT

thanks Cynthia it worked.

Re: proc tabulate page break

VISHNU239 — Tue, 12 Jun 2018 03:27:18 GMT

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.