Count the number of times a key appeared per row

iSAS — Tue, 28 Jan 2020 11:57:39 GMT

Let's say I have a data below:

data have;
infile cards truncover;
input ID :$4.;
cards;
0196
0196
0196
0395
0752
1277
1277
;
run;

What I want is to have a new table with a new column wherein it will count the number of times the ID appeared but not group it. To explain it clearer, I want to have an output like this:

ID        Count_ID
0196          1
0196          2
0196          3
0395          1
0752          1
1277          1
1277          2

Could someone help me on this? A program that will work even if ID is not sort by order

Re: Count the number of times a key appeared per row

PeterClemmensen — Tue, 28 Jan 2020 12:05:29 GMT

@iSAS Please do not double post 🙂

See the answers in your original thread

https://communities.sas.com/t5/SAS-Programming/Count-the-number-of-times-a-ky-appeared-individually/m-p/620466

topic Re: Count the number of times a key appeared per row in SAS Programming

Count the number of times a key appeared per row

Re: Count the number of times a key appeared per row