Don't worry about all that provided the correct answer I just provided example.  I may want to do this myself someday and I'm glad to know how. ... View more

Any comments on how it works in 9.4M1 (or M2)? Is it worth upgrading from 9.4M0? ... View more

any options regarding creating pivots will be available on UNIX...? I submitted my SAS program on remote UNIX server.....>< i also updated on technical support tracking entry....appreciate you guys' suggestion. ... View more

Yes, you can use the htmlstyle= as well as you mentioned and can handle various other style issues that arise, however, the optionss was added just for convenience. ... View more

Hi:   You can use ODS ESCAPECHAR functions with STYLE overrides to alter the text. You could look at changing the style template. I don't remember off the top of my head which style element you would change. The Data element, I think. Or you could use a PROC REPORT approach. See the code below.        Cynthia ods tagsets.excelxp file='c:\temp\data_null_xp1.xml'     style=htmlblue options(ascii_dots='no'); ods escapechar='^'; **Method 1; data _null_; file print; put '^{style[font_weight=bold font_size=12pt color=purple]Hello World}'; put 'Twas Brillig and the slithy toves'; run;    ods tagsets.excelxp close;    data world;   length text $50;   text = 'Hello World';   output;   text='Twas Brillig and the slithy toves';   output; run;      ods tagsets.excelxp file='c:\temp\proc_report2.xml'     style=htmlblue ;     **Method 2; proc report data=world nowd noheader   style(column)={font_weight=bold font_size=12pt color=purple};   column text; run; ods tagsets.excelxp close; ... View more

Thanks.  Works perfectly.  Might you also now how to control line breaks in ods MSOffice2K?  When I use the HTML breaks I would use for ODS HTML, it does not apply them.  Or how to control the font?  Style(fontweight=BOLD) does not seem to work. ... View more

Thank you. ... View more

I take it EMLOUT3 is a filename using the email access method?  You may need to add lrecl= there. Sometimes when debugging email problems, I find it easier to write the results to a file, so that I can review the .html in a text editor.  And try opening it in a browser.  That helps determine whether PROC REPORT is generating bad html, or if good html genereated by PROC REPORT is being truncated by outlook or elsewhere in the emailing process. I've been saved by rs=none, as Chevell suggests. ... View more

You are correct, as this will not be applied when added via inline formatting. ... View more

You might want to open a tracking entry with technical support and send the supporting files regarding the errors received when the columns has embedded spaces. ... View more