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!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.