topic Re: Reorder lsmeans columns in GLM in SAS Programming

Reorder lsmeans columns in GLM

tebert — Mon, 20 Sep 2021 21:17:52 GMT

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.

Re: Reorder lsmeans columns in GLM

PaigeMiller — Mon, 20 Sep 2021 21:22:41 GMT

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

Then run PROC GLM again

Re: Reorder lsmeans columns in GLM

Reeza — Mon, 20 Sep 2021 21:26:48 GMT

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.

Re: Reorder lsmeans columns in GLM

tebert — Mon, 20 Sep 2021 23:13:53 GMT

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.

Re: Reorder lsmeans columns in GLM

Reeza — Mon, 20 Sep 2021 23:21:06 GMT

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.

Re: Reorder lsmeans columns in GLM

tebert — Mon, 20 Sep 2021 23:25:42 GMT

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.