topic Proc Sgplot, Vbox, Include frequencies in plot in Statistical Procedures

Proc Sgplot, Vbox, Include frequencies in plot

Tz — Thu, 28 Jan 2021 06:35:33 GMT

Dear all.

I created the plot in the attachement, using Vbox in SGPLOT.

I would like to include the frequencies for each point of NACCFDYSYear somewhere in the plot.

The XAXISTABLE statement cannot produce frequencies with box plots.

Any suggestions?

Thanks

Re: Proc Sgplot, Vbox, Include frequencies in plot

PeterClemmensen — Thu, 28 Jan 2021 09:51:24 GMT

Show us your code 🙂

Re: Proc Sgplot, Vbox, Include frequencies in plot

Tz — Thu, 28 Jan 2021 10:05:10 GMT

Code attached

Re: Proc Sgplot, Vbox, Include frequencies in plot

Ksharp — Thu, 28 Jan 2021 12:07:22 GMT

You want this ?

proc sql;
create table have as
select sex,status,weight,count(*) as count,max(weight)+.05*range(weight) as y
 from sashelp.heart
  group by sex,status;
quit;
data have ;
 set have;
 by sex status;
 if not first.status then call missing(count,y);
run;

proc sgplot data=have;
vbox weight/category=sex group=status groupdisplay=cluster connect=median;
scatter x=sex y=y/group=status markerchar=count groupdisplay=cluster labelstrip clusterwidth=0.7;
run;

Re: Proc Sgplot, Vbox, Include frequencies in plot

Tz — Sun, 31 Jan 2021 08:20:10 GMT

Thanks Ksharp