Desktop productivity for business analysts and programmers

How Can I Create Cumulative Totals?

Accepted Solution Solved
Reply
New User
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,228

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,228

Re: How Can I Create Cumulative Totals?

data want;

set have;

cum+transactions;

run;

Super User
Posts: 9,854

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 and locked.

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

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