SAS Programming

DATA Step, Macro, Functions and more
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

Join us for our biggest event of the year!

Four days of inspiring keynotes, product reveals, hands-on learning opportunities, deep-dive demos, and peer-led breakouts. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

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
  • 1462 views
  • 4 likes
  • 4 in conversation