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
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.
>
| 
