topic Re: How Can I Create Cumulative Totals? in SAS Enterprise Guide

How Can I Create Cumulative Totals?

eustorgio — Tue, 28 Oct 2014 00:58:45 GMT

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

Re: How Can I Create Cumulative Totals?

stat_sas — Tue, 28 Oct 2014 01:20:28 GMT

data want;

set have;

cum+transactions;

run;

Re: How Can I Create Cumulative Totals?

Ksharp — Tue, 28 Oct 2014 12:02:21 GMT

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