Counting observations by ID

[John4]

I have a data like this :

ID             NAME      SURNAME           

191080    John           WAYNE          
191080    John           WAYNE         
191080    John            WAYNE         
191141    Alex            CLARK         

191141    Alex            CLARK      

I used PROC FREQ to count ID but I only get this :

ID              COUNT

191080           3

191141           2

But I want to count ID then add to my data, I mean how to get this :

ID             NAME      SURNAME      NUMBER         

191080    John           WAYNE            3
191080    John           WAYNE            .
191080    John            WAYNE            .
191141    Alex            CLARK            2

191141    Alex            CLARK         .

[Astounding · Accepted solution]

Given that you have the PROC FREQ counts stored as a second SAS data set,  you could use:

data want;

merge have1 have2 (rename=(count=number));

by id;

output;

number = .;

run;