Date:         Thu, 24 Aug 2006 14:13:53 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: Fill in missing score
Comments: To: coithienthai2002@YAHOO.COM.AU
In-Reply-To:  <200608241245.k7OAkZ4V025566@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

Data NeedA ( Drop = Temp ) ;
Set Foo ;
By ID ;
Retain Temp ;

If First.Id Then Temp  = Score ;
Else             Score = Temp ;

Run ;




Toby Dunn

When everything is coming at you all at once, your in the wrong lane.

A truly happy person is someone who can smile and enjoy the scenery on a
detour.





From: Thien Thai <coithienthai2002@YAHOO.COM.AU>
Reply-To: Thien Thai <coithienthai2002@YAHOO.COM.AU>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Fill in missing score
Date: Thu, 24 Aug 2006 08:45:57 -0400

Hello, I'm a new SAS user and stumbled across this problem where I need to
fill in the missing score for id that are the same. The data set looks like
this

ID Score
12225 0.365516711
12225
13073 0.32885697
13073
13073
15494 0.466036457
15494
33501 0.159729592
33501

and basically I would like to have the same score assign to ID that are the
same, any help would be much appreciated.

Ta

Thien