topic Re: Display histogram and descriptive stats ( mean N ) with proc Sgplot in Graphics Programming

Display histogram and descriptive stats ( mean N ) with proc Sgplot

AmitKB — Wed, 23 Sep 2009 16:53:30 GMT

Hi All,
I want to generate a histogram with descriptive stats ( mean, N, # missing etc) using proc sgplot.
This will be similiar to the inset statement in proc univariate.

Thanks,

Amit

Re: Display histogram and descriptive stats ( mean N ) with proc Sgplot

DanH_sas — Wed, 23 Sep 2009 17:29:04 GMT

The descriptive statistics are not automatically available to you in SGPLOT; however, if you know the values, you can add them to the graph using the INSET statement in SGPLOT.

Thanks!

Re: Display histogram and descriptive stats ( mean N ) with proc Sgplot

AmitKB — Wed, 23 Sep 2009 17:35:46 GMT

Hi Dan,
Thanks a lot. Can I use macro variables to output the descriptive statistics.
Can you show me a dummy example where I get say mean from proc means and display it with the histogram.

Thanks a lot for all your help.

Regards,

Amit

Re: Display histogram and descriptive stats ( mean N ) with proc Sgplot

DanH_sas — Wed, 23 Sep 2009 19:19:05 GMT

Here you go:

proc means data=sashelp.class noprint;
class age sex;
var weight;
output out=meanval mean=;
ways 1;
run;

data _null_;
set meanval;
if ((age eq .) and (sex="F")) then
call symput("FMEAN", put(weight, best6.));
if ((age eq .) and (sex="M")) then
call symput("MMEAN", put(weight, best6.));
run;

proc sgplot data=sashelp.class;
vbar age / response=weight stat=mean;
inset ("Female"="&FMEAN" "Male"="&MMEAN") / border title="Avg. Weight by Gender";
run;

Re: Display histogram and descriptive stats ( mean N ) with proc Sgplot

AmitKB — Wed, 23 Sep 2009 20:04:42 GMT

Hi Dan,
Thanks a lot.

Regards,

Amit