Greetings- I'm trying to output tables to an RTF file.
My issue is that the RTF output doesn't include the conditional color coded background (see compute block, format= oe.), however it works in other tables...so I'm stumped. I've stared at it a 1000 times and can't figure out why. My code is attached. Any help is appreciated.
As long as I'm at it, what RTF file is most similar to HTML output?
/* PROC REPORT */
ods rtf file= "new.rtf" startpage= no startpage=no style= yourstyle_v2;
ods escapechar='^';
proc report data=new SPANROWS
style(header)=[borderrightwidth=0 borderbottomwidth=2 borderbottomcolor= black backgroundcolor=white/*cxe7eff6*/ color=black bordertopwidth=2 bordertopcolor=black]
style(report)={frame=void};
column Order_var Location Value ('FY 2014' FY14Q1 FY14Q2 FY14Q3 FY14Q4) ('FY 2015' FY15Q1 FY15Q2 FY15Q3 FY15Q4);
define Order_var/ order noprint;
define Location / " " group style=[fontweight=bold borderbottomwidth=2 borderbottomcolor=black borderrightwidth=0];
define value / display " " center style(column)=[borderrightwidth=0 cellwidth=0.75in];
define FY14Q1/ "Q1" center style(column)=[borderrightwidth=0 cellwidth=0.75in] format=noblanks.;
define FY14Q2/ "Q2" center style(column)=[borderrightwidth=0 cellwidth=0.75in];
define FY14Q3/ "Q3" center style(column)=[borderrightwidth=0 cellwidth=0.75in];
define FY14Q4/ "Q4" center style(column)=[borderrightwidth=1 cellwidth=0.75in];
define FY15Q1/ "Q1" center style(column)=[borderrightwidth=0 cellwidth=0.75in];
define FY15Q2/ "Q2" center style(column)=[borderrightwidth=0 cellwidth=0.75in];
define FY15Q3/ "Q3" center style(column)=[borderrightwidth=0 cellwidth=0.75in];
define FY15Q4/ "Q4" center style(column)=[borderrightwidth=0 cellwidth=0.75in];
compute value;
if value='O/E' then call define (_row_, "style", "Style=[background=oe. font_weight=bold borderbottomwidth=2 borderbottomcolor=black]");
endcomp;
run;
ods rtf close;
/* TEMPLATE */
proc template;
define style yourstyle_v2;
parent = Styles.rtf;
class fonts /
'TitleFont' = ("Times New Roman, Times Roman, Times" ,15pt,Bold )
'TitleFont2' = ("Times New Roman, Times Roman, Times" ,15pt,Bold )
'footFont' = ("Times New Roman, Times Roman, Times" ,9pt,Bold )
'StrongFont' = ("Times New Roman, Times Roman, Times" ,11pt,Bold)
'EmphasisFont' = ("Times New Roman, Times Roman, Times" ,11pt,Italic)
'headingEmphasisFont' = ("Times New Roman, Times Roman, Times" ,11pt,Bold)
'headingFont' = ("Times New Roman, Times Roman, Times" ,11pt,Bold)
'docFont' = ("Times New Roman, Times Roman, Times" ,11pt)
'FixedEmphasisFont' = ("Times New Roman, Times Roman, Times" ,15pt,italic)
'FixedStrongFont' = ("Times New Roman, Times Roman, Times" ,15pt,Bold)
'FixedHeadingFont' = ("Times New Roman, Times Roman, Times" ,15pt,Bold)
'BatchFixedFont' = ("Times New Roman, Times Roman, Times" ,15pt)
'FixedFont' = ("Times New Roman, Times Roman, Times" ,15pt)
;
class color_list /
'link'= blue
'bgH' = white
'bgT' = white
'bgD' = white
'fg' = black
'bg' = white
;
class systemtitle /
protectspecialchars=OFF
asis=ON
;
class systemfooter /
font=Fonts('footFont')
protectspecialchars=OFF
asis=ON
;
class header /
protectspecialchars=off
;
class data /
protectspecialchars=off
;
class rowheader /
protectspecialchars=off
;
class usertext /
protectspecialchars=off
;
class byline /
protectspecialchars=off
;
class header/
backgroundcolor=#f0f0f0
;
class parskip/
fontsize= 1pt;
end;
run;
... View more