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 2006, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 31 Mar 2006 17:03:10 -0500
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: Finding out of weekly sum

Actually, there is no need to crank up a DATA step view. SQL can create the week numbers on the fly:

select Week(Date)as Week , Sum(Humidity) as SubTotal from Weekly group by Week ;

On the other hand, if that view *is* created, we can forget SQL altogether and let PROC SUMMARY do both levels of total at once:

proc summary data=aaa; class week; var Humidity; output out=SubTotals_and_Totsals sum=; run;

On Fri, 31 Mar 2006 05:42:01 +0000, toby dunn <tobydunn@HOTMAIL.COM> wrote:

>Chait , > >You also ddint mention whether you wanted the weeks to start on sunday and >go 7 days, whether you wanted the seven day count to start on the 1st and a >week is defined as six days from that date, or if you wanted to use the >calander. > >Also, you never mentioned what the Total was made ofm a cumulative sum by >week or the whole data set. > >And finally you didnt mention ehat version of SAS you have which makes a >difference in what one can use in the way of functions and how much code it >will take. > > >So here is a solution which I think can be refactor to run faster and >assumes version 9 and the Total is the total of humidity for the entire data >set: > >data weekly ; >input date mmddyy10. humidity ; >cards ; >1/1/2002 1 >1/2/2002 2 >1/3/2002 3 >1/4/2002 4 >1/5/2002 5 >1/6/2002 6 >1/7/2002 7 >1/8/2002 8 >1/9/2002 9 >1/10/2002 10 >1/11/2002 11 >1/12/2002 12 >1/13/2002 13 >1/14/2002 14 >1/15/2002 15 >1/16/2002 16 >1/17/2002 17 >1/18/2002 18 >1/19/2002 19 >1/20/2002 20 >; >run ; > > >data AAA / view = AAA ; >set Weekly ; >Week = Week(Date) ; >run ; > >proc sql ; >Create table SubTotal as > select Week , Sum(Humidity) as SubTotal > from AAA > group by Week ; > >Create table Need as > select * , Sum(SubTotal) as Total > from SubTotal ; >quit ; > > > > >Toby Dunn > > > > > >From: chait <v.r.krishnachaitanya@GMAIL.COM> >Reply-To: chait <v.r.krishnachaitanya@GMAIL.COM> >To: SAS-L@LISTSERV.UGA.EDU >Subject: Finding out of weekly sum >Date: Thu, 30 Mar 2006 20:06:58 -0800 > >data weekly; >input date mmddyy10. humidity; >cards; >1/1/2002 1 >1/2/2002 2 >1/3/2002 3 >1/4/2002 4 >1/5/2002 5 >1/6/2002 6 >1/7/2002 7 >1/8/2002 8 >1/9/2002 9 >1/10/2002 10 >1/11/2002 11 >1/12/2002 12 >1/13/2002 13 >1/14/2002 14 >1/15/2002 15 >1/16/2002 16 >1/17/2002 17 >1/18/2002 18 >1/19/2002 19 >1/20/2002 20 >; >run; > >Like this there are thousands of data is there in raw file. > > We want the weekly sum i.e for every 7 days we want the sum of >humidity and as well as the total sum.


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