cumulative sum of more than one variable

[LorenaPalacios]

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!

[novinosrin]

cumulative+volume;

run;

reset cumulative to zero when reading a new by group

[LorenaPalacios]

Thanks

[LorenaPalacios]

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;

[novinosrin]

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;

[LorenaPalacios]

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!

[novinosrin · Accepted solution]

Try

by descending Station 	descending equipment;

[LorenaPalacios]

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

[novinosrin]

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