SAS Visual Analytics : Add Column Percentage in CrossTab

This article explains how to add column percentage in crosstab in SAS Visual Analytics.

Task
Suppose you have created a cross tab - variable1 by variable2. You want to show both frequency and count % of column total. In SAS Visual Analytics, there is no direct way to show percentage of column total in crosstab.
SAS VA : Crosstab
Solution

1. Add any measure variable that has no missing values and change aggregate of the variable to count.
Add a measure variable

2. Place your cursor to the column you have added and right click on it
Add aggregated measure

3. Select "Create and Add" and click on Percent of Subtotals.

Add caption
4. Check "Percent of Column total.

5. Remove the added column and keep the percentage column.
Final CrossTab Table


About Author:

Deepanshu founded ListenData with a simple objective - Make analytics easy to understand and follow. He has close to 7 years of experience in data science and predictive modeling. During his tenure, he has worked with global clients in various domains like retail and commercial banking, Telecom, HR and Automotive.


While I love having friends who agree, I only learn from those who don't.

Let's Get Connected: Email | LinkedIn

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

1 Response to "SAS Visual Analytics : Add Column Percentage in CrossTab"

  1. Thank you for sharing this article on how to add column percentage in crosstab in SAS Visual Analytics. You have actually saved us, beginners and gave solutions to some problems that we are having when using SAS Visual Analytics. It's great to find help and solutions to every problems we encounter and I am so glad I also found a website that I can rely on and who can help me write my essay for our school project.

    ReplyDelete

Next → ← Prev