[Download-List] Count Records in Group

[David L. Rotman]

I'm guessing that TALLY is an older version of what we now
call HISTOGRAM (available on ftp.cedarville.edu).

The output would be similar to what John used as an illustration,
except that (by default) there would be rows of asterisks to indicate the
relative size of each group.  The asterisks can be omitted by
specifying TALLY.ONLY on the command line.





Dave Rotman
Associate Vice President for Technology
Chief Information Officer
Cedarville University
251 N. Main Street
Cedarville, OH 45314
rotmand at cedarville.edu
voice 937-766-7905
fax 937-766-8819


>>> John Davis <davisj at marietta.edu> 9/29/2008 12:44 PM >>>

Try Cedarville's TALLY command.  For example, to count all the various  
classifications, then select the students for the term and then tally.

SELECT STUDENT.TERMS WITH STTR.TERM = '08/FL' ....
TALLY STUDENT.TERMS STTR.CLASS

The output would be similar to the following:

TALLY OF "STTR.CLASS" FOR FILE STUDENT.TERMS
09/29/08 12:44:16PM


NULL               3
AB                13
CE               102
FF               412
FR                65
HS                 4
JR               323
MC                22
ME                41
ML                 1
MP                20
ND                 6
SO               404
SR               291

1707 SOURCE KEYS READ FROM SELECT LIST
1707 SOURCE RECORDS INCLUDED ON THE REPORT
0 SOURCE RECORDS EXCLUDED FROM THE REPORT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  John R. Davis, CIO           E-mail: davisj at marietta.edu 
  Information Technology       http://www.marietta.edu/~davisj 
  Marietta College
  215 5th St                   Voice: (740) 376-4390
  Marietta, OH  45750          Fax:   (740) 376-4812
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Quoting Brian Pollitt <bpollitt at dacc.edu>:

> Hi everyone,
>
> I was wondering if there's a way to count the number of records in a
> group, and also get the total count of records for the entire list?
>
> Thanks so much for the help!
>
> -- 
> Brian Pollitt
> Programmer/Database Administrator
> Administrative Data Systems
> Danville Area Community College
> (217)443-8854



----------------------------------------------------------------
This message was sent using Marietta College WebMail.


_______________________________________________
download-list mailing list
download-list at cedarville.edu 
http://mail.cedarville.edu/mailman/listinfo/download-list