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.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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