topic Re: Calculating running percent in a crosstab in SAS Visual Analytics

Calculating running percent in a crosstab

crawfe — Sun, 07 Apr 2019 23:41:25 GMT

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%)

Re: Calculating running percent in a crosstab

crawfe — Mon, 08 Apr 2019 11:49:26 GMT

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

Re: Calculating running percent in a crosstab

crawfe — Mon, 08 Apr 2019 15:12:30 GMT

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

Re: Calculating running percent in a crosstab

Sam_SAS — Tue, 09 Apr 2019 14:00:12 GMT

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

Re: Calculating running percent in a crosstab

crawfe — Tue, 09 Apr 2019 15:15:15 GMT

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!