topic Re: proc sgplot to draw bar plots, with user defined order of categories? in Graphics Programming

proc sgplot to draw bar plots, with user defined order of categories?

fengyuwuzu — Tue, 26 Apr 2016 17:47:58 GMT

I want to order the bars in the bar chart, based on my own order, not by the default order. Is there a way to do it?

Thanks

Re: proc sgplot to draw bar plots, with user defined order of categories?

Rick_SAS — Tue, 26 Apr 2016 18:51:02 GMT

Yes. Sort the data set so that the categories appear i nthe order you want. Then use the XAXIS DISCRETEORDER=DATA option to tell the plot to use the order of the categories as they appear in the data set:

proc sgplot data=sashelp.cars;

vbar Type;

xaxis discreteorder=data;

run;

For more elaborate examples, see the article "Order variables by values of a statistic"

Re: proc sgplot to draw bar plots, with user defined order of categories?

BrunoMueller — Tue, 26 Apr 2016 18:56:51 GMT

Hi have a look at the VALUES= option of the XAXIS statement.

Find below a code sample:

proc sgplot data=sashelp.cars tmplout="c:/temp/sgplot.sas";
  vbar type / response=Horsepower stat=mean;
  xaxis values=("SUV" "Hybrid" "Wagon" "Truck");
run;

Bruno

Re: proc sgplot to draw bar plots, with user defined order of categories?

fengyuwuzu — Tue, 26 Apr 2016 19:07:24 GMT

So great!!! Thank you!