topic Re: cumulative sum of more than one variable in SAS Programming

cumulative sum of more than one variable

LorenaPalacios — Thu, 04 Oct 2018 17:35:18 GMT

Hi!

Excuse me, but my English is not very good
I hope you understand the question

I have the following data table:

Table_A

Station	equipment	volume
ST_a	eq_a_1	10
ST_a	eq_a_2	9
ST_a	eq_a_3	5
ST_b	eq_b_1	10
ST_b	eq_b_2	3
ST_c	eq_c_1	15
ST_c	eq_c_2	14

I need to accumulate the value of the Volume column and keep all the records so that the result is shown as the following table

Table_B
Station	equipment	volume	cumulative
ST_a	eq_a_1	10	10
ST_a	eq_a_2	9	19
ST_a	eq_a_3	5	24
ST_b	eq_b_1	10	10
ST_b	eq_b_2	3	13
ST_c	eq_c_1	15	15
ST_c	eq_c_2	14	29

I really need to solve this problem.
Thank you very much!

Re: cumulative sum of more than one variable

novinosrin — Thu, 04 Oct 2018 17:37:54 GMT

cumulative+volume;

run;

reset cumulative to zero when reading a new by group

Re: cumulative sum of more than one variable

LorenaPalacios — Thu, 04 Oct 2018 17:46:23 GMT

Thanks

Re: cumulative sum of more than one variable

LorenaPalacios — Thu, 04 Oct 2018 17:50:04 GMT

I tried with the following sentence but it leaves me a record for each station and I need only to accumulate in each station cut the value of the equipment

data new;
   set pru;
   by sistema_nombre ;

   if first.sistema_nombre then total=0;

   total + volumen;
   if last.sistema_nombre then output;
   drop volumen;
run;

Re: cumulative sum of more than one variable

novinosrin — Thu, 04 Oct 2018 17:54:31 GMT

data have;
input Station $	equipment $	volume;
cards;
ST_a	eq_a_1	10
ST_a	eq_a_2	9
ST_a	eq_a_3	5
ST_b	eq_b_1	10
ST_b	eq_b_2	3
ST_c	eq_c_1	15
ST_c	eq_c_2	14
;

data want;
set have;
by Station 	equipment;
if first.Station then cumu=volume;
else cumu+volume;
/*if last.Station;*/
run;

Re: cumulative sum of more than one variable

LorenaPalacios — Thu, 04 Oct 2018 18:19:09 GMT

I really need to sort it by station and volume but volumen . When I enter the sentence "by station volume" it indicates the error "BY variables are not properly sorted on data".

Table_a is sorted descending by station and volume. Any suggestions? thank you very much!

Re: cumulative sum of more than one variable

novinosrin — Thu, 04 Oct 2018 18:22:50 GMT

Try

by descending Station 	descending equipment;

Re: cumulative sum of more than one variable

LorenaPalacios — Thu, 04 Oct 2018 18:28:48 GMT

Thank you very much!!!!! it worked perfectly!!

Re: cumulative sum of more than one variable

novinosrin — Thu, 04 Oct 2018 18:30:10 GMT

Welcome to the SAS forum and I hope you have fun. Take care!