[Download-List] Count Records in Group

[Brian Pollitt]

David L. Rotman wrote:
> 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
> 
> 
> _______________________________________________
> download-list mailing list
> download-list at cedarville.edu
> http://mail.cedarville.edu/mailman/listinfo/download-list
The director of my department got me the results I was wanting by 
creating a computed column that had a value of "1". I was able to add 
that column to my output and the FOOTING had the total records for each 
group and the whole list.

Thank you for trying to help, though!

-- 
Brian Pollitt
Programmer/Database Administrator
Administrative Data Systems
Danville Area Community College
(217)443-8854
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bpollitt.vcf
Type: text/x-vcard
Size: 354 bytes
Desc: not available
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20080930/8234c7b0/attachment.vcf>