data 3 1,2 2,3,4 3,5,6 1,3,7 8 Can anyone help with a solution for this problem? I have been trying to find a solution for the problem of categorizing multiple entries combinations in to groups. Problem: If entry is any number or combination with numbers 1,2,3 then group as A ; If entry is any number or combination with numbers 4,5,6 then group as B ; If entry is any combination with numbers containing A and B then group as Both; If entry is any combination with numbers not containing A and B then group as other or unknown; My approach is as follows but wish to include combinations of entries. Data ; if entry = '1,2,3' then group = "A" ; if entry = '4,5,6' then group = "B" ; if entry = '1,2,3' AND entry = '4,5,6' then group = "Both" ; else if entry not in ('1,2,3','4,5,6') then group = "other or unknown" ; run;
... View more