topic Re: Change order of categories in Legend for Plot of probabilities (Proc Logistic) in SAS Programming

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

SASnewbiee — Tue, 07 Jul 2020 15:31:03 GMT

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;

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

PaigeMiller — Tue, 07 Jul 2020 15:34:57 GMT

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

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

SASnewbiee — Tue, 07 Jul 2020 15:45:31 GMT

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?

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

PaigeMiller — Tue, 07 Jul 2020 15:47:43 GMT

Show me your code.

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

SASnewbiee — Tue, 07 Jul 2020 16:17:11 GMT

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;

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

PaigeMiller — Tue, 07 Jul 2020 16:30:36 GMT

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

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

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

SASnewbiee — Tue, 07 Jul 2020 16:51:04 GMT

This worked, thank you very much!