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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.