Hi: The challenge with your CALL DEFINE is that it does not touch the header cells which is what you say you want to touch. I question whether you want brown as a color, since the black font on a brown background will be nearly illegible. Are the colors in the XLSX what you want or what you show in your code. It looks like the fonts are a different color in the XLSX example. What is your desired destination for the PROC REPORT output? The challenge with your ACROSS items is that there are a couple of different ways you might proceed. I've got one example here: http://support.sas.com/resources/papers/proceedings14/SAS388-2014.pdf on pages 12/13. I know that some folks have used a format example for the ACROSS, but that won't impact the CASE and RATE under each unique ACROSS value, which is what you indicate that you want. BTW, headline and headskip are ignored by ODS destinations because they are LISTING-only options and irrelevant for ODS destinations like ODS RTF, ODS PDF, ODS HTML, or ODS EXCEL. To make it easy, I might switch to TABULATE, because a header cell can inherit attributes from the parent cell above or else if you want to stick with REPORT, make 2 passes thru the data. Cynthia
... View more