Find the cumulative sum (Running total) of given data set values using SQL...?

[varmalh]

hello,

can someone please advise how to get Cumulative sum(Running total) of below given data set in Proc SQL...?

data a;
input emp$ sal;
cards;
emp1 1000000
emp2 2000000
emp3 3000000
;run;

data b;
input emp$ sal;
cards;
emp1 1000000
emp3 7000000
emp4 4000000
;run;

data c;
merge a b;
by emp;
total+sal;
run;

output should be like below:

--emp--+---sal--+----total--+-

emp1 1000000 1000000
emp2 2000000 3000000
emp3 7000000 10000000
emp4 4000000 14000000

------------------------------------

Thanks and Regards,

varmal

[34reqrwe]

Proc SQL is not a good way to get a cumulative total . You already have the most elegant solution using data step -  why do you need to use Proc SQL?

[varmalh]

I understand you point but there must a simple or complex way of getting the same output..?

[34reqrwe]

The simple way is using data step . Yes it can be done using Proc SQL but it is not a good way to tackle the problem . Just like you wouldn't eat soup with a fork . Why do you want to user Proc SQL?

[ChrisNZ · Accepted solution]

SQL is not very good at processing rows in a given order. For this reason a data step is better suited as mentioned.