Hi, I have no issue exporting to an Excel file with colored cells via proc report with compute block. However, I remember there was a time that the actual SAS table also had the colored cells. The proc report with out= option does not result in colored cells in the output table, only in the exported Excel file. Any insight on this?
However, I remember there was a time that the actual SAS table also had the colored cells.
I have never seen this. I doubt that it is possible.
This KB article describes colouring specific cells in output from a few different approaches (incl. proc report, proc tabulate, data step, etc). I'm a little unsure if that's what you mean, or whether you think there's a way to have the cells in the source dataset coloured.
@marked wrote:
This KB article describes colouring specific cells in output from a few different approaches (incl. proc report, proc tabulate, data step, etc). I'm a little unsure if that's what you mean, or whether you think there's a way to have the cells in the source dataset coloured.
The data step part shows how to create an html-file with coloured cells. Having colourful datasets is not possible.
Yes, I agree. That's why I made the comment that I was unsure of OP's intent.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.