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!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.