Often you might want to perform postselection analysis by using other SAS procedures. To facilitate this, PROC GLMSELECT saves the list of selected effects in a macro variable. This list does not explicitly include the intercept so that you can use it in the MODEL statement of other SAS/STAT regression procedures.
The following table describes the macro variables that PROC GLMSELECT creates. Note that when BY processing is used, one macro variable, indexed by the BY group number, is created for each BY group.
Macro Variable |
Description |
---|---|
No BY processing |
|
|
Selected model |
BY processing |
|
|
Number of BY groups |
|
Selected model for BY group 1 |
|
Selected model for BY group 2 |
… |
You can use the macro variable _GLSIND
as a synonym for _GLSIND1
. If you do not use BY processing, _GLSNUMBYS
is still defined and has the value 1.
To aid in associating indexed macro variables with the appropriate observations when BY processing is used, PROC GLMSELECT
creates a variable _BY_
in the output data set specified in an OUTPUT statement (see the section OUTPUT Statement) that tags observations with an index that matches the index of the appropriate macro variable.
The following statements create a data set with two BY groups and run PROC GLMSELECT to select a model for each BY group.
data one(drop=i j); array x{5} x1-x5; do i=1 to 1000; classVar = mod(i,4)+1; do j=1 to 5; x{j} = ranuni(1); end; if i<400 then do; byVar = 'group 1'; y = 3*classVar+7*x2+5*x2*x5+rannor(1); end; else do; byVar = 'group 2'; y = 2*classVar+x5+rannor(1); end; output; end; run;
proc glmselect data=one; by byVar; class classVar; model y = classVar x1|x2|x3|x4|x5 @2 / selection=stepwise(stop=aicc); output out=glmselectOutput; run;
The preceding PROC GLMSELECT step produces three macro variables:
Macro Variable |
Value |
Description |
---|---|---|
|
2 |
Number of BY groups |
|
|
Selected model for the first BY group |
|
|
Selected model for the second BY group |
You can now leverage these macro variables and the output data set created by PROC GLMSELECT to perform postselection analyses that match the selected models with the appropriate BY-group observations. For example, the following statements create and run a macro that uses PROC GLM to perform LSMeans analyses.
%macro LSMeansAnalysis; %do i=1 %to &_GLSNUMBYS; title1 "Analysis Using the Selected Model for BY group number &i"; title2 "Selected Effects: &&_GLSIND&i"; ods select LSMeans; proc glm data=glmselectOutput(where = (_BY_ = &i)); class classVar; model y = &&_GLSIND&i; lsmeans classVar; run;quit; %end; %mend; %LSMeansAnalysis;
The LSMeans analysis output from PROC GLM is shown in Figure 48.16.