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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Register now!
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.