The SAS Output Delivery System and reporting techniques

ODS Tagset.ExcelXp - Page Break or New Tab after X observations

Reply
Frequent Contributor
Posts: 84

ODS Tagset.ExcelXp - Page Break or New Tab after X observations

So my tabulate has a lot of rows, which makes printing difficult.  If I set page width to 1 and height to 1, then it's too compressed, if I set height to something else, I lose the table headings.  So I'm trying to come up with a solution that will either repeat the tabulate headings or, ideally, start a new tab beginning at observation X.  Perhaps print up to 50 rows to a page and start a new tab after that.

Grand Advisor
Posts: 10,210

Re: ODS Tagset.ExcelXp - Page Break or New Tab after X observations

If I really wanted to control proc tabulate output I would add a variable to the data set I could use for a Page setting.

One approach would be to have a level for some number of the first class variable in a table. The fun part is coming up with a nice variable name or label to appear at the top of each section, though Section may work.

If your tow class variables have large differences in the numbers of levels you could also pre-summarize the data to determine likely page break places and then add the Page level variable.

Tagsets.Rtf has some additional controls for the documents created that may help but I seldom get the tables to break exactly where I want.

Your specific ODS destination, which you don't mention, may have some additional choices.

Ask a Question
Discussion stats
  • 1 reply
  • 267 views
  • 0 likes
  • 2 in conversation