I have found certain examples for more complicated cases of color coding but could not reproduce the result for a simpler case. I have a NxN table and I want the cells to have different color depending if they are above, below or at the diagonal. I have been trying with solution of the type: proc report data=have;
column col1 col2;
COMPUTE before;
IF _row_ / _col_ = 1 THEN DO;
CALL DEFINE(_col_,'style','style={background=atDiag}');
END;
IF _row_ / _col_ > 1 THEN DO;
CALL DEFINE(_col_,'style','style={background=beDiag}');
END;
IF _row_ / _col_ < 1 THEN DO;
CALL DEFINE(_col_,'style','style={background=abDiag}');
END;
ENDCOMP;
run; However even a simpler cell coloring doesn't work: proc report data=sashelp.cars;
column model weight;
COMPUTE before;
IF _row_ = 2 and _col_ = 2 THEN DO;
CALL DEFINE(_col_,'style','style={background=yellow}');
END;
ENDCOMP;
run; Is there a simple way to achieve this without using additional numbers and just the row and col number?
... View more