topic Re: Assign sequence based dose starting from zero in SAS Programming

Assign sequence based dose starting from zero

chinna0369 — Tue, 21 Sep 2021 00:55:43 GMT

Hi all,

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

ID DOSE

1 20

1 17

1 15

I want like below

ID DOSE SEQ

1 20 0

1 17 1

1 15 2

Can you please help me with this.

Thanks,

Adi

Re: Assign sequence based dose starting from zero

Astounding — Tue, 21 Sep 2021 03:43:16 GMT

One way:

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

Re: Assign sequence based dose starting from zero

chinna0369 — Tue, 21 Sep 2021 12:15:40 GMT

No, this is not working. Thanks!

Re: Assign sequence based dose starting from zero

Astounding — Tue, 21 Sep 2021 16:13:44 GMT

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

Re: Assign sequence based dose starting from zero

Kurt_Bremser — Tue, 21 Sep 2021 16:20:04 GMT

@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.