Date:         Fri, 24 May 1996 15:48:05 EDT
Reply-To:     PETRONIS@CESAR.UMD.EDU
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         PETRONIS@CESAR.UMD.EDU
Subject:      multiple records per id

Dear SAS-Lers,
 
I am trying to condense multiple records per id into one record per
id.  I know how to do this if the number of multiple records is
constant (e.g., 5 records per id), but not if it varies (e.g., 5
records for one id, 10 records for another id).
 
[background:  a battery of tests were repeatedly administered; number
of administrations depends on length of stay; i need to count the
number of administrations, and the number of positive results on each
of the tests, and store this in a single record for each id]
 
Does anyone have some example code for such a situation?  Please
respond to me directly (petronis@cesar.umd.edu) as I don't subscribe
to this list.
 
Thanks in advance,
 
----------------------------------------------------------------------
Ken Petronis
Center for Substance Abuse Research
University of Maryland at College Park
4321 Hartiwick Road, Suite 501
College Park, MD  20740