I have a proc gchart with vbar, group and subgroup. The type is percent. If I don't add anything then 100% is the whole chart. If I add the option g100 then 100% is within one group. Now, my customer wants 100% per bar in this chart. Is that possible?
Is that it?
Is that it?
I'm not sure quite what you want but if each bar should total to 100 across the cylinder count you may need to process your data a bit before taking it to GCHART.
Maybe this is what you are looking for?
proc freq data=sashelp.cars (where=(make in ("Audi","BMW"))) noprint;
table make* type *cylinders/ outpct out=work.cars;
proc gchart data=work.cars (where=(make in ("Audi","BMW")));
vbar make / sumvar=Pct_row
group = type
subgroup = cylinders
label pct_row='Percent of Engine Cylinders' ;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.