Help using Base SAS procedures

Reordering Char group/category on with Proc GPLOT VBOX

Reply
Contributor
Posts: 20

Reordering Char group/category on with Proc GPLOT VBOX

I got this box plot created with pre proc sor data:

 

proc sgplot data=weight;
VBOX weightgain /category=orientation group=box;
run;

 

Category=orientation, sorted by Proc Sort alphabetically is East, North, South West and shows as is on VBOX Xaxis 

 

Is there an easy statement / options in Proc GPLOT VBOX to re-order my char category as West, East, South, North on Xaxis?  without involving creating another data set? 

Super User
Posts: 11,343

Re: Reordering Char group/category on with Proc GPLOT VBOX

 

 

Possibly

xaxis values=('West' 'East' 'South' 'North' );

 

The values have to be as in the actual dataset for case.

Contributor
Posts: 20

Re: Reordering Char group/category on with Proc GPLOT VBOX

Thanks! work like a charm to reorder the char on taxis but if I code it as below it doesn’t pull out the box plot anymore, it does a plot with an empty plan white square …

proc sgplot data=weight;
VBOX weightgain /category=box group=orientation;
xaxis values=('West' 'East' 'South' 'North' );
run;

getting closer but not quite yet???

Super User
Posts: 11,343

Re: Reordering Char group/category on with Proc GPLOT VBOX

Since graphs are data dependent, sometimes in funny ways it is hard to diagnose without data. Can you post your data? https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... has instructions on created data step text code that can be pasted here to recreate you data set.

Contributor
Posts: 20

Re: Reordering Char group/category on with Proc GPLOT VBOX

I have attached a csv last week in this forum have you seen it?
Ask a Question
Discussion stats
  • 4 replies
  • 170 views
  • 0 likes
  • 2 in conversation