Hi:
SASHELP.CLASS did not have a variable called MAXWEIGHT, so Tim's code creates that variable as a "temp" variable. If you are going to do a comparison between WEIGHT and MAXWEIGHT, then you will need your COMPUTE block to be for MAXWEIGHT. PROC REPORT places variables on the report from LEFT to RIGHT. So, if this is your COLUMN statement:
column product weight maxweight;
then, at the point in time when WEIGHT is being placed on the report row, PROC REPORT has not yet placed MAXWEIGHT on the report row. So if you did your test in the COMPUTE block for WEIGHT, I suspect that every row would be yellow because MAXWEIGHT does not have a value yet. If MAXWEIGHT exists in the data, then the proper place for you to do your test is in a COMPUTE block for MAXWEIGHT.
The code below shows 3 different methods:
1) Method 1: has DISPLAY usage for WEIGHT and MAXWEIGHT
2) Method 2: has SUM usage for WEIGHT and MAXWEIGHT (notice how this changes the reference method in the COMPUTE block and CALL DEFINE statement
3) Method 3: has MEAN usage for WEIGHT and MAXWEIGHT (because I wanted to show how the summary line for Averages could be created with an RBREAK statement)
I changed the logical operators to be LE and GT (which I prefer over <, > or <= or >=), so that the equal situation (if WEIGHT=MAXWEIGHT) would be covered.
cynthia
data fakedata;
length product $10;
infile datalines;
input product $ weight maxweight;
return;
datalines;
A 4 5
A 6 5
B 3 4
3 4 3
C 7 3
;
run;
ods _all_ close;
title; footnote;
ods html file='c:\temp\hilight.html';
proc report data=work.fakedata nowd;
title 'Method 1: All items are DISPLAY usage';
column product weight maxweight;
define product / display;
define weight / display ;
define maxweight / display;
** use LE to take care of equal situation instead of just LT;
compute maxweight;
if weight le maxweight then do;
call define('Weight','style','style={background=White}');
end;
else if weight gt maxweight then do;
call define('Weight','style','style={background=yellow}');
end;
endcomp;
run;
proc report data=work.fakedata nowd;
title 'Method 2: All numeric items are SUM usage (default)';
column product weight maxweight;
define product / display;
define weight / sum ;
define maxweight / sum;
compute maxweight;
if weight.sum le maxweight.sum then do;
call define('Weight.sum','style','style={background=White}');
end;
else if weight.sum gt maxweight.sum then do;
call define('Weight.sum','style','style={background=yellow}');
end;
endcomp;
run;
proc report data=work.fakedata nowd;
title 'Method 3: Numeric items are MEAN usage with summary line at bottom';
column product weight maxweight;
define product / display;
define weight / mean ;
define maxweight / mean;
rbreak after / summarize;
compute after;
product='Averages';
endcomp;
compute maxweight;
if weight.mean le maxweight.mean then do;
call define('Weight.mean','style','style={background=White}');
end;
else if weight.mean gt maxweight.mean then do;
call define('Weight.mean','style','style={background=yellow}');
end;
endcomp;
run;
ods html close;
