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;
On the colaxis, change the order they are displayed:
specifies that the tick values are displayed in reverse (descending) order.
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
On the colaxis, change the order they are displayed:
specifies that the tick values are displayed in reverse (descending) order.
Thanks this worked!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.