Desktop productivity for business analysts and programmers

How Can I Create Cumulative Totals?

Accepted Solution Solved
Reply
N/A
Posts: 1
Accepted Solution

How Can I Create Cumulative Totals?

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


Accepted Solutions
Solution
‎10-27-2014 09:20 PM
Trusted Advisor
Posts: 1,203

Re: How Can I Create Cumulative Totals?

data want;

set have;

cum+transactions;

run;

View solution in original post


All Replies
Solution
‎10-27-2014 09:20 PM
Trusted Advisor
Posts: 1,203

Re: How Can I Create Cumulative Totals?

data want;

set have;

cum+transactions;

run;

Grand Advisor
Posts: 9,584

Re: How Can I Create Cumulative Totals?

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 321 views
  • 4 likes
  • 3 in conversation