Hi: I only have 9.4 to write code with. Unless you find someone who has 9.1.3 to work with your code, your best bet may be with Tech Support. I do not actually know whether the Underline option is supported in the TAGSETS.EXCELXP destination. For example, when I simplify your code, in SAS 9.4, the UNDERLINE option works for HTML but not for TAGSETS.EXCELXP destination. I suspect this is because the UNDERLINE option writes something not respected by Excel. On the other hand, the method 2 code does work in both Excel and HTML, using ODS ESCAPECHAR and a STYLE override using TEXTDECORATION attribute. See attached screenshots. Cynthia ods _all_ close; ** 1) use UNDERLINE; ods html file='c:\temp\testht_title1.html' style=sasweb; ods tagsets.ExcelXP file='c:\temp\testxp_title1.xml' options(EMBEDDED_TITLES = 'yes' ) style=sasweb; title1 underline=1 '1) First Title'; title2 ' '; title3 underline=1 'Title after Blank'; proc print data=sashelp.class; run; ods _all_ close; title; **2) use ODS ESCAPECHAR; ods html file='c:\temp\testht_title2.html' style=sasweb; ods tagsets.ExcelXP file='c:\temp\testxp_title2.xml' options(EMBEDDED_TITLES = 'yes' ) style=sasweb; ods escapechar='^'; title1 '^{style[textdecoration=underline]2) First Title}'; title2 ' '; title3 '^{style[textdecoration=underline]Title after Blank}'; proc print data=sashelp.class; run; ods _all_ close; title;
... View more