Hello @ed_sas_member can I just ask one more thing about the solution you have proposed. If I need to fill the background of a different cell rather than the last one in the group i.e. IF C1 <> (C2+C3) I need to colour C2 it does not work, as it fills the cell regardless Below is an example data TEST;
input YEAR COL1 COL2 COL3;
datalines;
2016 30 0 30
2017 20 10 9
2018 5 2 3
2019 10 4 4
2020 15 7 8
2021 5 0 5
;
run;
title "colour COL2 red if COL1 <> COL2+COL3";
proc report data=WORK.TEST nowd;
column (YEAR, (COL1 COL2 COL3));
define YEAR / across 'YEAR';
define COL1 / analysis SUM 'COL1' missing;
define COL2 / analysis SUM 'COL2' missing;
define COL3 / analysis SUM 'COL3' missing;
compute YEAR;
if _C1_ ne (_C2_ + _C3_) then call define('_c2_','style','style={background=red}');
if _C4_ ne (_C5_ + _C6_) then call define('_c5_','style','style={background=red}');
if _C7_ ne (_C8_ + _C9_) then call define('_c8_','style','style={background=red}');
if _C10_ ne (_C11_ + _C12_) then call define('_c11_','style','style={background=red}');
if _C13_ ne (_C14_ + _C15_) then call define('_c14_','style','style={background=red}');
if _C16_ ne (_C17_ + _C18_) then call define('_c17_','style','style={background=red}');
endcomp;
run; Is there any rule / and a wokaround for this? (it seems that only the "define" can only be applied to the last cell in the group?) Many thanks
... View more