Data imputation in SAS

[munitech4u]

How to do this in SAS:

I want to replace a missing value with the mean of lagged value and its next value?

[Jagadishkatam]

i believe it could be achieved by using the lag function.

may be sample data and the expected output could help to get better solution.

Thanks,

Jag

[jakarman]

There have been a lot of the same questions. https://communities.sas.com/thread/59681

Or google: "impute missings site:communities.sas.com"

[PGStats]

If you have access to SAS/ETS, use the Expand procedure :

data myData;

input time value;

datalines;

0 -100

1 10

2 25

3 .

4 35

5 .

6 .

7 55

8 -1

;

proc expand data=myData out=filledData method=none;

id time;

convert value=filledValue / transformout=(missonly cmovave 3);

run;

proc print data=filledData noobs; run;

PG