Fill in missing values

Magaarnico — Fri, 03 May 2013 12:48:47 GMT

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

Re: Fill in missing values

Ksharp — Fri, 03 May 2013 13:12:36 GMT

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

topic Fill in missing values in SAS Programming

Fill in missing values

Re: Fill in missing values