topic Re: Data imputation in SAS in SAS Programming

Data imputation in SAS

munitech4u — Sun, 27 Jul 2014 14:14:39 GMT

How to do this in SAS:

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

Jagadishkatam — Sun, 27 Jul 2014 16:17:41 GMT

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 — Sun, 27 Jul 2014 17:09:34 GMT

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

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

PGStats — Sun, 27 Jul 2014 17:18:11 GMT

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;