Counts gt 10

[kpdoe]

Hello I need help with the data which having count sID > 10

Data:

ID sID. Dt
1. 1234. 1/7/2019
1. 1234. 1/7/2017
2. 1233. 1/6/2017
3. 1233. 1/6/2017
4. 1233. 1/6/2017
5. 1233. 1/6/2017
6. 1233. 1/6/2017
7. 1233. 1/6/2017
8. 1233 1/6/2017
9. 1233. 1/6/2017
11. 1233. 1/6/2017
10. 1233. 1/6/2017
11. 1233. 1/6/2017
I need to get

ID. sID. No_acc
2. 1233. 11
.
.
11. 1233. 11

[novinosrin]

1233 has only count of 10 occurrences in your sample

Will this help

proc sql;
create table want as
select *,count(sid) as count
from have
group by sid
having count>10;
quit;