Hi
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?
Yes this is possible. You need to add a new calculated item.
You can find the option on the tab 'Data'
Select option new calculated item
Yes this is possible. You need to add a new calculated item.
You can find the option on the tab 'Data'
Select option new calculated item
Hi
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.
Thanks
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.