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

We have a number of columns detailing certain characteristics of our clients and I need to see how the proportions of these groups change over time. Using the "percent of total" option in VA gives the percent of each group across all years, but this needs to be subgrouped into each year.

 

 I know  I can put indicator columns into the data, but there are up to 15 different characteristics (and hence columns) , with up to 10 levels in each - this equates to a lot of indicator columns (and we quite a number of different tables we need to do this in). The "Percent of SubTotals" option works in this regard in a crosstab, but not in a chart (e.g. bar or line chart). Is there an alternative way of doing this directly within VA?

 

For Example (dummy data - yes, I'm in Australia):

 

 

Yearstate
2010nsw
2010qld
2010qld
2011qld
2011nsw
2011nsw
2012qld
2012nsw
2012nsw
2012nsw

 

 

Currently, when charted using "Percent of Total", we will get the follwoing results (on a chart though) because it calculates the percent of OVERALL total, rather than subgrouping across the Year AND State:

 

2010nsw10%
 qld20%
2011nsw20%
 qld10%
2012nsw30%
 qld10%

 

What I need (on a chart) is:

 

2010nsw33%
 qld66%
2011nsw66%
 qld33%
2012nsw75%
 qld25%

 

I have made a crosstab and created a "Percent of SubTotals", but this measure is not allowed a chart within VA atm, and it won't correctly split across the Year as category and State as group (or vice-versa).

 

Hope this makes sense.

 

We are on SAS Visual Analytics designer version 7.1

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
MichelleHomes
Meteorite | Level 14

What kind of bar chart are you trying to do? If it is a stacked bar chart you might find the "normalize groups to 100%" option useful as described at https://communities.sas.com/t5/SAS-Visual-Analytics/100-Stacked-Bar-Charts/m-p/153329#M602

 

Kind Regards,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com

View solution in original post

2 REPLIES 2
MichelleHomes
Meteorite | Level 14

What kind of bar chart are you trying to do? If it is a stacked bar chart you might find the "normalize groups to 100%" option useful as described at https://communities.sas.com/t5/SAS-Visual-Analytics/100-Stacked-Bar-Charts/m-p/153329#M602

 

Kind Regards,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
mark1
Calcite | Level 5

Thanks for the quick reply Michelle.

 

To be honest, I forgot about the normalise groups, and while this works, when the number of levels increases, it does make it a little more difficult to see trends over time. Ultimately I guess I'd like to see the same thing but in a line chart.

 

I think it will be a matter of indicators for at least some of the variables, as some of the proportions are quite low, and these are obviously the ones we are most interested in. With stacked barcharts or line charts, these tend to get lost. It may just be a matter of "focus" and finetuning where and what we want to look at.

 

Thanks again

sas-innovate-2024.png

📢

ANNOUNCEMENT

The early bird rate has been extended! Register by March 18 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. 

 

Register now!

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
  • 3134 views
  • 2 likes
  • 2 in conversation