topic Re: proc glm class variables descending in SAS Procedures

proc glm class variables descending

peppapig — Mon, 07 Jul 2014 23:29:11 GMT

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;

Re: proc glm class variables descending

Reeza — Tue, 08 Jul 2014 00:53:59 GMT

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

Re: proc glm class variables descending

JasonXin — Tue, 08 Jul 2014 15:54:24 GMT

PROC GLM has option of

REF=FIRST | LAST

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

Jason Xin