BookmarkSubscribeRSS Feed
Ronein
Meteorite | Level 14

Hello

I have summary data that I need to compare against control limits.

There are 2 type of control limits.

I want to color   X1909 X1908 X1907 X1906 by following rules:

 if value in cell  is greater than UCL1 and  greater than UCL2 then red color

 if value in cell  is greater than UCL1 and not greater than UCL2 then pink color

 if value in cell  is greater than UCL2 and not greater than UCL1 then purple color.

The colors should appear in proc print or proc report.

What is the way to do it please ?

 

 

data tbl;
input No $ X1909 X1908 X1907	X1906 UCL1 UCL2;
cards;
a 4 3 6 5.1 5 5.2
b 3 2 2 4.6 4.5 4.9
c 5 5 5 5 7 8
;
run;

 

 

1 REPLY 1
JosvanderVelden
SAS Super FREQ
Have a look at this sas note: http://support.sas.com/kb/23/353.html

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