proc SGplot. X axis out of order.

mrdlau — Sun, 17 Jun 2018 19:05:45 GMT

I'm generating a simple vbar chart with the Y axis being counts, and x axis being ranges that I created as text (i.e "0 to 5%", "5.01 to 10%" etc).

When I plot the chart, my X axis is out of order. it'll go "0 to 5%", "10 to 15%", "5 to 10%". How do I set the order in this scenario where the x axis is text?



Proc sgplot data=gridwork.data;
vbar dist/ response=counts;
xaxis label=distribution;
yaxis label='counts;

run;
quit;

Re: proc SGplot. X axis out of order.

Reeza — Sun, 17 Jun 2018 19:16:54 GMT

Easiest method is to not use characters as your X axis. Instead use numeric values and then use a format to have them displayed for presentation.

Because its a categorical variable you can also use the VALUES = option on the XAXIS statement to have the order you want.

http://documentation.sas.com/?docsetId=grstatproc&docsetTarget=p07m2vpyq75fgan14m6g5pphnwlr.htm&docsetVersion=9.4&locale=en#n09f4ln7jq8gkan1w2nhlkzjcrqz

proc sgplot data=sashelp.cars;
xaxis values=("GMC" "Honda" "Hyundai") 
   offsetmin=0.2 offsetmax=0.2;
scatter x=make y=mpg_city; 
run;

PS. please take some time to go through your historical posts and mark them as answered/solved with the correct response tagged.

@mrdlau wrote:

I'm generating a simple vbar chart with the Y axis being counts, and x axis being ranges that I created as text (i.e "0 to 5%", "5.01 to 10%" etc).

When I plot the chart, my X axis is out of order. it'll go "0 to 5%", "10 to 15%", "5 to 10%". How do I set the order in this scenario where the x axis is text?
Proc sgplot data=gridwork.data;
vbar dist/ response=counts;
xaxis label=distribution;
yaxis label='counts;

run;
quit;

topic proc SGplot. X axis out of order. in SAS Programming

proc SGplot. X axis out of order.

Re: proc SGplot. X axis out of order.