topic Re: Reordering Char group/category on with Proc GPLOT VBOX in SAS Procedures

Reordering Char group/category on with Proc GPLOT VBOX

jackice — Fri, 04 Nov 2016 15:53:11 GMT

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?

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

ballardw — Fri, 04 Nov 2016 17:04:19 GMT

Possibly

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

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

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

jackice — Fri, 04 Nov 2016 18:18:50 GMT

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???

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

ballardw — Fri, 04 Nov 2016 20:11:56 GMT

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-data-AKA-generate/ta-p/258712 has instructions on created data step text code that can be pasted here to recreate you data set.

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

jackice — Thu, 10 Nov 2016 14:05:22 GMT

I have attached a csv last week in this forum have you seen it?