Hi, What do I have to change in the following SAS program in order to add the lower border to the heading cell ("Powers") that spans two columns: %macro fontSpecs();
FONT_FACE = "SAS Monospace"
FONT_SIZE = 7pt
FONT_WEIGHT = medium
FONT_STYLE = roman
FOREGROUND = black
BACKGROUND = white
%mend;
proc template;
define style mystyle;
parent = Styles.rtf;
STYLE Continued from Continued/ pretext="" font=("SAS Monospace", 0pt) width=0% FOREGROUND=white;
STYLE parskip from parskip / font =("Arial", 1pt);
STYLE SystemTitle / %fontSpecs();
STYLE Header / %fontSpecs() ;
STYLE Data / %fontSpecs() ;
STYLE SystemFooter / %fontSpecs();
STYLE Table / %fontSpecs()
BORDERWIDTH = 1
CELLSPACING = 0pt
CELLPADDING = 0pt
FRAME = ABOVE
RULES = GROUPS
;
STYLE SysTitleAndFooterContainer /
CELLSPACING=0;
end;
run; title "What I have now:"; title2; title3; title4; title5;
ods listing close;
ods escapechar="^";
ods tagsets.rtf file="C:\test.rtf" style=mystyle;
data one; do x = 1 to 10; y = x ** 2; z = x ** 3; output; end; run;
proc report data=one
nowindows missing
split='|' contents=''
style(column)={foreground=black cellspacing=1 just=C VJUST=M }
style(report)=[font_face='SAS Monospace']
;
columns x ("Powers" y z) ;
%macro heaColStyle(hjust, cjust, width);
DISPLAY
style(header)=[font_face='SAS Monospace' just=&hjust.]
style(column)=[font_face='SAS Monospace' cellwidth=&width.cm just=&cjust.]
%mend;
define x / %heaColStyle(c, c, 2.0 ) "X" id;
define y / %heaColStyle(c, c, 2.0 ) "Y" ;
define z / %heaColStyle(c, c, 2.0 ) "Z" ;
run;
ods tagsets.rtf close;
ods listing ;
footnote; footnote2; footnote3; footnote4; footnote5; footnote6; Thanks in advance I use SAS 9.2. Thanks in advance ! -- rkk33
... View more
