I tried your code proc report data=class nowd;   ** Use Format for FAKENUM column;   column ('1) Use SAS format for color, Excel TAGATTR for negative' age name sex fakenum);   define age / order;   define name / order;   define sex / display;   define fakenum / display          style(column)={tagattr='format:#,##0.000;-#,##0.000;#,##0.0;' foreground=colormis.}; run;    proc report data=class nowd;   ** Use Excel coding for FAKENUM column;   column ('2) Use Excel format for color and decimals -- 0 is blue' age name sex fakenum);   define age / order;   define name / order;   define sex / display;   define fakenum / display     style(column)={tagattr='format:[Red]#,##0.000;[Black]-#,##0.000;[Blue]#,##0.000;'}; and it returned WARNING: In Event: style_over_ride, Invalid Expression: ERROR: WHERE clause operator requires numeric variables. ... View more

thanks I thought of changing my proc print to a proc report on my way home.  This is another case of something that worked in 9.2 that does not in 9.3 I'll tackle it in the morning with a fresh brain ... View more

with of the column has not been the big problem it is the width of the rows I've been trying ROW_HEIGHTS='30,30,30,20,20,20' but it does not seem to have an effect ... View more

ah but your using proc report I'm using proc print.  I don't see any examples using proc print. I'm trying not to change the report too much from what users are used to seeing.  The proc print works fine the old server which is failing so I have to port everything to a new server ... View more

for some stupid reason I was not able to paste in my first window. am I leaving something out? ods tagsets.ExcelXP path="c:\temp\" file='Technician_Quality_Report.xml' style=sasweb;    ods tagsets.excelxp options(embedded_footnotes='yes' embedded_titles='yes'                               sheet_label='Country Summary               ' ROW_HEIGHTS='10,10,10,20,10'                              orientation='landscape'                               absolute_column_width='25,15'                               ); title1 'quality report'; proc print data=test; var a b c d; label      a='var a'      b='var b'; run; quit; ... View more

the date (birthdate) is a text field in SAS.  I think it is that way because that is in the requirements when I try using proc print.... var birth /style={htmlstyle="mso-number-format:\@"}; I get Warning: Yes/No options only take, yes, no, on, or off as valid values WARNING: In Event: style_over_ride, Invalid Expression: ERROR: WHERE clause operator requires numeric variables. WARNING: In Event: style_over_ride, Invalid Expression: ERROR: WHERE clause operator requires numeric variables. when I stick ods path work.templat(update) sashelp.tmplmst(read); it works but then the ods output options are ignored such as column width these are   ods tagsets.ExcelXP options(embedded_footnotes='yes'  embedded_titles='yes'                             suppress_bylines='yes' orientation='landscape'                             sheet_interval='bygroup'  sheet_label=' '                             width_fudge='.7' width_points='1'                            absolute_column_width='125,68.5,68.5,68.5,68.5,68.5,68.5,68.5'                             center_horizontal ='yes '); ... View more

calling SAS is part of my plan. today I went through as much of the code as I could to see what worked and try to make adjustments.  I think many of the custom stuff is now doable in SAS....some of this stuff was written years ago. ... View more

yep...someone wrote a custom template and some other code long ago I think the where was in there maybe because when I took it out the problem went away ... View more

nope none of the solutions seem to work when run in batck.  The code runs several times a day to update reports any other ideas? ... View more