Fill in missing values

[Magaarnico]

I have a dataset with time, bid ask

For example

Time                    Bid               Ask

1/1/2013               2                    1

1/2/2013                .                    2

1/3/2013               3                    4

1/4/2013               .                    3

1/5/2013               .                    2

1/6/2012               4                    1

I want to fill in the mssing values (.) with the last observation

For example at 1/5/2013 under bid it must say 3. Tried to use LOFC and Retain..

But doesent work:/

any one have i code i can use 😃

thx in advance

[Ksharp]

data have;
input Time  :mmddyy10.                 Bid               Ask;
format time mmddyy10.;
cards;
1/1/2013               2                    1
1/2/2013                .                    2
1/3/2013               3                    4
1/4/2013               .                    3
1/5/2013               .                    2
1/6/2012               4                    1
;
run;
data want;
 set have;
 retain _bid;
 if not missing(bid) then _bid=bid;
 drop bid;
run;

Ksharp