topic Re: Create a line at the bottom of the report using Proc Report in SAS Programming

Create a line at the bottom of the report using Proc Report

Sarah-R — Sat, 27 Jun 2020 08:04:57 GMT

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};

Norman21 — Sat, 27 Jun 2020 08:42:43 GMT

I use the following as final lines of code:


compute after _PAGE_	/style=[background=lightgrey];
line ' ';
endcomp;

run;

ed_sas_member — Sat, 27 Jun 2020 09:31:51 GMT

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,

Sarah-R — Sat, 27 Jun 2020 09:50:47 GMT

The latter worked stellar!

Thank you so, so much @ed_sas_member!

ed_sas_member — Sat, 27 Jun 2020 09:57:22 GMT

Thank you so much @Sarah-R!

Sarah-R — Sat, 27 Jun 2020 10:01:03 GMT

Excellent!

Thank you @Norman21!

I highly appreciate your solution!

Sarah-R — Sat, 27 Jun 2020 10:07:28 GMT

My hardest effort is far below your easiest effort. I have a lot to go, @ed_sas_member.