last missing visits imputed with locf (the baseline is not carrried forward)

michtka — Wed, 24 Oct 2012 03:09:00 GMT

Hi everyone, I got the next dataset:

The idea is imputed only the missing value of the last visits with LOCF, the missing intermediate visits remaining missing, and the carried baseline (i.e week2) if it is missing remaining missing.

In Bold face I show the visits need to be imputed with LOCF

data new;

input subjid week value;

datalines;

1 Baseline 10

1 Week2 12

1 week8 14

1 week12 16

2 baseline 12

2 week2 4

2 week8 14

3 Baseline 13

3 week4 5

3 week12 2

4 baseline 1

4 week2 3

5 Baseline 3

5 Week2 5

5 week12 6

run;

and I am looking for the want dataset:

1 Baseline 10

1 Week2 12

1 week8 14

1 week12 16

2 baseline 12

2 week2 4

2 week8 14

2 week12 14

3 Baseline 13

3 week4 5

3 week12 2

4 baseline 1

4 week2 3

4 week4 3

4 week8 3

4 week12 3

5 Baseline 3

5 Week2 5

5 week12 6

I hope you can help me.

Thnaks.

topic last missing visits imputed with locf (the baseline is not carrried forward) in SAS Procedures

last missing visits imputed with locf (the baseline is not carrried forward)