topic Re: How to color cells in SAS data table in SAS Programming

How to color cells in SAS data table

vegan_renegade — Thu, 28 Apr 2022 16:40:16 GMT

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?

Re: How to color cells in SAS data table

PaigeMiller — Thu, 28 Apr 2022 16:41:31 GMT

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.

Re: How to color cells in SAS data table

marked — Thu, 28 Apr 2022 23:57:16 GMT

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.

Re: How to color cells in SAS data table

andreas_lds — Fri, 29 Apr 2022 05:23:21 GMT

@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.

Re: How to color cells in SAS data table

marked — Fri, 29 Apr 2022 05:26:03 GMT

Yes, I agree. That's why I made the comment that I was unsure of OP's intent.