Date:         Tue, 29 Sep 1998 14:51:03 -0700
Reply-To:     Pamela Mery <pmery@CCSF.CC.CA.US>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Pamela Mery <pmery@CCSF.CC.CA.US>
Subject:      aggregating a single numeric field by an ID#
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hi all.  Short question which hopefully has an easy answer.  I have large
files with multiple student records for each class they attend.  I would
like to total the attendance hours for each student for all of the classes
that student enrolled in.  In the example below three ID numbers are
represented.  If totalled, each of their hours would equal fifteen.  I
imagine the first step is to sort by ID, but then what???
 
ID      HOURS
14890   8
14890   2
14890   5
28954   12
28954   3
88965   15
99954
etc.
 
 
Thanks for any and all help.
BTW, I asked an EXCEL question a while ago.  None of the answers exactly
served, but if I do figure it out, I'll post to the list.
 
Thanks again.
 
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
      Pamela M. Mery               Institutional Research & Planning
City College of San Francisco  50 Phelan Avenue  San Francisco, CA 94112
  E-mail:pmery@ccsf.cc.ca.us  Phone:415.239.3227   Fax:415.239.3010
 
                       ** BE AN ORGAN DONOR **
                        * sign a donor card *
 
         For more information lookup http://www.transweb.org
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --