Date:         Mon, 11 Jan 1999 12:55:18 -0800
Reply-To:     "Self, Karsten" <Karsten.Self@SCHWAB.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Self, Karsten" <Karsten.Self@SCHWAB.COM>
Subject:      Re: Need a summarized SAS file with counts
Comments: To: "kpkowitz@YAHOO.COM" <kpkowitz@YAHOO.COM>
Content-Type: text/plain

> ----------
> From:         kpkowitz@YAHOO.COM[SMTP:kpkowitz@YAHOO.COM]
> Reply To:     kpkowitz@YAHOO.COM
> Sent:         Tuesday, January 05, 1999 5:25 AM
> To:   SAS-L@UGA.CC.UGA.EDU
> Subject:      Need a summarized SAS file with counts
>
> I am currently trying to summarize a SAS file that requires several
> counts.
> 1) A record count (easy to do with PROC MEANS or SUMMARY)
> 2) Several other
> Counts in the same SUMMARY.
>
Modify your SQL statement as shown and post the resulting log message.  This
will show the methods SQL is using to resolve your query, as well as any
information on index utilization.
 
 
> PROC SQL
>
        /***  ADD ***/
        inobs= 0
        _method
        /*** end add ***/
            ;
 
    /*** ADD ***/
    options msglevel= i;
        /*** end add ***/
 
 
> CREATE TABLE
> COUNTS AS
> SELECT DISTINCT GROUP,
>   SUBGRP,
>   YEAR,
>   MONTH,
>   SUM(AMTPAID) as AMTPAID,
>   SUM(TAX) as TAX,
>   SUM(UNITCST) as UNITCST,
>   COUNT(*) ASRECCNT,
>   COUNT(USERID) AS USRCNT
> FROM TABLE1
> GROUP BY GROUP, SUBGRP, YEAR, MONTH
> ORDER BY GROUP, SUBGRP, YEAR, MONTH
> ;
>
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own
>
> --
> Karsten M. Self (Karsten.Self@schwab.com)
> Trilogy Consulting
>
>     What part of "gestalt" don't you understand?
>
> WARNING:  All e-mail sent to or from this address will be received by the
> Charles Schwab corporate  e-mail system and is subject to archival and
> review by someone other than the recipient.
>
> This communication does not necessarily reflect the views or position of
> The Charles Schwab Corporation, or any of its subsidiaries or their
> affiliates.
>