The SAS Output Delivery System and reporting techniques

Insert Page Break with ODS Tagsets.ExcelXP?

Reply
Frequent Contributor
Posts: 84

Insert Page Break with ODS Tagsets.ExcelXP?

Is there anything I can do to force a page break?  I already have pages_fitwidth = '1' pages_fitheight = '2', I basically want to say after this table, create the next page.

Using excelxp, with proc report, output to .xml

SAS Super FREQ
Posts: 8,820

Re: Insert Page Break with ODS Tagsets.ExcelXP?

Hi:

  The page controls that are available in the sub-options are all you have for TAGSETS.EXCELXP. I do not think that SAS and ODS can reach to the Excel menu to do a key-click for how to insert explicit page breaks. But that would be a question for Tech Support to get the definitive answer.

cynthia


excel_insert_page_break.png
Ask a Question
Discussion stats
  • 1 reply
  • 524 views
  • 0 likes
  • 2 in conversation