Thank you so much everyone for input, I can get more details. However, query is same as I mentioned earlier from variable perspective, i put bit info at-least for var_4 value. If something wrong from logic perspective, definitely needs to be fixed to fixed from our end. To me, it seems user creating temp table reading temp table. proc SQL;
create table test as
select var_1,
count (distinct var_2) as var_3,
sum(case when var_4 in ('ABCD','DEFG','HIJK','LMNO','PQRS','TUVW','XYZA','BCDE','FGHI','JKLM')
then var_5=1
else 0 end) as var_6
from xyz
group by var_1;
quit;
... View more