```Date: Sat, 27 Jan 2007 22:53:50 -0500 Reply-To: "Howard Schreier " Sender: "SAS(r) Discussion" From: "Howard Schreier " Subject: Re: Comparing date variable On Wed, 24 Jan 2007 04:29:29 -0800, hema wrote: >Thanks Toby.. Can you help me on this ? > > Customer Basket Item Basketdate c1 1 b 31-Jan-04 c1 1 a 31-Jan-04 c1 1 b 31-Jan-04 c1 2 a 6-Nov-04 c1 2 a 6-Nov-04 c1 2 b 6-Nov-04 c1 2 b 6-Nov-04 c1 3 a 14-Feb-05 c1 3 b 14-Feb-05 c1 4 a 31-Dec-06 c1 4 b 31-Dec-06 c2 1 a 29-Nov-04 c2 2 a 15-Mar-05 c2 3 b 9-Sep-05 c2 3 b 9-Sep-05 c2 3 b 9-Sep-05 c2 3 a 9-Sep-05 c2 4 a 25-Dec-06 c2 4 a 25-Dec-06 c2 4 a 25-Dec-06 c2 4 b 25-Dec-06 > > >Say,This is the data i have.I have a sequence that a :) b .i.e "a" preceeds "b" . > I want to three revenues to be calculated. Revenue of a,revenue of b , and revenue of a,b . this is with respect to customer. > Revenue of "a" will be sum of revenue of a where "a" has occured before "b". > Similarly Revenue of "b" will be the sum of revenue of b where b has occured after "a". > Revenue of "a","b" will be sum of revenue of a and b given the fact that "a" preceeds "b". > > In short, Adding the revenue of all "a" which has "b" following. even if one "b" follows 5 "a"'s i would want revenue of all 5 "a"'s summed .Similarly, i want revenue of all "b" following "a". > Only one point to be remembered is that for the first time when "a" appears, in that basket revenue of "b" is considered and the basket which has last count of "b" , revenue of "a" if "a" is present in that basket, is not considered. > > Can you help on this? > > Regards, > Hema [snip] I can help just by un-munging your post so that the table appears as such and there is a little whitespace. Customer Basket Item Basketdate c1 1 b 31-Jan-04 c1 1 a 31-Jan-04 c1 1 b 31-Jan-04 c1 2 a 6-Nov-04 c1 2 a 6-Nov-04 c1 2 b 6-Nov-04 c1 2 b 6-Nov-04 c1 3 a 14-Feb-05 c1 3 b 14-Feb-05 c1 4 a 31-Dec-06 c1 4 b 31-Dec-06 c2 1 a 29-Nov-04 c2 2 a 15-Mar-05 c2 3 b 9-Sep-05 c2 3 b 9-Sep-05 c2 3 b 9-Sep-05 c2 3 a 9-Sep-05 c2 4 a 25-Dec-06 c2 4 a 25-Dec-06 c2 4 a 25-Dec-06 c2 4 b 25-Dec-06 >Say,This is the data i have. >I have a sequence that a :) b .i.e "a" preceeds "b" . >I want to three revenues to be calculated. Revenue of a,revenue of b , and revenue of a,b . this is with respect to customer. Revenue of "a" will be sum of revenue of a where "a" has occured before "b". Similarly Revenue of "b" will be the sum of revenue of b where b has occured after "a". Revenue of "a","b" will be sum of revenue of a and b given the fact that "a" preceeds "b". >In short, Adding the revenue of all "a" which has "b" following. even if one "b" follows 5 "a"'s i would want revenue of all 5 "a"'s summed .Similarly, i want revenue of all "b" following "a". >Only one point to be remembered is that for the first time when "a" appears, in that basket revenue of "b" is considered and the basket which has last count of "b" , revenue of "a" if "a" is present in that basket, is not considered. A bit easier to read, no? However, there is no REVENUE variable to sum. Perhaps you can re-post and include such a variable as well as the expected results. ```

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