SGPANEL Group Legend Order

[mglogan]

Hello!

Is there a way to order the legend (for Actual Arm) in sgpanel sequentially? Thank you!

proc sgpanel data=final;
*styleattrs datasymbols=(circlefilled x trianglefilled) ;
 panelby reason;
 series x=dsstdy y=percent2 /group=actarmn tip=(subjid dsstdy percent) tiplabel=(auto 'study day') 
 																	 markers markerattrs=(symbol=circlefilled size=10) lineattrs = (thickness = 2);
 colaxis grid values=(1 to 240 by 20);
 rowaxis grid values=(0 to 10 by 1);
run ; 

Capture.PNG

[Reeza]

Is the variable actarmN a numeric or character variable and does it have a format applied?

[Reeza · Accepted solution]

What happens if you add GroupOrder=Ascending option to the Series statement?

[mglogan]

Oh thank you! the grouporder= option worked.

The value of actarmn is numeric, and I planned to apply a format to the numeric value.

[Reeza]

I was asking that to see if it had a format applied and for some reason was sorting according to the underlying value rather than displayed value. Glad that GroupOrder worked.