topic Re: dot plot with SGPLOT in Graphics Programming

dot plot with SGPLOT

Jaime — Wed, 21 Jul 2010 15:52:43 GMT

Is there a way to sort by record count when using a dot plot.
It defaults to sorting by category var name.

Re: dot plot with SGPLOT

GraphGuy — Wed, 21 Jul 2010 16:42:16 GMT

Elaborate on what "dot plot" you're using?...
(a 'proc gchart' scatter plot? something with 'proc sgplot'? other?)

Re: dot plot with SGPLOT

DanH_sas — Wed, 21 Jul 2010 18:25:13 GMT

For the SAS 9.2 release, we do not have a "sort by response" option for dot plots. However, you can work around this by presummarizing your data, sorting it by the response value, and plotting it in sgplot using a a scatter plot to simulate a dot plot by using options like the following:

proc sgplot data=sorted;
yaxis grid;
scatter x=freqcount y=category / markerattrs=(symbol=circlefilled);
run;

Let me know if this works for you.

Thanks!
Dan

Re: dot plot with SGPLOT

Jaime — Wed, 21 Jul 2010 20:03:23 GMT

I am using
proc sgplot data=Current_Pipeline_ByName;
dot Name/ response=Recs markerattrs=(symbol=circlefilled color=cxA6D96A size=12) NOSTATLABEL ;
yaxis display=(nolabel);
xaxis display=(nolabel);
run;

I did sort the data with the order i needed. But the proc sorts on its own.

Re: dot plot with SGPLOT

Jaime — Wed, 21 Jul 2010 20:05:22 GMT

Oh. I see u are using scatter.
That worked. Thanks