Hi:
I don't have a definitive answer about why using TAGATTR didn't work in a style template. I suspect that it's because TAGATTR is generally used with numeric variables only (you are sending a Microsoft number format using TAGATTR) -- and the TAGATTR value you specified might not have been appropriate for ALL the variables in your report. (TAGATTR would have been wrong for the NAME variable, for example.)
Everytime I use TAGATTR, I use it in a DEFINE statement (REPORT) or a VAR statement (PRINT) or, with TABULATE, in a TABLE statement using STYLE= overrides. That way, I have the most control over which format is explicitly used for which variable.
If you want to pursue why your style template did not work, you'll have to open a track with Tech Support. When I use the style template below, I do get TAGATTR used, even with character variables in the report.
cynthia
[pre]
data class;
set sashelp.class;
idvar = _n_ * 10000;
age = age * 10000;
run;
ods path work.tmp(update) sasuser.templat(update)
sashelp.tmplmst(read);
proc template;
define style styles.ta;
parent = styles.sasweb;
class data from data/
background=yellow
tagattr="##,###,###";
end;
run;
ods tagsets.excelxp file='c:\temp\sum_temp.xls' style=styles.ta;
proc report data=class(obs=5) nowd;
column idvar age height weight;
define idvar / order;
define age / sum;
define height / sum;
define weight / sum;
rbreak after / summarize style=Header;
run;
ods _all_ close;
ods tagsets.excelxp file='c:\temp\sum_temp_withchar.xls' style=styles.ta;
proc report data=class(obs=5) nowd;
column idvar name sex age height weight;
define idvar / order;
define name / display;
define sex / display;
define age / sum;
define height / sum;
define weight / sum;
rbreak after / summarize style=Header;
run;
ods _all_ close;
[/pre]