proc glm class variables descending

[peppapig]

In proc glm, how to control all the class variables descending at the same time?

x1, x2, x3 class variables with grouping values as 1,2,3 , using the code below, I only had x1 in descending, not x2. x3 in the output .

PROC SORT DATA = abc;

BY DESCENDING x1 DESCENDING x2 DESCENDING x3;   

RUN;

PROC GLM DATA = abc  ORDER = DATA ;

CLASS x1 x2 x3 ;

MODEL  y = x1 x2 x3   /solution ss3  ; 

RUN;

[Reeza]

Not sure if this would work but usually in a class statement you should specify the parameterization, param='ref' and there's an option for descending. But I also have vague recollections of GLM being different.

At any rate, I'd be looking at options within GLM or GLMSELECT rather than via the SORT.

SAS/STAT(R) 9.2 User's Guide, Second Edition

[JasonXin]

PROC GLM has option of

REF=FIRST | LAST

which you can set as global option for the whole class list.

Jason Xin