Fill in missing values

Reply
New Contributor
Posts: 3

Fill in missing values

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

Super User
Posts: 10,020

Re: Fill in missing values

Posted in reply to Magaarnico
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

Ask a Question
Discussion stats
  • 1 reply
  • 134 views
  • 0 likes
  • 2 in conversation