topic Counting observations by ID in SAS Programming

Counting observations by ID

umesh1 — Thu, 25 Jan 2018 18:17:39 GMT

Hi All,

I have data set as below where I have client_id. I would like to count them as below. I would like to get the count variable as follows

ballardw — Thu, 25 Jan 2018 18:21:27 GMT

If the data is sorted by your id variable you could use:

data want;

set have;

by client_id;

if first.client_id then count=1;

else count+1;

run;