I'm not convinced it's working, in any event; looking at the raw XML, it's still a string - excel's just being smart about it. I am probably not using the style properly, I am a PROC REPORT guy not a PROC TABULATE guy when it comes to these sorts of things.
Yeah, I'm a tabulate guy, but SAS doesn't seem to want to play nice here. Maybe I'll have to learn REPORT for this, unless SAS wants to fix this.
I believe that the problem is, at least for Tabulate, that the headers are technically always character - so in creating the resulting xml, they're sent as 'string'. You might be able to fix this by editing the tagset itself, though I'm not sure where I'd suggest beginning there. I don't think tagsets.excelxp will receive too much more development now that ODS EXCEL is largely out, so I wouldn't expect it to change - but who knows.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.