ofH
I have two columns in the table, for example weight1 and weight2. I have to highlight weight2 in the summary table as: red if it is less then weight1, green if it is great then weight1 and blue if they are equal.
Is there any solution for this case?
Thank you in advance.
Are you doing it in proc report or something else
I do it in proc tabulate. I know how to do this in proc report, but I am more familiar to work with tabulate because SAS EG has this task in the menu
I am not sure that we can match two variables and do color coding over it in proc tabulate. I do use proc report.
Hi, in PROC TABULATE, you can't highlight one column based on the value of another column. But, as you know, this is easy to do with PROC REPORT using the CALL DEFINE statement and a COMPUTE block.
cynthia
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.