How to Create a Cumulative Var in Proc SQL

[thegrad]

ativeHey All,

I've got a proc sql statement where i'm selected a report_date and amount, can anyone tell me how to also include a cumulative version of this?

Thanks,

[arnouxvr]

Take a look at the code below.

I am assuming that date will be unique otherwise replace it with a unique row identifier.

data temp;

  input date : date9. amt;

  format date date9.;

  datalines;

1JAN2013 45

2JAN2013 31

3JAN2013 65

  ;

run;

proc sql;

  select a.date, a.amt, (select SUM(b.amt) from temp as b where b.date <= a.date) as running_total

   from temp as a

  order by a.date;

quit;