Accumulating Totals by 2 Variables

[XY7]

Hi, I am trying to accumulate the total amount by purpose for each bank in this data set, however, I am either only able to obtain the amount based on purpose or bank type itself. Could anyone kindly explain? Thank you.

Data:

My codes on the calculation: 

data work.purpose2;
	set work.purpose1;
	by purpose bank_to;
	retain cummulative_value;
	if first.purpose then cummulative_value=amount;
 	else cummulative_value=amount+cummulative_value;
	drop amount;
run; 

Results output:

The results are supposed to show something like this (By the bank type and purpose):

bank_to       purpose        cummulative_value

  AB             Leasing              $1234567

  AB             Insurance           $1234567

  AB            Household          $1234567

  GH            Insurance           $1234567

....

[PeterClemmensen]

And yoy want to do this in a data step? Or are you allowed to use a procedure like PROC SUMMARY?

[XY7]

Yes, I am allowed to do so.

[novinosrin · Accepted solution]

PROC MEANS DATA=have nway NOPRINT;
class bank_to purpose;
VAR amount;
OUTPUT OUT=want SUM=cumulative_value;
RUN; 

[XY7]

Thank you very much!