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

[wcp_fnfg]

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.

[ballardw]

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.