Help using Base SAS procedures

How to Create a Cumulative Var in Proc SQL

Reply
Occasional Contributor
Posts: 5

How to Create a Cumulative Var in Proc SQL

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,

Contributor
Posts: 25

Re: How to Create a Cumulative Var in Proc SQL

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;

Attachment
Ask a Question
Discussion stats
  • 1 reply
  • 5475 views
  • 0 likes
  • 2 in conversation