topic Re: How to replace missing value using values in the previous line? in SAS Procedures

How to replace missing value using values in the previous line?

Ken_oy — Wed, 29 Jul 2009 20:54:27 GMT

Hello everyone,

I want to ask how to use values in the previous line to replace the missing value?
Any help? I try:

if missing(a) then a=lag(a);

but this does not work.

Thank you! and Wait online!

-----------Before--------------
a b c

1 2 3
. . .
. . .
2 3 4
. . .
. . .
. . .
. . .
3 5 6
. . .
----------After------------

a b c

1 2 3
1 2 3
1 2 3
2 3 4
2 3 4
2 3 4
2 3 4
2 3 4
3 5 6
3 5 6

--------------------------

Re: How to replace missing value using values in the previous line?

sbb — Wed, 29 Jul 2009 21:44:48 GMT

Perform the lag function assignment for each observation, creating:

l_a = lag(a);

then do you conditional assignment / override when the missing condition occurs.

Scott Barry
SBBWorks, Inc.

Re: How to replace missing value using values in the previous line?

HenrikOlsen — Thu, 30 Jul 2009 13:04:34 GMT

or use:

a=coalesce(a,lag(a));