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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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
  • 847 views
  • 0 likes
  • 2 in conversation