Hi, I'm quite new to SAS and I'm trying to perfrom a sumif function on a data set in DI, but I cant find an equivalent procedure / code that would help me with this. I have the data set below. Bucket A Bucket B Value 1 10 10 2 10 6 3 10 3 1 20 9 2 20 5 3 20 2 1 30 8 2 30 4 3 30 1 I want to add a column to sum the values >= Bucket A, but also to exclude the values of the previous row, so I've used a SUMIF with reative referencing. For example, the fourmula in cel D2 is, =SUMIF(A2:A10,">="&A2,C2:C10) = 48. Bucket A Bucket B Value sumif (>=A) 1 10 10 48 2 10 6 21 3 10 3 6 1 20 9 29 2 20 5 12 3 20 2 3 1 30 8 13 2 30 4 5 3 30 1 1 Is there a way to recreate this in SAS and DI? Many thanks, Neil
... View more