BookmarkSubscribeRSS Feed
JamesNewcombe
Calcite | Level 5

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            
1 REPLY 1
ballardw
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.

sas-innovate-2024.png

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!

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
  • 938 views
  • 0 likes
  • 2 in conversation