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
View solution in original post
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.
Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.
Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
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.