this one is good compare to my previous code data data1; set data; avg=mean(of RET VWRETD EWRETD); where (BMDECILE=1 and CFDECILE=1) or (BMDECILE=2 and CFDECILE=2) or (BMDECILE=3 and CFDECILE=3) or (BMDECILE=4 and CFDECILE=4) or (BMDECILE=5 and CFDECILE=5) or (BMDECILE=6 and CFDECILE=6) or (BMDECILE=7 and CFDECILE=7) or (BMDECILE=8 and CFDECILE=8) or (BMDECILE=9 and CFDECILE=9) or (BMDECILE=10 and CFDECILE=10); run;
... View more