I have an Excel spreadsheet being generated through ExcelXP and I am using a tagattr option within the body of the table (percent formatting). Additionally, I would like to add a background color for one particular variable but not for the other (I'm using a custom format, as can be seen in the classlev statements). Can I use both style options together, or will the tagattr not allow me to add anything else? The tabulate code:
Wow, I can't believe I asked that...I think that's what happens after a morning of figuring out how to override the alignment options in ExcelXP until you realize there is no alignment option and you have to go through the Proc Template route. The glaringly obvious solutions have eluded me, apparently!
Actually, that brings another question: my titles are centered ('Ethnicity' and the corresponding values) and my data are centered, both through template options. The '#' and '%' signs are not, however. I'm mostly concerned about the '%' sign, though, since that tagattr option is already in there. What kind of style element could I put in my template to enable me to center the # and % column headers?