Hi all, Thanks for all your help so far, this is the last step that I've been trying to figure out and was wondering if there's an efficient way to go about doing this. Currently I have data set up in this format: ID EndDate Value Days 1 1/1/00 2 1 1 1/2/00 2 2 1 2/1/00 3 3 1 etc 3 4 1 etc 3 5 1 2 1/1/00 2 1 2 1/2/00 2 2 2 2/1/00 3 3 2 etc 3 4 2 etc 3 5 The end product is going to be ID Month1Sum Month1Avg Month2Sum Month2Avg 1 2 3 4 etc So in essence, what I'm trying to do is for "Days" 1-30, to get the sum and avg of the "Value" column as two new variables, then 31-60, etc. This is a slice of code to show how the breakdown of months would work m12 would be the enddate-30. Days,Days+30,m1); Days+31,Days+60,m2); Days+61,Days+90,m3); Days+91,Days+120,m4); Days+121,Days+150),m5); Days+151,Days+180),m6); Days+181,Days+210),m7); Days+211,Days+240),m8); Days+241,Days+270),m9); Days+271,Days+300),m10); Days+301,Days+330),m11); Thanks again for all your help!
... View more