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 2008, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 14 Jan 2008 04:40:28 -0800
Reply-To:     ChrisG <chris.godlewski@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         ChrisG <chris.godlewski@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: cumulative sum with subgroups ?
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On 12 jan, 09:30, jiangtan...@GMAIL.COM ("Hu, Jiangtang") wrote: > A modified version of Warren's, delete "retain cumsum", and replace > "cumsum=sumnb+cumsum" with " cumsum+sumnb": > > data out; > set test; > by id; > if first.id then cumsum=sumnb; > else cumsum+sumnb; > run; > > On Jan 12, 2008 1:15 AM, Warren Schlechte <Warren.Schlec...@tpwd.state.tx.us> > wrote: > > > > > data test; > > input id date nnb sumnb; > > datalines; > > 1 10 2 15 > > 1 11 1 15 > > 1 12 1 20 > > 1 13 1 10 > > 2 7 1 150 > > 2 9 1 200 > > 2 10 2 150 > > 2 17 1 300 > > ; > > run; > > > proc sort data=test; by id;run; > > > data out; > > set test; > > by id; > > retain cumsum; > > if first.id then cumsum=sumnb; else cumsum=sumnb+cumsum; > > run; > > > proc fsview data=out;run; > > > Warren Schlechte > > > -----Original Message----- > > From:ChrisG[mailto:chris.godlew...@GMAIL.COM] > > Sent: Friday, January 11, 2008 10:51 AM > > Subject: cumulative sum with subgroups ? > > > Hi > > > Suppose i have such dataset : > > > id date nnb sumnb > > 1 10 2 15 > > 1 11 1 15 > > 1 12 1 20 > > 1 13 1 10 > > 2 7 1 150 > > 2 9 1 200 > > 2 10 2 150 > > 2 17 1 300 > > > i would like sas to do the following thing in a additional variable, > > let call it cumsumnb : > > > id date nnb sumnb cumsumnb > > 1 10 2 15 15 > > 1 11 1 15 30 > > 1 12 1 20 50 > > 1 13 1 10 60 > > 2 7 1 150 150 > > 2 9 1 200 350 > > 2 10 2 150 500 > > 2 17 1 300 800 > > > in other words, to calculate in an 'incremental way' the cumulative > > sum of sumnb by date within the id subgroup ... > > > i hope i was clear enough ... > > > many thanks for any help ! > > > cheers > > > CG > > -- > John Jiangtang Hu

thanks to everybody !!! it works !

cheers CG


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