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
data want;
set have;
cum+transactions;
run;
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.