Data visualization with SAS programming

Change order of category in SGPANEL

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

Change order of category in SGPANEL

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;


Accepted Solutions
Solution
a month ago
Super Contributor
Posts: 259

Re: Change order of category in SGPANEL

On the colaxis, change the order they are displayed:

 

REVERSE

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

View solution in original post


All Replies
Grand Advisor
Posts: 9,713

Re: Change order of category in SGPANEL

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

Solution
a month ago
Super Contributor
Posts: 259

Re: Change order of category in SGPANEL

On the colaxis, change the order they are displayed:

 

REVERSE

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

Occasional Contributor
Posts: 10

Re: Change order of category in SGPANEL

Thanks this worked!

Post a Question
Discussion Stats
  • 3 replies
  • 100 views
  • 1 like
  • 3 in conversation