BookmarkSubscribeRSS Feed
Miron
Calcite | Level 5

Hello,

I am wondering, if there is a way to highlight WR values in a crosstable for every column separately, like the way it is done in Excel with Conditional Formatting option?

Thanks for any ideas!

Miron

2 REPLIES 2
JohnT
Quartz | Level 8

Hi Miron,

I'm probably misunderstanding the question, but couldn't you just right click on the data, select conditional highlighting, select the column variable and then apply formatting based on the condition?

That's what I do for one of the KPIs I have.  There's nothing stopping me from applying this to ther KPIs.

Miron
Calcite | Level 5

Hi John,

yes, but in this case, I will have conditional formatting for the data in the whole table, and it is not really what I want.

Let's say, we have a crosstable, that shows us the number of sold items over the time in different stores. In this way, we will have the table with months in rows and stores in columns. For conditional formatting, some certain conditions should be defined (from 0 to 100 bad, from 500 - good, etc). But in real life, it is often not like this, so far the stores are different. And for a one particular store 10 sold items/month could be a significant result, as well as for another one it will be very bad.

So, I thought that there was a nice function, that could allow me to differentiate my categories, and to apply conditional formatting for every category separately, like Excel does (in my case for each store separately). But I did not find the solution so far.

Regards,

Miron

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1026 views
  • 0 likes
  • 2 in conversation