DATA Step, Macro, Functions and more

proc SGPLOT vbox summary statistics (like proc boxplot)

Accepted Solution Solved
Reply
Contributor
Posts: 33
Accepted Solution

proc SGPLOT vbox summary statistics (like proc boxplot)

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.

 


Accepted Solutions
Solution
‎03-07-2016 10:07 AM
Super User
Posts: 10,044

Re: proc SGPLOT vbox summary statistics (like proc boxplot)

[ Edited ]
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;

 

download.png

View solution in original post


All Replies
Solution
‎03-07-2016 10:07 AM
Super User
Posts: 10,044

Re: proc SGPLOT vbox summary statistics (like proc boxplot)

[ Edited ]
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;

 

download.png

Contributor
Posts: 33

Re: proc SGPLOT vbox summary statistics (like proc boxplot)

Thank you!
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 1552 views
  • 1 like
  • 2 in conversation