07-15-2016 06:37 AM
Is there a way to add row percentages in a cross tab or even a list table in SAS VA?
For example, I have 3 columns, A,B,C and want to then get a total column of A+B+C.
I then want to have a column that gives me the percentage of A out of the total column.
Also, is it possible to do column A / column B to give me that precentage?
In Excel it would be '=A1/B1' in the new column to give me the percentage. Is this doable in SAS VA?
07-15-2016 08:41 AM
That worked thanks.
When the calculated item has been put into the list or crosstab I found that you needed to select 'average' as the aggregation for it to do the correct calculation.
When I created it as a new aggregated measure instead then it automatically set it as the correct calculation.
I had to remember to change the format to percentage too.