topic How to add a bottom line to the header like the picture in ODS and Base Reporting

How to add a bottom line to the header like the picture

Jinlf — Tue, 23 Aug 2016 16:56:34 GMT

my procedures are as follows： proc template; define style styles.myrtf; style table / cellpadding = 0 pt cellspacing = 0.75 pt borderwidth = 1.5 pt bordercolor = black borderstyle = solid frame = hsides rules = groups; style systemtitle from titlesandfooters / font = ('Arial', 10.5pt, Bold ); style data / font = ('Arial', 10pt ); style header / font = ('Arial', 10pt ); end; run; options nodate nonumber; title; ods rtf file="D:\test.rtf" style=styles.myrtf; proc report data=sashelp.class nowd; column Name ("Important variables" Sex Age Height Weight); run; ods rtf close;

Re: How to add a bottom line to the header like the picture

Shmuel — Tue, 23 Aug 2016 19:46:05 GMT

ou may find some hints in next link:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000220968.htm

you can underline titles on HTML, PDF and probably some other ODS outputs.

otherwise you can add TITLE2 ' ____________ ';

Re: How to add a bottom line to the header like the picture

BrunoMueller — Wed, 24 Aug 2016 15:02:41 GMT

There is some definition involved, but it is possible to do, see this paper for more details.

https://support.sas.com/resources/papers/proceedings11/246-2011.pdf

Here is a sample program based on the paper mentioned.

ods escapechar="^";

proc report nowd data=sashelp.class 
  style(report)=[rules=none frame=void] 
  style(header)=[borderbottomcolor=black borderbottomwidth=2 background=_undef_]
;
  column
    ('^{style[borderbottomcolor=white borderbottomwidth=2
        bordertopcolor=black bordertopwidth=2]}' name) 
    ('^{style[borderbottomcolor=black borderbottomwidth=2
        bordertopcolor=black bordertopwidth=2]spanned header}' 
    age sex weight height)
  ;

  compute after _page_ / style={bordertopcolor=black bordertopwidth=2};
    line ' ';
  endcomp;
run;

There might be other ways as well

Bruno

Re: How to add a bottom line to the header like the picture

Cynthia_sas — Wed, 24 Aug 2016 16:53:10 GMT

Hi:

Here's a very simple way using STYLE=JOURNAL and TEXTDECORATION style attribute.

ods escapechar="^";

ods rtf file='c:\temp\underline.rtf' style=journal;
proc report nowd data=sashelp.class ;
  column name sex ('^{style[textdecoration=underline]Important Variables}' age height weight);
run;
ods rtf close;

which results in this (viewed in Word).

cynthia