Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Cumulative totals

Reply
Occasional Contributor
Posts: 11

Cumulative totals

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            
Super User
Posts: 11,134

Re: Cumulative totals

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.

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