data have;
infile cards truncover;
input id :$10. Newid $ Name :$10. Commonname DataSource;
cards;
2173787 42282 ANGELICA 0 0
914596 42282 ANGELICA 0 0
618775 42282 ANJELCA 0 0
1934321 42282 ANJELICA 0 0
2254092 42282 ANJELICA 0 0
1539485 42282 ANJELICA 0 0
1478028 42282 ANJELICA 0 0
1219086 42282 ANJELICA 0 0
730233 42282 ANJELICA 0 0
1275142 42282 ANJELICA 0 0
148759 42282 ANJELICA 0 0
1578160 42282 ANJELICA 0 0
674696 42282 ANJELIKA 0 0
194036 42282 ANJELIKA 0 0
378654 42282 ANJELIKA 0 0
;
proc sql;
create table want(drop=_c) as
select *
from (select *,count( name) as _c from have group by newid,name)
group by newid
having max(_c)=_c;
quit;
... View more