Hi,
If you are using a custom style template (which it seems that you are), then either changing the NoteContent style element (controls the LINE statement)
or the SystemFooter (controls the FOOTNOTE statement) would be style elements to add to your style template.
If you decide to use the LINE statement in a COMPUTE AFTER block and you did not have any other LINE statements, then you would be OK
setting a background of yellow. But, if you DO have other LINE statements (as in the code below), then you can use the changed NoteContent for the
LINE style and just set the style of your other LINE (such as between AGE) to a different style element (such as SystemTitle (which is
white background and no border lines.
The FOOTNOTE method may be more to your liking -- of course the difference between the LINE statement and COMPUTE AFTER is that a
LINE statement output will always be inside the boundaries of the table, while the FOOTNOTE statement could either be inside the worksheet
or in the footer area (depending on the value of the EMBEDDED_FOOTERS suboption.
cynthia
[pre]
ods path work.tmp(update) sashelp.tmplmst(read);
proc template;
define style styles.line;
parent=styles.journal;
class SystemFooter /
background=yellow;
class NoteContent /
foreground=red
background=yellow
font_weight=bold
font_size=8pt;
end;
run;
ods tagsets.excelxp file="C:\temp\blahyellow.xls" style=styles.line
options(doc='Help' embedded_footnotes='Yes' embedded_titles='Yes');
ods escapechar='^';
proc report data=sashelp.class nowd
style(column)={cellwidth=1.10in};
title 'TITLE: Proc Report to XML and HTML';
footnote bold c=purple h=8pt
'FOOTNOTE: The yellow highlight is because of blah blah blah blah and yada yada yada yada.';
where age in (12,14);
column age sex name weight height;
define age / order 'ID' style(column)={just=l};
define sex / display 'Job' style(column)={just=l};
define name / display 'Date';
define weight / display 'Class/Injury';
define height /sum;
break after age / summarize ;
compute sex;
if sex eq 'F' then call define(_row_,"style","style=[background=yellow]");
endcomp;
compute after age / style=SystemTitle{foreground=black background=white};
line ' ';
endcomp;
compute after;
line 'LINE: The yellow highlight is because of blah blah blah blah and yada yada yada yada.';
endcomp;
run;
ods _all_ close;
[/pre]