Missing values are filled with the next observation

HannaZhang — Wed, 29 Jul 2020 05:49:06 GMT

Hi guys,

I want to fill Missing values with the next observation or previous observation under certain conditions.

The conditions as follows

The missing data at the first half is replaced by the previous adjacent data, and the missing data at the second half is replaced by the next adjacent data. If there is residual data in the middle, the next adjacent data is used instead.

Thanks a lot.

Data have;
 input id var1;
 datalines;
 1 54
 1 60
 1 62
 1 .
 1 .
 1 .
 2 100
 2 100
 3 .
 3 .
 3 .
 3 .
 3 72
 ;
Run;

Data want;
 input id var1;
 datalines;
 1 54
 1 60
 1 62
 1 62
 1 100
 1 100
 2 100
 2 100
 3 100
 3 100
 3 72
 3 72
 3 72

 ;
Run;

Re: Missing values are filled with the next observation

PeterClemmensen — Wed, 29 Jul 2020 07:31:12 GMT

How bog is your data set?

Re: Missing values are filled with the next observation

HannaZhang — Wed, 29 Jul 2020 08:14:26 GMT

About 117mb

topic Re: Missing values are filled with the next observation in SAS Programming

Missing values are filled with the next observation

Re: Missing values are filled with the next observation

Re: Missing values are filled with the next observation