topic Same ID has same data use do loop in SAS Programming

Same ID has same data use do loop

J_hoon — Wed, 13 Mar 2019 08:21:13 GMT

I want to fill the data.

The same IDs have the same value.

For example, See under table.

I want to fill 12th row in Dose Group '10 mg' using do loop

becaues, 11th row and 12th row are same Subject Number.

Likewise, 13th row and 14th row, 15th row and 16th row has same value.

How can I do that? Please help me.

Re: Same ID has same data use do loop

PeterClemmensen — Wed, 13 Mar 2019 08:27:48 GMT

You can do something like this

data MyData;
input Subject $ DoseGroup $;
datalines;
2001 10mg
2001 .
2002 10mg
2002 .
2003 10mg
2003 .
;

data Want;
   update MyData(obs=0) MyData;
   by Subject;
   output;
run;
 
proc print data=Want noobs;
run;

Re: Same ID has same data use do loop

Kurt_Bremser — Wed, 13 Mar 2019 08:40:26 GMT

Can we assume that a missing value for the dose group is ALWAYS preceded by a non-missing value? Or could it be that the first value for a subject is already missing?