Data visualization with SAS programming

Change order of category in SGPANEL

Accepted Solution Solved
Reply
Contributor
Posts: 41
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
‎04-25-2017 12:46 PM
Super Contributor
Posts: 284

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: 10,251

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
‎04-25-2017 12:46 PM
Super Contributor
Posts: 284

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.

Contributor
Posts: 41

Re: Change order of category in SGPANEL

Thanks this worked!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 196 views
  • 1 like
  • 3 in conversation