How Can I Create Cumulative Totals?

[eustorgio]

Hi, i'm trying to find out how to make the column "cum ( transactions )" in a SQL code, How could i do it?

Client               transactions      cum ( transactions )

1                            5                         5

1                            5                        10

1                            2                        12

1                            3                        15

2                            9                   .    24

2                            3                        27

2                           12                       39

2                            1                        40

Thanx

[stat_sas · Accepted solution]

data want;

set have;

cum+transactions;

run;

[Ksharp]

Have to us SQL ?

data have;
input Client               transactions      ;
cards;
1                            5     
1                            5      
1                            2       
1                            3      
2                            9      
2                            3     
2                           12      
2                            1     
;
run;
ods _all_ close;
ods output SQL_Results=temp;
proc sql number;
select * from have;
run; 
proc sql;
create table want as
 select *,(select sum(transactions)     from temp where row le a.row) as cum from temp as a;
quit;
ods listing;

Xia Keshan