topic Re: Plots are not sorted (PROC GLM) in Statistical Procedures

Plots are not sorted (PROC GLM)

Barkamih — Mon, 09 Dec 2019 13:29:11 GMT

Hi all,

I'm using this code but the plots are not sorted properly as I have them in the original data.

for example, the month of April came before January on the graph.

So, in this case, how I could solve this out?

proc glm data = have;
  class month;
  model value = month-;
  run; quit;

Thanks for your help

Regards

Ibrahim

Re: Plots are not sorted (PROC GLM)

PaigeMiller — Mon, 09 Dec 2019 14:29:02 GMT

April comes before January because the values on the plots are being sorted to have the levels in alphabetical order.

How is April identified in your data set HAVE? Is it the number 4, or is it the word "APRIL"? I suggest you might want to use numbers or actual SAS date values instead of the word "APRIL".

Re: Plots are not sorted (PROC GLM)

Barkamih — Mon, 09 Dec 2019 14:46:15 GMT

Greate, I already recognized this issue a few minutes ago and I changed them to numbers.

now, everything going well

Thanks for your response

barkamih

Re: Plots are not sorted (PROC GLM)

MichaelL_SAS — Mon, 09 Dec 2019 14:52:59 GMT

You can use the ORDER= option in the PROC GLM statement to control how the levels of classification variables are ordered. The default ordering is by the formatted values, or internal values if no formats are provided. In this case that does put April before January. If your data are already sorted in the order of the variable Month that you want used, you can specify ORDER=DATA, in which case the variable levels are ordered how their appearance in the input data set.