topic Re: Change order of category in SGPANEL in Graphics Programming

Change order of category in SGPANEL

Melk — Mon, 24 Apr 2017 22:40:23 GMT

I am using PROC SGPANEL with a category of time, which is binary 1 (label=pre) or 2 (label=post) and while I plot the data Post comes before Pre in each of my panels. How can I switch this so that Pre comes before Post?

SAS code:

proc sgpanel data=long;
   panelby group / layout=columnlattice onepanel noborder colheaderpos=bottom novarname;
   vbox score / category=time ;
   colaxis display=(nolabel);
   rowaxis grid;
run;

Re: Change order of category in SGPANEL

ballardw — Mon, 24 Apr 2017 23:04:25 GMT

If your Time variable has a format it may be using that to group the data by default.

Sometimes providing a sorted data set to the procedure with the variable of interest in the order works.

I would try

proc sort data =long;

by descending time;

run;

or possibly

proc sort data =long;

by group descending time;

run

If that doesn't work

Re: Change order of category in SGPANEL

collinelliot — Mon, 24 Apr 2017 23:05:15 GMT

On the colaxis, change the order they are displayed:

REVERSE

specifies that the tick values are displayed in reverse (descending) order.

Re: Change order of category in SGPANEL

Melk — Tue, 25 Apr 2017 16:46:26 GMT

Thanks this worked!