use a function like INDEX to populate six new binary variables that check for each value 1 - 6. then do some IF statements based on that. For ex. flag1-flag6=0; if index(variable-name,'1') > 0 then flag1=1; if index(variable-name,'1') > 0 then flag2=1; etc... then if flag1 + flag2 + flag3 > 0 then do; if flag4 + flag5 + flag6 = 0 then group = 'A'; else if... else...
... View more