BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
edaynes
Fluorite | Level 6

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?

1 ACCEPTED SOLUTION

Accepted Solutions
DJongman
Obsidian | Level 7

Yes this is possible. You need to add a new calculated item.

Untitled.png

 

You can find the option on the tab 'Data'

 

Untitled2.png

 

Untitled3.png

 

Select option new calculated item

 

 

View solution in original post

2 REPLIES 2
DJongman
Obsidian | Level 7

Yes this is possible. You need to add a new calculated item.

Untitled.png

 

You can find the option on the tab 'Data'

 

Untitled2.png

 

Untitled3.png

 

Select option new calculated item

 

 

edaynes
Fluorite | Level 6

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

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 2 replies
  • 2872 views
  • 0 likes
  • 2 in conversation