The SAS Output Delivery System and reporting techniques

Proc Template - Header Lines

Reply
Contributor
Posts: 37

Proc Template - Header Lines

Capture.JPG

Please see above table columns with data.

 

Column names is almost overlapped with header lines. but when I zoom they actually not. I would like to get a space between header lines and columns and header and body data.

 

what should be changed proc template code.

 

I am using proc template.

 

proc template;
define style std/store=templates;
parent = Styles.rtf ;
class fonts /
'TitleFont' = ("Courier, Times Roman, Times", 8pt )
'TitleFont2' = ("Courier, Times Roman, Times", 8pt )
'footFont' = ("Courier, Times Roman, Times", 8pt )
'StrongFont' = ("Courier, Times Roman, Times", 8pt)
'EmphasisFont' = ("Courier, Times Roman, Times", 8pt)
'headingEmphasisFont' = ("Courier, Times Roman, Times", 8pt)
'headingFont' = ("Courier, Times Roman, Times", 8pt)
'docFont' = ("Courier, Times Roman, Times",8pt)
'FixedEmphasisFont' = ("Courier, Times Roman, Times", 8pt)
'FixedStrongFont' = ("Courier, Times Roman, Times", 8pt)
'FixedHeadingFont' = ("Courier, Times Roman, Times", 8pt)
'BatchFixedFont' = ("Courier, Times Roman, Times", 8pt)
'FixedFont' = ("Courier, Times Roman, Times", 8pt) ;

class color_list / 'link'= blue 'bgH' = white 'bgT' = white 'bgD' = white 'fg' = black 'bg' = white ;

style Table from Output / rules = groups frame= above cellpadding = 0 cellspacing = 0 ;

replace headersandFooters from cell/
font = fonts('HeadingFont') foreground = blank background = white;

class systemtitle / protectspecialchars=OFF asis=ON ;
class systemfooter / font=Fonts('footFont') protectspecialchars=OFF asis=ON ;
class text / 'continued' = " " ;
class continued / pretext=text('continued') width=_undef_ frame=void rules=none borderspacing = 0 padding = 0 ;
class header / protectspecialchars=off ;
class data / protectspecialchars=off ;
class rowheader / protectspecialchars=off ;
class usertext / protectspecialchars=off ;
class byline / protectspecialchars=off ;
end;
quit;

 

 

 

 

 

 

Super User
Super User
Posts: 8,349

Re: Proc Template - Header Lines

Change it in your proc report code:

proc report...;
...

  compute before;
    line ' ';
  endcomp;
  compute after;
    line ' ';
  endcomp;
run;
Ask a Question
Discussion stats
  • 1 reply
  • 70 views
  • 0 likes
  • 2 in conversation