|
My data is as follows:
ID date
A Jan1
A Jan1
A Jan1
B Jan1
B Jan1
A Jan2
A Jan2
B Jan2
B Jan2
B Jan2
What I need is
ID date n
A Jan1 1
A Jan1 2
A Jan1 3
B Jan1 1
B Jan1 2
A Jan2 1
A Jan2 2
B Jan2 1
B Jan2 2
B Jan2 3
The code that I wrote is:
proc sort data = have out = have ;
by ID date;
run;
data need ;
set have ;
by ID date ;
if first.ID then n = 1;
else n + 1;
run;
| 
