BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Sarah-R
Obsidian | Level 7

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Norman21
Lapis Lazuli | Level 10

I use the following as final lines of code:

 


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

run;
Norman.
SAS 9.4 (TS1M6) X64_10PRO WIN 10.0.17763 Workstation

View solution in original post

6 REPLIES 6
Norman21
Lapis Lazuli | Level 10

I use the following as final lines of code:

 


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

run;
Norman.
SAS 9.4 (TS1M6) X64_10PRO WIN 10.0.17763 Workstation

Sarah-R
Obsidian | Level 7

Excellent!

Thank you @Norman21!

I highly appreciate your solution!

 

ed_sas_member
Meteorite | Level 14

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,

Sarah-R
Obsidian | Level 7

The latter worked stellar!

Thank you so, so much @ed_sas_member!

Sarah-R
Obsidian | Level 7

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

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 5913 views
  • 2 likes
  • 3 in conversation