Data imputation in SAS

Reply
Regular Contributor
Posts: 187

Data imputation in SAS

How to do this in SAS:

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

Super User
Posts: 1,111

Re: Data imputation in SAS

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

Thanks,
Jag
Valued Guide
Posts: 3,206

Re: Data imputation in SAS

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

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

---->-- ja karman --<-----
Respected Advisor
Posts: 4,606

Re: Data imputation in SAS

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

PG
Ask a Question
Discussion stats
  • 3 replies
  • 179 views
  • 1 like
  • 4 in conversation