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 (March 2009, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 11 Mar 2009 15:14:26 -0400
Reply-To:     SAS_learner <proccontents@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SAS_learner <proccontents@GMAIL.COM>
Subject:      Re: Column totals
Comments: To: Gerhard Hellriegel <gerhard.hellriegel@t-online.de>
In-Reply-To:  <200903111829.n2BAlXkS025864@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

Hello all,

Just curious in this question the poster wanted the totals of all the months right??

In the Past I did something using Proc Sql and put it back in the dataset Just was thinking weather we can do Mon1--Mon12 IF all they are named as Mon1 (Instead of Jan ) What I mean is

Proc Sql ; Create table aa as Select Sum(Mon1) as Sum_m1 , Sum(mon2) as Sum_m2 .......(All the Months) From test Group by Mon1--Mon12 ; (Is there anything similar to this Syntax as this not be supported by SQL )

Thanks SL

On Wed, Mar 11, 2009 at 2:29 PM, Gerhard Hellriegel < gerhard.hellriegel@t-online.de> wrote:

> for what use? Do you only report them -> take PROC REPORT. If you want to > continue processing with that sums, take PROC SUMMARY to put them into a > SAS-dataset. > > For both you can select the totals you want. Simply define the other > (unwanted) columns as type=display in REPORT. > In SUMMARY you select the analysis variables with the VAR statement. If > you dont't want subgroups with their subtotals, you should use no CLASS > statement. > > Gerhard > > > > > On Wed, 11 Mar 2009 11:05:58 -0700, kk.majji@GMAIL.COM wrote: > > >Please help me in getting the total only for all the SUM columns in > >the below table. > > > > > > Sep Oct Nov > >Dec Jan Feb > > Sum count Sum count Sum count Sum count Sum count > >Sum count Total Sum > >abc 871 655 690 491 524 363 499 363 1280 > >899 680 414 ? > >dfd 420 163 415 147 399 159 459 170 655 > >183 631 192 ? > >lmn 21 14 27 11 25 16 19 11 > >46 25 34 16 ? > >Total 1388 879 1143 660 958 546 991 553 1991 > >1117 1347 624 ? > > > >Thanks, > >KK. >


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