Date:         Thu, 24 Aug 2006 09:34:14 -0500
Reply-To:     "data _null_;" <datanull@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "data _null_;" <datanull@GMAIL.COM>
Subject:      Re: Fill in missing score
Comments: To: Thien Thai <coithienthai2002@yahoo.com.au>
In-Reply-To:  <200608241245.k7OAkZ4V025566@mailgw.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Seems to me like you really just want to count the IDs.  What is the
new data set for?  I would think you could do the just as well with
the following data set.

data work.score;
   infile cards missover;
   input ID Score;
   cards;
12225 0.365516711
12225
13073 0.32885697
13073
13073
15494 0.466036457
15494
33501 0.159729592
33501
;;;;
   run;
proc summary data=work.score nway missing;
   class id;
   output out=work.idFREQ(drop=_type_)
      idgroup(out(score)=)
      ;
   run;
proc print;
   run;

Obs      ID     _FREQ_     Score

1     12225       2      0.36552
2     13073       3      0.32886
3     15494       2      0.46604
4     33501       2      0.15973


On 8/24/06, Thien Thai <coithienthai2002@yahoo.com.au> wrote:
> 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
>