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;
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.
PROC GLM has option of
REF=FIRST | LAST
which you can set as global option for the whole class list.
Jason Xin
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.