Hi: You may want to work with Tech Support on this one. If you look at the code below, you will see that I have an "overall" bordercolor used in the TABLE statement for TABULATE or in the STYLE(REPORT) override in PROC REPORT. Then, I have bordercolors set on on individual columns in either the DEFINE statement (REPORT) or the TABLE statement (TABULATE). However, if you look at the screen shot of the output, you will see that only HTML really does what I instructed it to do, where the CYAN border for the FRAME is different from the colors used for the individual columns. RTF and PDF treat those overrides a different way and the ExcelXP output is still different from any of the others. So, while bordercolor and borderwidth do work, they work differently in each destination. Tech Support can tell you whether there is some possible combination of RULES/FRAMES/CELLSPACING/BORDERWIDTH that would work for you, specifically in the EXCELXP destination. cynthia ** Example 5: various border styles; ods html file='c:\temp\ex05c.html' style=sasweb; ods pdf file='c:\temp\ex05c.pdf'; ods rtf file='c:\temp\ex05c.rtf'; ods tagsets.excelxp file='c:\temp\ex05c.xml' style=sasweb; proc report data=sashelp.class nowd style(report)={bordercolor=cyan borderwidth=5}; title "5c) REPORT: bordercolor and borderwidth"; column name age height; define name / style(column)={bordercolor=red borderwidth=5}; define height/ style(column)={borderrightcolor=yellow borderrightwidth=4}; run; proc tabulate data=sashelp.class; title "5c) TAB: bordercolor and borderwidth etc"; var age; class sex; classlev sex / style={bordercolor=red borderwidth=5} ; table sex, age*(n min mean max*{s={borderrightcolor=yellow borderrightwidth=4}})/ style={bordercolor=cyan borderwidth=5}; run; ods _all_ close;
... View more