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!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.