Change order of category in SGPANEL

[Melk]

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;

[ballardw]

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

[collinelliot · Accepted solution]

On the colaxis, change the order they are displayed:

REVERSE

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

[Melk]

Thanks this worked!