Date:         Mon, 16 Jun 2003 21:10:33 +0100
Reply-To:     Roland <roland@RASHLEIGH-BERRY.FSNET.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Roland <roland@RASHLEIGH-BERRY.FSNET.CO.UK>
Subject:      Re: fill out missing data

My LOCF macro might do the trick. Take a look first at this page.
http://www.datasavantconsulting.com/roland/locf.html

Link to macro is at the end of the page:
http://www.datasavantconsulting.com/roland/locf.sas


"Wang, George" <gwang@OXHP.COM> wrote in message
news:6C01CB64CBD7AF4C87EBA4941D6D03172E690F@cttrbex01.trb.oxhp.com...
> Hi,
>
> I have a dataset such as:
>
> code    dollar
> aa      100
>         200
>         300
> bb      230
>         340
> cc      120
>         230
>
> I need data as following:
> aa      100
> aa      200
> aa      300
> bb      230
> bb      340
> cc      120
> cc      230
>
> any suggestion and method is appeciated.  Thanks in advance.
>
> George