How do I create a line at the bottom of the report using Proc Report that simply goes across the bottom border?
_______________________________
Header section
_______________________________
Column/Report section
_______________________________ <-- I want to produce this line.
How do I produce a line at the bottom of the report? There is a line already, but I would like it to be more visible.
I have tried borderbottomwidth=.2in and borderbottomcolor=black as in the following in the Proc Report statement but this does not work:
Proc Report data=sashelp.class split='/'
style(header)={...}
style(column)={...}
style(report)={borderbottomwidth=.2in borderbottomcolor=black just=center};
I am using SAS University Edition. There is a note that may hint at the source of the problem:
NOTE: ODS statements in the SAS Studio environment may disable some output features.
Any help would be greatly appreciated.
When I use the two border settings in style(column) it gives a bottom border at the end of every row:
Proc Report data=sashelp.class split='/'
style(header)={...}
style(column)={borderbottomwidth=.2in borderbottomcolor=black }
style(report)={ just=center};
I use the following as final lines of code:
compute after _PAGE_ /style=[background=lightgrey];
line ' ';
endcomp;
run;
I use the following as final lines of code:
compute after _PAGE_ /style=[background=lightgrey];
line ' ';
endcomp;
run;
Hi @Sarah-R
Would the option style=journal in your ODS statement be convenient?
e.g.
ods pdf file="xxx/xxx.pdf" style=journal;
proc report data=sashelp.class;
...;
run;
ods pdf close;
Otherwise, you can have more control by using a COMPUTE AFTER _PAGE_ statement:
compute after _page_ / style={bordertopcolor=black bordertopwidth=.2in};
line ' ';
endcomp;
Best,
The latter worked stellar!
Thank you so, so much @ed_sas_member!
My hardest effort is far below your easiest effort. I have a lot to go, @ed_sas_member.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.