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

[fengyuwuzu]

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

[Rick_SAS]

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"

[BrunoMueller · Accepted solution]

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

[fengyuwuzu]

So great!!! Thank you!