Date:         Fri, 9 Sep 2005 12:45:12 -0400
Reply-To:     "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject:      Re: Replicating by groups to support cumulative sums
Comments: To: sas-l@uga.edu

Toby wrote:
> Richard,
>
> Could you throw us some data and tell us how many passes of the data
> you want to do this in?
>
> Toby Dunn

One pass.

All variables (10) prior to value are categorical.

fyear,interval,date,mgroup,topic,boss,dept,team,user,metric,value
2005,Week Ending,10/3/2004,Candy,Sweet,PTSHCN,I,1,Jenkins,eaten,1
2005,Week Ending,10/3/2004,Candy,Sweet,PTSHCN,I,1,Jenkins,eaten,1
2005,Week Ending,10/3/2004,Candy,Sweet,OOCO,VIII,2,Lester,eaten,1
2005,Week Ending,10/3/2004,Candy,Sweet,OOCO,VIII,2,Lester,eaten,1
2005,Week Ending,10/3/2004,Candy,Sweet,PTSHCN,I,1,Jenkins,chew_time,.
2005,Week Ending,10/3/2004,Candy,Sweet,PTSHCN,I,1,Jenkins,chew_time,.
2005,Week Ending,10/3/2004,Candy,Sweet,OOCO,VIII,2,Lester,chew_time,.
2005,Week Ending,10/3/2004,Candy,Sweet,OOCO,VIII,2,Lester,chew_time,.
2005,Week Ending,10/3/2004,Grants,Sour,PAHD/PTSHCN,I,2,Valentine,eaten,1
2005,Week
Ending,10/3/2004,Grants,Sour,PAHD/PTSHCN,I,2,Valentine,chew_time,60
2005,Week Ending,10/3/2004,Grants,Hot,PAHD/PTSHCN,I,2,Valentine,eaten,1
2005,Week Ending,10/3/2004,Grants,Hot,PAHD/PTSHCN,I,2,Valentine,eaten,1
2005,Week Ending,10/3/2004,Grants,Hot,CPICN,I,2,Valentine,eaten,1
2005,Week Ending,10/3/2004,Grants,Hot,PAHD/PTSHCN,I,2,Valentine,chew_time,.
2005,Week Ending,10/3/2004,Grants,Hot,PAHD/PTSHCN,I,2,Valentine,chew_time,.
2005,Week Ending,10/3/2004,Grants,Hot,CPICN,I,2,Valentine,chew_time,.

2005,Week Ending,10/10/2004,Candy,Sweet,RDSTA,VII,1,Dolan,eaten,1
2005,Week Ending,10/10/2004,Candy,Sweet,RDSTA,VII,1,Dolan,eaten,1
2005,Week Ending,10/10/2004,Candy,Sweet,OMF,VIII,2,Lester,eaten,1
2005,Week Ending,10/10/2004,Candy,Sweet,RDSTA,VII,1,Dolan,chew_time,.
2005,Week Ending,10/10/2004,Candy,Sweet,RDSTA,VII,1,Dolan,chew_time,.
2005,Week Ending,10/10/2004,Candy,Sweet,OMF,VIII,2,Lester,chew_time,.

2005,Week Ending,10/31/2004,Candy,Sweet,RDSTA,VII,1,Dolan,eaten,1
2005,Week Ending,10/31/2004,Candy,Sweet,PHPDCCN,VII,1,Dolan,eaten,1
2005,Week Ending,10/31/2004,Candy,Sweet,RDSTA,VII,1,Dolan,chew_time,.
2005,Week Ending,10/31/2004,Candy,Sweet,PHPDCCN,VII,1,Dolan,chew_time,.
2005,Week Ending,10/31/2004,Grants,Frozen,PAHD/PTSHCN,I,2,Valentine,eaten,1
2005,Week
Ending,10/31/2004,Grants,Frozen,PAHD/PTSHCN,I,2,Valentine,chew_time,45


Cumulative sumarry of 10/3 need to be replicated at 10/10 - program has to
determine these
2005,Week Ending,10/10/2004,Candy,Sweet,PTSHCN,I,1,Jenkins,eaten,2
2005,Week Ending,10/10/2004,Candy,Sweet,OOCO,VIII,2,Lester,eaten,2
2005,Week Ending,10/10/2004,Candy,Sweet,PTSHCN,I,1,Jenkins,chew_time,.
2005,Week Ending,10/10/2004,Candy,Sweet,OOCO,VIII,2,Lester,chew_time,.
2005,Week Ending,10/10/2004,Grants,Sour,PAHD/PTSHCN,I,2,Valentine,eaten,1
2005,Week
Ending,10/10/2004,Grants,Sour,PAHD/PTSHCN,I,2,Valentine,chew_time,60
2005,Week Ending,10/10/2004,Grants,Hot,PAHD/PTSHCN,I,2,Valentine,eaten,2
2005,Week Ending,10/10/2004,Grants,Hot,CPICN,I,2,Valentine,eaten,1
2005,Week Ending,10/10/2004,Grants,Hot,PAHD/PTSHCN,I,2,Valentine,chew_time,.
2005,Week Ending,10/10/2004,Grants,Hot,CPICN,I,2,Valentine,chew_time,.

Cumulative summary of 10/3 and 10/10 need to be replicated at 10/31
2005,Week Ending,10/31/2004,Candy,Sweet,RDSTA,VII,1,Dolan,eaten,2
2005,Week Ending,10/31/2004,Candy,Sweet,OMF,VIII,2,Lester,eaten,1
2005,Week Ending,10/31/2004,Candy,Sweet,PTSHCN,I,1,Jenkins,eaten,2
2005,Week Ending,10/31/2004,Candy,Sweet,OOCO,VIII,2,Lester,eaten,2
2005,Week Ending,10/31/2004,Candy,Sweet,RDSTA,VII,1,Dolan,chew_time,.
2005,Week Ending,10/31/2004,Candy,Sweet,OMF,VIII,2,Lester,chew_time,.
2005,Week Ending,10/31/2004,Candy,Sweet,PTSHCN,I,1,Jenkins,chew_time,.
2005,Week Ending,10/31/2004,Candy,Sweet,OOCO,VIII,2,Lester,chew_time,.
2005,Week Ending,10/31/2004,Grants,Sour,PAHD/PTSHCN,I,2,Valentine,eaten,1
2005,Week
Ending,10/31/2004,Grants,Sour,PAHD/PTSHCN,I,2,Valentine,chew_time,60
2005,Week Ending,10/31/2004,Grants,Hot,PAHD/PTSHCN,I,2,Valentine,eaten,2
2005,Week Ending,10/31/2004,Grants,Hot,CPICN,I,2,Valentine,eaten,1
2005,Week Ending,10/31/2004,Grants,Hot,PAHD/PTSHCN,I,2,Valentine,chew_time,.
2005,Week Ending,10/31/2004,Grants,Hot,CPICN,I,2,Valentine,chew_time,.

--
Richard A. DeVenezia
http://www.devenezia.com/