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; ... View more

Hello,  I am having trouble going from long to wide using Proc transpose. It seems like it should be really simple but I'm not getting it correct:   Trying to go from:   ID  grade 1  grade1 1 grade2 1 grade3 2 grade1 2 grade2 2 grade3 3 grade1 3 grade2 3 grade3     to:  ID    grade1 grade2 grade3  1      88          82          89      2      76          87          90        3      99          94          89         I tried    **proc transpose from long to wide; proc transpose data=long out=wide (drop=_NAME) prefix=grade; by ID; id grade1-grade3;   run; Proc print data=wide; title ' Transpose from Long to Wide'; run;   ... View more