Counting observations by ID

John4 — Tue, 02 May 2017 12:32:20 GMT

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 .

Re: Counting observations by ID

Astounding — Tue, 02 May 2017 12:40:13 GMT

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;

topic Re: Counting observations by ID in SAS Programming

Counting observations by ID

Re: Counting observations by ID