Whilst you may be able to do this in compute blocks, I tend to find it easier to get a dataset looking right before reporting it out. Easier to QC, and work with. So two steps:
proc report data=... out=want;
...
run;
data want;
set want;
if name="Average" and total=0 then delete;
run;
/* Now we actually report it out */
proc report data=want;
...
run;
Of ourse you don't need to use proc report, you could use other procedures.
... View more
