BookmarkSubscribeRSS Feed
MadCowKilla
Calcite | Level 5
Hello,
I have a summary table with student's name in the row and the Exam # in the columns. I would like to highlight scores that has lower score than the Column Average. For example,

Name Exam1 Exam2 Exam3 Average
x 70 80 100 83
y 80 50 80 70
Average 75 65 90 77

I want to highlight 70 on exam1, 50 on exam2 and 80 on exam3. Can this be done using the SAS built in function rather than coding? If not, how do I code this?

thanks!
1 REPLY 1
RMP
SAS Employee RMP
SAS Employee
Sample 41942: Conditional highlighting using a custom add-in task in SAS® Enterprise Guide® 4.2

http://support.sas.com/kb/41/942.html

I am not sure if this will work with version 4.1. Otherwise click on the "Full Code" link to see an example of how to achieve this with SAS base code.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 1 reply
  • 929 views
  • 0 likes
  • 2 in conversation