The SAS Output Delivery System and reporting techniques

proc tabulate page break

Accepted Solution Solved
Reply
Contributor
Posts: 29
Accepted Solution

proc tabulate page break

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


Accepted Solutions
Solution
‎06-11-2018 11:23 PM
Super User
Posts: 13,942

Re: proc tabulate page break

Posted in reply to VISHNU239

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.

View solution in original post


All Replies
Super User
Posts: 24,026

Re: proc tabulate page break

Posted in reply to VISHNU239

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.


 

Contributor
Posts: 29

Re: proc tabulate page break

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.

Solution
‎06-11-2018 11:23 PM
Super User
Posts: 13,942

Re: proc tabulate page break

Posted in reply to VISHNU239

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.

SAS Super FREQ
Posts: 9,434

Re: proc tabulate page break

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
Contributor
Posts: 29

Re: proc tabulate page break

Posted in reply to Cynthia_sas

thanks Cynthia it worked.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 423 views
  • 3 likes
  • 4 in conversation