- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Paige Miller
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Yes, I agree. That's why I made the comment that I was unsure of OP's intent.