Is there a way that proc sgplot (vbox option) can generate the summary statistics for the boxplot like proc boxplot does? I want to show all the values: min, max, median, mean, and n for each category on the x axis.
Can you point me to some sample code? I am sure I am not the first to ask this question.
Thanks.
data have;
set sashelp.class;
run;
proc means data=have nway noprint;
class sex;
var weight;
output out=stat min= max= median= mean= n=/autoname;
run;
data want;
set have stat;
run;
proc sgplot data=want;
label weight_n='N' weight_min='MIN' weight_max='MAX'
weight_median='MEDIAN' weight_mean='MAEAN';
vbox weight/category=sex group=sex;
xaxistable weight_n weight_min weight_max weight_median weight_mean
/ x=sex colorgroup=sex location=inside;
run;
data have;
set sashelp.class;
run;
proc means data=have nway noprint;
class sex;
var weight;
output out=stat min= max= median= mean= n=/autoname;
run;
data want;
set have stat;
run;
proc sgplot data=want;
label weight_n='N' weight_min='MIN' weight_max='MAX'
weight_median='MEDIAN' weight_mean='MAEAN';
vbox weight/category=sex group=sex;
xaxistable weight_n weight_min weight_max weight_median weight_mean
/ x=sex colorgroup=sex location=inside;
run;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.