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,
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Submit your idea!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.