Plots are not sorted (PROC GLM)

[Barkamih]

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 

[PaigeMiller]

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".

[Barkamih]

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 

[MichaelL_SAS]

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.