Dear all,
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?
Best wishes
Eva
Is that it?
A code example of what you attempted would be helpful.
proc gchart data=sashelp.cars (where=(make in ("Audi","BMW")));
vbar make / freq = enginesize
group = type
subgroup = cylinders
type=percent
g100 /* effect: one group=100% , but I need one bar=100% */
;
run;
quit;
Is that it?
Yes! I always searched for a vbar Option... But a proc freq before the proc gchart is best 🙂
Thanx for your help data_null_.
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;
run;
proc gchart data=work.cars (where=(make in ("Audi","BMW")));
vbar make / sumvar=Pct_row
group = type
subgroup = cylinders
type=sum
;
label pct_row='Percent of Engine Cylinders' ;
run;
quit;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: