Hi, this should be easy - or so I thought. I want to compare 2 cells, and highlight one of them if it is larger then the second. For example, I want to highlight the weight if it is higher then the max weight. Product Weight MaxWeight A 4 5 A 6 5 B 3 4 3 4 3 C 7 3 Here is what I have as code, that does not work -  I'm not sure how to use the compute block to create a different style: proc report data=work.data nowd; column product weight maxweight; define weight / computed ;     compute weight;     if weight < maxweight then do;         call define('Weight','style','style={background=White}');      end;      else if weight> maxweight then do;         call define('Weight','style','style={background=yellow}');      end;      endcomp; run; I think I need to take a class on Proc Report. Thanks for your help! ... View more

Hi, Once again I am pulling out my hair, trying to figure out how to do Traffic Lighting on a report I created with Proc Tabulate. Here is what I have: Proc Tabulate data=work.report; Var  Result ResultAverage; Class Product Machine; Table Product*Machine,(Result ResultAverage)*''Mean'=Mean')/; run; What I would like to do is highlight is Highlight the Result for a machine in yellow and red based on a calculation of the ratio between the 2.  If the ratio is greater then 1.5, then the cell would be red, if the ratio is above 1.25 the cell would be yellow. The sesulting table would look something like this: Product Machine Result ResultAverage A M1 4 (highlight yellow) 3 M2 6 (highlight red) 3 B M1 3 (no highlight) 3 M2 6 (No highlight) 5 Can anybody help? I have been looking at proc format to do this, but haven't been successful. Thank you! ... View more

Good Morning,  I am willing to bet this isn't that hard, but with my little experience with SAS, I haven't figured this one out. I have a data set with 2 variables being used as classification variables, Product and Machine. For each observation, I have a numeric value for TEST I want to create for each observation a new variable DIF which is the result of this calculation: DIF= TEST - (Average TEST for all observations for each combination of product and machine) Basically I want to calculate the difference between the observation versus the average result for each Class (Product*Machine*) and put that in the DIF variable for each observation. Thanks! Kim ... View more

Hi, I am creating control charts using Proc Shewart. I created a data set containing limits. When these limits are being applied to my data, they vary because the sample size varies.  I would like my limits to not vary according to sample size, just to take the Process mean and the standard deviation specified in the limits table to create the limits. Stability in the limits will make it easier for our operators to interpret. I think there should be an easy way to do this, but I don't know what it is! Thank you! Kim ... View more

I am struggling at finding a way to group observations by date and hour from a variable that is in a datetime21.2 format. Any ideas? I am hoping this is a very easy question for someone, as I can't seem to find a way to do it (Using SAS 8.2) Thank you for your help! Kim ... View more