Desktop productivity for business analysts and programmers

Conditional Highlighting in SAS EG 4.1

Reply
New Contributor
Posts: 4

Conditional Highlighting in SAS EG 4.1

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!
SAS Employee RMP
SAS Employee
Posts: 52

Re: Conditional Highlighting in SAS EG 4.1

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.
Ask a Question
Discussion stats
  • 1 reply
  • 121 views
  • 0 likes
  • 2 in conversation