Reorder lsmeans columns in GLM

[tebert]

I used the following code, but I want the columns in a different order.

ods graphics on;
proc glm plots=diagnostics;
class trt;
model pct_Juice	Brix	Acid	Ratio	BrimA =  trt;
lsmeans trt/adjust=tukey alpha=0.05 lines;
run;

Here is the default graph, but the columns are in alphabetical order. I want "Control" as the first column on the left.

[PaigeMiller · Accepted solution]

In your SAS data set, add a space in front of 'Control' so it is now ' Control'

Then run PROC GLM again

[Reeza]

Generally you have two options:

1. Make the graph using the output and SGPLOT

2. Map numbers to the values you'd like ordering them in the order you'd like to see, ie Control = 0, Black = 1, Blue = 2 and use Labels to control the displayed value. Then once they're sorted by default they'll show the labels in the order desired.

---

@tebert wrote:

I used the following code, but I want the columns in a different order.

ods graphics on;
proc glm plots=diagnostics;
class trt;
model pct_Juice	Brix	Acid	Ratio	BrimA =  trt;
lsmeans trt/adjust=tukey alpha=0.05 lines;
run;

Here is the default graph, but the columns are in alphabetical order. I want "Control" as the first column on the left.

---

[tebert]

PaigeMiller gave a solution that gets me through today. I have not used SGPlot or mapping so it will take more effort to see how well I gan get these suggestions to work. This answer will be a more general solution.

[Reeza]

It'll only really work for Control, if you want to control the order of the other categories, ie put them descending or something else, this solution won't work. This is a very specific solution.

[tebert]

It will work to put any one column first. I could put a space in front of "Pink" to move that to the front. I suspect I could also order others by adding multiple spaces. However, with many spaces there will be other issues so adding spaces is not a general solution. It only gets me through today.