topic Re: PROC REPORT Dynamic Footnotes in SAS Programming

PROC REPORT Dynamic Footnotes

davehalltwp — Mon, 02 May 2022 18:34:11 GMT

Anybody know an easy (quick) way to suppress footnotes in PROC REPORT after the first page? I guess I would still want the line at the bottom of the data on all pages, but footnotes only on page 1.

I am currently using a COMPUTE AFTER _PAGE_ block to display footnotes. Until now, I wanted all footnotes on every page.

Below is a simplification of my code. I know that PAGNUM is incrementing starting with 1, but I still get all footnotes on every page. Is there a trick to a conditional statement within one of these COMPUTE blocks?

Thank you

...dave

proc report data = prtdata;

compute after _PAGE_;

pagnum + 1;

line @1 "--------------------------";

if pagnum = 1 then line @1 "footnote 1 text";

if pagnum = 1 then line @1 "footnote 2 text";

if pagnum = 1 then line @1 "footnote 3 text";

endcomp;

run;

Re: PROC REPORT Dynamic Footnotes

Tom — Mon, 02 May 2022 18:46:59 GMT

I seem to remember that you need to make the text to be printed conditional instead of trying to make the LINE statement itself conditional.

Re: PROC REPORT Dynamic Footnotes

davehalltwp — Mon, 02 May 2022 19:08:17 GMT

Thank you, Tom SuperU. I think I know how to do that, but then the footnotes will still take up the same amount of space. The customer simply wants more data per page, so doesn't want any footnotes beyond page 1, blank or not.

Of course, I don't even know if that would be effective. REPORT might put the same number of rows on a page whether I am adding footnotes in a COMPUTE block or not.