data have; input id test $ pass $ level $ ; datalines; 1 a 'Yes' 'hard' 1 b 'Yes' 'hard' 2 a 'Yes' 'hard' 2 b 'Yes' 'medium' 3 a 'Yes' 'medium' 3 b 'No' 'medium' 4 a 'Yes' 'hard' 4 b 'Yes' 'hard' 5 a 'No' 'medium' 5 b 'Yes' 'medium' ; run; proc sql; create table want as select id,case when count(distinct catx(' ',pass,level))=1 then 'Yes' else 'No ' end as flag from have group by id; quit;
... View more