data temp;
input id num;
datalines;
1 1
1 2
1 1
2 1
2 2
3 1
;
run;
proc sort data=temp;
by id;
run;
data temp1;
set temp;
by id;
count+1;
if first.id then count=1;
run;
proc sort;
by id descending count;
run;
data temp2;
set temp1;
by id;
retain totc;
if first.id then
totc=count;
output;
run;
proc print;
run;
If you run the program above, you will get the following SAS output:
id num count totc
1 1 1 3
1 2 2 3
1 1 3 3
2 1 1 2
2 2 2 2
3 1 1 1
