Calculating running percent in a crosstab

[crawfe]

Hello. My company uses SAS VA 7.4. I am trying to create a crosstab showing cumulative (running) percent of updates by M/Y for various Update Numbers. I was able to use a combination of the Period functions to get a running number of updates using the relative period sum from all last year plus the cum period of the current year (so far so good).

But to get cumulative percent I need to divide by the total number of updates to be performed for a particular update number. My crosstab table wants to separate the Count of the Update Number occurrences by the M/Y also. 

How am I able to use the pure total # of Updates but break down the updates performed by M/Y? (I hope that is clear enough). 

Desired table outcome (just the cum % is ok). Thanks! (20 is the known total tbd by end of 2019)

                                                                         # Updates Done In:

Update Num                                          1/2018          2/2018         3/2018............4/2019

UP1 done (cum cmplt;cum %)             2 (2;10%)      0 (0;10%)    1 (3;15%)        5 (8;40%)     

[crawfe]

.... I implied but didn't say that "20" is a total number that varies by Update Number (not a constant). Thanks.

[crawfe]

The answer could be that this is better done in the original Table? How would you approach that?

[Sam_SAS]

Hello,

For what it's worth, this is very easy to do in VA 8.3. But you don't have 8.3.

I'm not sure if there is a workaround within VA 7.4, but you can create the running percentage in the original table.

This thread https://communities.sas.com/t5/SAS-Procedures/cumulative-percent/td-p/216368 should be helpful there.

Let us know if that helps.

Sam

[crawfe]

Thanks. Yes I saw that 8.3 might have the functions I need. I came close with a couple of approaches but I think I have tortured SAS VA 7.4 functions enough for now. I will try to adapt the original data and hope that we upgrade soon! Thanks!