Counting observations by ID

Accepted Solution Solved
Reply
Contributor
Posts: 36
Accepted Solution

Counting observations by ID

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         .

 


Accepted Solutions
Solution
‎05-02-2017 08:45 AM
Super User
Posts: 5,372

Re: Counting observations by ID

[ Edited ]

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;

 

 

View solution in original post


All Replies
Solution
‎05-02-2017 08:45 AM
Super User
Posts: 5,372

Re: Counting observations by ID

[ Edited ]

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;

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 126 views
  • 0 likes
  • 2 in conversation