When I try to run your example, it is changing the format of value from numeric to character and not retaining the numeric type. How can I get the _value to be of numeric type?     ... View more

Hi: This issue has come up before http://support.sas.com/forums/thread.jspa?messageID=50109쎽 And I modified your code sample below to illustrate the issue. Compare the HTML output (MSOFFICE2K) with the XML output (ExcelXP) -- you can see that the background change is honored by Excel when the HTML file is opened; and NOT honored by Excel when the XML file is opened. You can do some changes in a style template -- but basically, some overrides are just not honored by Excel when you use TAGSETS.EXCELXP -- I believe it is a limitation of how styles are defined/used in the XML. cynthia [pre] ods listing close; title; footnote; ods msoffice2k file='c:\temp\test1_mso.xls' style=sasweb; ods tagsets.excelXP file='c:\temp\test1_xp.xls' style=sasweb options(absolute_column_width="10"); ods escapechar='^'; proc report data=sashelp.class(obs=3) nowd style(lines)={background=cyan font_size=18pt}; title '1) background will work in HTML (MSOFFICE2K) but not ExcelXP)'; column name age height weight sex; compute before / style={just=l protectspecialchars=off background=yellow font_size=14pt}; text1 = "fontsize should be 14pt background color is yellow in HTML only"; line text1 $150.; endcomp; compute after; text2 = 'This is a line with a cyan (default) background in HTML only'; line text2 $150.; endcomp; run; ods _all_ close; title; footnote; ** 2) Change the template NoteContent style element; ods path work.tmp(update) sashelp.tmplmst(read); proc template; define style styles.linecolor; parent=styles.journal; class NoteContent / foreground=black background=pink font_weight=bold font_size=14pt; end; run; ods msoffice2k file='c:\temp\test2_mso.xls' style=styles.linecolor; ods tagsets.excelXP file='c:\temp\test2_xp.xls' style=styles.linecolor options(absolute_column_width="10"); ods escapechar='^'; proc report data=sashelp.class(obs=3) nowd; title '2) use a custom style template'; column name age height weight sex; compute before / style={just=l protectspecialchars=off background=yellow font_size=14pt}; text1 = "fontsize should be 14pt background color yellow overrides style in HTML"; line text1 $150.; endcomp; compute after; text2 = 'This is a line using the style template color'; line text2 $150.; endcomp; run; ods _all_ close; [/pre] ... View more

Oh, wait, I think I figured it out.... You do NOT need a BREAK statement to perform a COMPUTE BEFORE with a LINE statement. cynthia [pre] proc format; value $gender 'F' = 'Female' 'M' = 'Male'; run; ods html file='c:\temp\compute_before.html' style=sasweb; proc report data = sashelp.class nowd ; column sex name height weight; define sex/order noprint ; break after sex/summarize ; compute before sex /style={just=left font_weight=bold color=purple}; line sex $gender.; endcomp; run; ods html close; [/pre] ... View more

Hello, If you need to create the temporary data sets yo may find the next macro solution useful: [pre] %macro a; %do i=1 %to 3; data test&i; set sashelp.class; array f{3} $ 20 _temporary_ ('30 days','90 days','over all'); flag=f{"&i"}; run; %end; data all; set test:; run; %mend a; %a [/pre] Marius ... View more