topic how to count % in group in SAS VA cross table? in SAS Visual Analytics

how to count % in group in SAS VA cross table?

Pato485 — Fri, 13 Jan 2023 09:43:46 GMT

How to calculate % like this:

Need to calculate it in a groups, not from whole data. so it should look like this:

How to do it pls? Thanks

HunterT_SAS — Fri, 13 Jan 2023 14:32:48 GMT

You should be able to do this by right-clicking on the measure header and selecting Create and Add Calculation:

Then set Type as Percent of column subtotal:

Hopefully that gets what you want!