Cumulative totals

JamesNewcombe — Tue, 20 Sep 2016 13:26:30 GMT

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

Re: Cumulative totals

ballardw — Tue, 20 Sep 2016 16:22:28 GMT

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.

topic Re: Cumulative totals in SAS Visual Analytics

Cumulative totals

Re: Cumulative totals