I am looking for a way to tell excel "put a page break at this row" using an output with excelxp and proc report.
Thanks!
Hi:
As far as I know, there is no way for SAS or ODS to operate the menu choices that are on the Excel ribbon, such as highlighting a row and then selecting Page Layout --> Breaks --> Insert Page Break. You can influence printing to some extent with the suboptions for FitToPage and/or Pages_FitWidth or Pages_FitHeight, but that is not the same as setting the Print Area or inserting Page Breaks using Excel menu options. To reveal the suboptions available to use in your version of TAGSETS.EXCELXP, add the doc='HELP' suboption to your invocation:
ods tagsets.excelxp file='c:\temp\showcars.xml'
options(doc='Help') style=sasweb;
Also, this paper talks in a lot of detail about suboptions and how to use them (http://www.nesug.org/proceedings/nesug08/ap/ap06.pdf), look at page 5, for example.
cynthia
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.