Date: Fri, 30 Jun 2006 12:47:19 -0700
Reply-To: dramage <dramage1@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: dramage <dramage1@GMAIL.COM>
Subject: Re: Replacing a Missing Value
Content-Type: text/plain; charset="iso-8859-1"
> I have a dataset where a variable s_id is the id for the site. I then
> have a variable ab_id which is the individual id for a person at the
> site. Sometimes the ab_id is empty. In this case I would like to pull
> the first next ab_id for that specific s_id .
> For example the data file looks like this:
> s_id ab_id
> 233 55
> 12 1
> 424 65
> 434 13032
> I was thinking I could do some sort of if then statement where if ab_id
> = . then pull next ab_id
> for s_id ne .
> Thanks for the help