Hi:
It is much easier to change the title in one of these ways (listed in order by easiest to hardest method):
1) change the style you use style=printer, style=minimal, style=sasweb to name just a few all have white backgrounds to the titles.
2) Use SAS/GRAPH options in the TITLE statement to alter title attributes (but the attribute change must be specified BEFORE the text string you are changing -- if you specify the changes AFTER the text string, they will have no impact.) Some attribute options you can change are:
-- foreground color -- COLOR= or C=
-- font value -- FONT= or F=
-- font size -- HEIGHT= or H=
-- font weight -- BOLD (single word attribute)
3) Use ODS ESCAPECHAR to specify TITLE string changes. I show the 9.1.3 syntax in TITLE1 and 9.2 syntax in TITLE2 in the #3 example below.
4) Change the Style template that you use
The first 3 methods are illustrated in the code posted at the end of this response. I do not generally recommend changing the style template just for the titles, since there are other, simpler, ways to accomplish that task.
cynthia
[pre]
ods listing close;
** Method 1: just use a different style;
ods tagsets.excelxp file='c:\temp\testtitle1.xls'
style=printer options(embedded_titles='yes');
title1 "1) Number and Results of Tests";
title2 "Change the style you use so titles are black and white";
proc tabulate data=sashelp.class;
class age;
var height;
table age,
height*(min mean median max);
run;
ods tagsets.excelxp close;
** Method 2: use title attribute options;
ods tagsets.excelxp file='c:\temp\testtitle2.xls'
style=sasweb options(embedded_titles='yes');
title1 color=black font='Courier New' bold h=12pt "2) Number and Results of Tests";
title2 "Title is normally Blue";
proc tabulate data=sashelp.class;
class age;
var height;
table age,
height*(min mean median max);
run;
ods tagsets.excelxp close;
** Method 3: Use ODS ESCAPECHAR;
ods tagsets.excelxp file='c:\temp\testtitle3.xls'
style=sasweb options(embedded_titles='yes');
ods escapechar='^';
title1 "^S={color=black font_size=12pt font_face='Courier New' font_weight=bold}3) Number and Results of Tests";
title2 "^{style[color=red font_weight=bold]Title is normally Blue but this title is red}";
proc tabulate data=sashelp.class;
class age;
var height;
table age,
height*(min mean median max);
run;
ods tagsets.excelxp close;
title;
[/pre]