topic Accumulating Totals by 2 Variables in New SAS User

Accumulating Totals by 2 Variables

XY7 — Sun, 13 Jan 2019 11:25:12 GMT

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

....

Re: Accumulating Totals by 2 Variables

PeterClemmensen — Sun, 13 Jan 2019 12:16:23 GMT

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

Re: Accumulating Totals by 2 Variables

XY7 — Sun, 13 Jan 2019 12:53:25 GMT

Yes, I am allowed to do so.

Re: Accumulating Totals by 2 Variables

novinosrin — Sun, 13 Jan 2019 16:27:05 GMT

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

Re: Accumulating Totals by 2 Variables

XY7 — Mon, 14 Jan 2019 02:08:14 GMT

Thank you very much!