topic Re: Counts gt 10 in SAS Programming

Counts gt 10

kpdoe — Thu, 15 Aug 2019 18:02:48 GMT

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

Re: Counts gt 10

novinosrin — Thu, 15 Aug 2019 18:10:51 GMT

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;