BookmarkSubscribeRSS Feed
Calcite | Level 5



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

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.



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 2 in conversation