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 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 5270 views
  • 2 likes
  • 3 in conversation