topic Re: How do find the very last page in proc report in ODS Pdf and wirte the sumry info at very last p in ODS and Base Reporting

How do find the very last page in proc report in ODS Pdf and wirte the sumry info at very last page

Inp — Thu, 16 Aug 2018 17:47:11 GMT

Dear,

Attached here my coding . I wanted to write the summary information at the very last page. I already find the very large page number in advance, but when I add the summary , it populate additional page and summary is being written on the page before the last page and the last page. Also part of the report is also written on the last page as well where it suppose to write on the page before last page.

Your help is much appreciated in advance.

Thanks

Anton R

Re: How do find the very last page in proc report in ODS Pdf and wirte the sumry info at very last p

ballardw — Thu, 16 Aug 2018 19:30:08 GMT

Are you trying to force something to be part of a result table or do you just want a summary after the existing report?

It would like be much easier to just have separate procedure call to do an overall summary afterward.

Re: How do find the very last page in proc report in ODS Pdf and wirte the sumry info at very last p

Inp — Thu, 16 Aug 2018 20:04:56 GMT

Hi ballardw

I want to write the summary is part of the table. Actually I want to write the summary at the end of the detail lines. I don't want to write the summary on separate page.

Thanks

Anton

Re: How do find the very last page in proc report in ODS Pdf and wirte the sumry info at very last p

Cynthia_sas — Fri, 17 Aug 2018 22:36:32 GMT

Hi:

It seems to me that you want something like this:

which was done with 2 PROC REPORT steps. The first PROC REPORT did the tables using PAGE for Canada and Pacific and the second PROC REPORT just did the Grand Total line.

Using this code:

I think that this might be easier code to maintain because when I looked at your code, it seemed to me that you can probably get 25 obs on every page except for the last page because you've increased the font size for those last lines. So if you had a small number of rows on the last page, then the calculated pagex might be correct and there would be enough room on the page for everything. But if the last page does have close to 25 rows, then I believe the pagex you calculate can be "off" from what PROC REPORT actually produces when it's putting report rows into the PDF file.

Hope this helps,

Cynthia