Assign sequence based dose starting from zero

[chinna0369]

Hi all, 

I would like assign a sequential order for my data. I have id dose variables. like below

ID    DOSE

1      20

1      20

1      17

1      17

1      15

1      15

I want like below 

ID  DOSE SEQ

1   20        0

1   20        0

1  17         1

1  17         1

1  15         2

1  15         2

Can you please help me with this.

Thanks,

Adi

[Astounding]

One way:

data want;
   set have;
   by id dose notsorted;
   if first.id then seq=0;
   else if first.dose then seq + 1;
run;

[chinna0369]

No, this is not working. Thanks!

[Astounding]

I don't believe you.  Prove me wrong by posting the log from your job where it doesn't work.

[Kurt_Bremser]

---

@chinna0369 wrote:
No, this is not working. Thanks!

---

Don't be silly.

data have;
input id dose;
datalines;
1      20
1      20
1      17
1      17
1      15
1      15
;

data want;
   set have;
   by id dose notsorted;
   if first.id then seq=0;
   else if first.dose then seq + 1;
run;

proc print data=want noobs;
run;

Result:

id	dose	seq
1	20	0
1	20	0
1	17	1
1	17	1
1	15	2
1	15	2

EXACTLY what you want.