Hi David, thank you for your response. I just did a test. then i ran proc sql; select a.id, sum(a.amount) as aggregateamount from new as a,new as b where a.id >= b.id group by a.id; quit; However, the result is not what i expected.
... View more
hi everyone, Wondering what I can do to sum the following table ID Amount 1 1 2 1 3 1 4 1 5 1 6 1 where ID < = ID result shoud be ID Aggregated amount 1 1 2 2 3 3 4 4 5 5 6 6 Is there any way I can do that? thank you,
... View more