Help using Base SAS procedures

proc glm class variables descending

Reply
Contributor
Posts: 42

proc glm class variables descending

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;

Super User
Posts: 19,789

Re: proc glm class variables descending

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

SAS Employee
Posts: 122

Re: proc glm class variables descending

PROC GLM has option of

REF=FIRST | LAST

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

Jason Xin

Ask a Question
Discussion stats
  • 2 replies
  • 239 views
  • 0 likes
  • 3 in conversation