topic SAS_Missing observations in All Things Community

SAS_Missing observations

Khaladdin — Sun, 26 Mar 2017 14:34:29 GMT

Hi all,

I have a question. I want to ask my question as an example. I have the following datasets:

AAA Value

1 25

2 .

3 .

4 22

5 .

As you can see, there are some missing observations in column VALUE. I want to equalize this missing value to previous observations. So, the result should be:

AAA Value

1 25

2 25 ( because the previous number is 25)

3 25 ( because the previous number is 25)

4 22

5 22 ( because the previous number is 22)

Many thanks in advance.

Re: SAS_Missing observations

art297 — Sun, 26 Mar 2017 16:08:25 GMT

data want (drop=hold);
  set have;
  retain hold;
  if not missing(value) then hold=value;
  else value=hold;
run;

Art, CEO, AnalystFinder.com

Re: SAS_Missing observations

Khaladdin — Sun, 26 Mar 2017 16:17:21 GMT

Many thanks.