Date:         Wed, 16 Jun 2010 11:28:46 -0700
Reply-To:     "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Subject:      Re: data manipulation?
In-Reply-To:  <201006161816.o5G9H9H1018982@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Loop through the observations.
   If the ID is not missing, copy it to a retained variable.
   If the ID is missing, set it to the retained value.
Endloop.

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Michelle Secic
Sent: Wednesday, June 16, 2010 11:17 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: data manipulation?

I have data like this:

ID  Day   etc...
1    1
.    2
.    3
.    4
2    1
.    2
etc.

I need it like this:

ID  Day   etc...
1    1
1    2
1    3
1    4
2    1
2    2
etc.

Please help!