Problem Description:
I'm creating tables using PROC TABULATE and have set up a footnote stating 'Page x of y' using the ODS ESCAPECHAR functionality. 'Page x of y' for each table is independent of the other tables - e.g. if I have 3 tables each of 2 pages, then the footnote will be Page 1 of 2 & Page 2 of 2 for each of the 3 tables.
The resulting tables are output to one PDF file.
I want to maintain the page numbering for each table independent of the others i.e. Page 1 of 2, Page 2 of 2 rather than Page 1 of 6 etc..
Is there a way of resetting the page numbering for each new PROC TABULATE within the ODS PDF statements?
I can reset the current page number using OPTIONS PAGENO=1 in between each PROC TABULATE, but this doesn't solve the resetting of the {lastpage} value.
The code below is just a PROC PRINT of the SASHELP dataset CLASS to get my point across. This has output Page 1 of 2 and Page 2 of 2, but really I would want Page 1 of 1 for the first PROC PRINT and Page 1 of 1 for the second PROC PRINT.
... View more