Cumulative totals

[JamesNewcombe]

Hello

In SAS VA 7.3 I'm trying to make a particular kind of cumulative table, but I don't seem to be able to do it. I turn the table into a cross tab with Month and Development month, then I need to make the rows cumulative, as shown below. Can anyone do this?

Turn this table...				...Into this cumulative triangle
Month	Development Month	Cost			Development Month
May-16	1	100		Month	1	2	3	4
May-16	2	150		May-16	100	250	375	495
May-16	3	125		Jun-16	150	325	465
May-16	4	120		Jul-16	135	315
Jun-16	1	150		Aug-16	150
Jun-16	2	175
Jun-16	3	140
Jul-16	1	135
Jul-16	2	180
Aug-16	1	150

[ballardw]

I don't use VA so can't tell which menu items or buttons to push but that should be pretty simple with anything that generates a crosstab of categorical (or Class) variables Month and Developement Month and Sum or Max value of Cost. You may need to specify that missing values are displayed as blank.