Here is PROC SQL solution if you want it and your dataset is not big.
data have;
input ID $ Count ;
cards;
A 80
A 25
A 25
A 25
A 20
B 70
B 30
B 10
B 9
B 7
;
proc sql;
create table want as
select * from have as c where exists(select * from
(
select a.id,a.count
from have as a,have as b
where a.id=b.id and a.count<=b.count
group by a.id,a.count
having count(distinct b.count)<3
) as d
where c.id=d.id and c.count=d.count
)
order by 1,2 desc;
quit;
... View more
