Change order of categories in Legend for Plot of probabilities (Proc Logistic)

[SASnewbiee]

Hello,

I can't seem to get the right order in my legend. my variables are coded in order that I want it to show

0=<80

1=80-90

2=>90

and the reference category is <80 but this is the plot I get:

It still has the order:  80-90, <80 , >90

and I want <80, 80-90, >90

My code used: (I tried to mess with ODS graphics but I couldn't understand)

proc logistic data=sbb descending plots=effect;
class finalcat3(ref='<80%');
model score= ugpa finalcat3/rsq lackfit cl;
run;

[PaigeMiller]

---

@SASnewbiee wrote:

Hello,

I can't seem to get the right order in my legend. my variables are coded in order that I want it to show

0=<80

1=80-90

2=>90

and the reference category is <80 but this is the plot I get:

It still has the order:  80-90, <80 , >90

and I want <80, 80-90, >90

---

Character variables will have their values sorted alphabetically by default. That's what you are seeing. In general, you want to leave numeric variables as numeric variables, because numeric variables sort numerically (that's what you want) and then apply a custom format to them so they appear as 80-90, or as <80, or as >90.

[SASnewbiee]

Yes, without the format it was 0, 1, 2 in the order I want. But then I tried to format within the proc logistic step and have the same problem.

Is there no way to have that format, and in the order I need?

[PaigeMiller]

Show me your code.

[SASnewbiee]

data sbb; set sbb;
label finalcat3="Final Exam";
run;

proc format;
value fin 0="<80%"
1="80-90%"
2=">90%";
value sc 0=Failed
1=Passed;
run;

proc logistic data=sbb descending plots=effect;
class finalcat3(ref='0');
model score= ugpa finalcat3/rsq lackfit cl;

format finalcat3 fin. score sc.;
run;

[PaigeMiller · Accepted solution]

class finalcat3(ref='<80%' order=internal);

This forces SAS to use the internal order (0, 1, 2) when ordering the levels in the output.

[SASnewbiee]

This worked, thank you very much!