BookmarkSubscribeRSS Feed
vegan_renegade
Obsidian | Level 7

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?

4 REPLIES 4
PaigeMiller
Diamond | Level 26

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
marked
Fluorite | Level 6

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.

andreas_lds
Jade | Level 19

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

marked
Fluorite | Level 6

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

sas-innovate-white.png

Register Today!

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.

Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1369 views
  • 4 likes
  • 4 in conversation