LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 1999, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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. >


Back to: Top of message | Previous page | Main SAS-L page