topic underline after last row of each page in proc report in ODS and Base Reporting

underline after last row of each page in proc report

Peter_Y — Wed, 07 Jun 2023 22:30:35 GMT

Hi:

I wonder if there is an easy way to underline last row of each page in proc report? The code below print horizontal lines for the whole table

ods rtf file='test.rtf';
title 'Air travel';
footnote 'my footnote';
proc report data=test nowd style(report)=[rules=none frame=hsides] 
style(header)=[background=white borderbottomcolor=black borderbottomwidth=2];
column date air;
define date/order;
run;
ods rtf close;

How can I (automatically) underline last row of each page as below?

Thanks,

Re: underline after last row of each page in proc report

Cynthia_sas — Thu, 08 Jun 2023 00:26:13 GMT

Hi: If you want a line that goes from margin to margin just above the footnote, then you need to do that in the FOOTNOTE statement. Style overrides in PROC REPORT on the style(report) location only impact the TABLE, so the line will be from one side of the table to the other -- not from margin to margin.

Here's how I put a line above the footnote:

Original ODS ESCAPECHAR method with RTF control strings:

New ODS ESCAPECHAR method with style attribute overrides:

I prefer to test with STYLE=JOURNAL if I want the interior tables lines to be suppressed and to have a white background to the headers. Maybe one of these methods will work for you.

Cynthia

Re: underline after last row of each page in proc report

Ksharp — Thu, 08 Jun 2023 11:42:53 GMT

/*You want this?*/
data have;
 set sashelp.shoes ;
 if mod(_n_,30)=1 then page+1;  /*each page have 20 rows*/
run;

ods rtf file='c:\temp\test.rtf' style=journal;
title 'Air travel';
footnote 'my footnote';
proc report data=have nowd ;
define page/group noprint;
break after page/page;
run;
ods rtf close;