I want to do a data visualization for a data set, including variables: age, gender, sub_department and profit. I tried so many times using boxplot, bar_char and even facet graph, but all method doesn't work. My goal is: how does the profit distribute among different sub_department for each combination of age and gender(like group 20-29F, 20-29M). The question is kind of tricky, because I want to analyze those 4 variables in one graph. Could you please help me solve this problem? The following is the data file. Thanks so much
you could also try grouping the bars (e.g. by gender) along with lattice (either columns or rows) to further compress the information. Similar what @PetriRoine showed - just with additional stacked grouped bars. So something like the following:
Hope this helps. Falko
Hello @Jianan_luna
Both, @FalkoSchulz and I use the the Bar chart as basis. Look at Falco's image how he applied the roles - you can see them on the right side of his image. He used Gender in Group role. I used Gender in Lattice rows role.
Best regards,
Petri
Thanks so much Sir, I got it, but the sample size is too big, and the age_range is so crowded, so it cannot show the whole range. Is there any way can make the x-axis much longer? or separate the graph to two part? Thanks so much!
Well rendering depends on the cardinality of your data items. You can play around with lattice rows vs columns and also related group role assignments. Lattice rows may work better as you would provide more horizontal room for each group segment. See what works best.
In the end - the overall size of the visualization decides how much real estate is available for rendering. The graph automatically removes things like labels, tick values or legends if there isn't enough room for rendering. You can try 'maximizing' (top right menu), opening view mode or increasing report size to provide more room if required.
Hope this helps. Falko
@Jianan_luna, one thing that you could maybe do is to offer report viewers possibility to narrow down uninteresting sub_departments. F.ex. add a List control object and assign sub_department to it. Then create an action from the List to Bar chart.
Best regards,
Petri
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.