topic Re: Run regressions with combinations of multiple variables in SAS Procedures

Run regressions with combinations of multiple variables

lizzy28 — Fri, 02 Oct 2015 19:55:13 GMT

I have 20 variables in the same data file. I need to try to run regressions with var0 being the dependent variable, and the independent variables being any five variables out of the rest 19 variables. Is there any quick way to run all the possible regressions in this case?

Re: Run regressions with combinations of multiple variables

PaigeMiller — Fri, 02 Oct 2015 20:10:19 GMT

I suppose you could write a macro to do this, but that doesn't sound like a trivial thing to do; and anyway, using Partial Least Squares regression (PROC PLS) ought to produce superior results (lower mean squared error for coefficients and predicted values) than using PROC REG as you are trying to do.

Re: Run regressions with combinations of multiple variables

PGStats — Fri, 02 Oct 2015 21:17:04 GMT

Sounds like you want to select 5 variables for your model. If you want the selection to be based on r-square, adjusted r-square or Mallows CP then proc reg can do the search for you. Something like

proc reg data=myData;
model x0 = x1-x20 / selection=CP start=5 stop=5 best=100;
run;

will find the 100 best 5-variable linear models according to the CP criteria.

Re: Run regressions with combinations of multiple variables

PaigeMiller — Sat, 03 Oct 2015 15:20:29 GMT

Okay, that works, but I still think this is a poor choice of analysis.

Re: Run regressions with combinations of multiple variables

PGStats — Sat, 03 Oct 2015 17:02:11 GMT

Agreed, statistical procedures for variable selection should never be used blindly. Simulations and sensitivity analyses have shown their instability over and over.

On model selection issues, read http://support.sas.com/documentation/cdl/en/statug/68162/HTML/default/viewer.htm#statug_glmselect_details14.htm

Re: Run regressions with combinations of multiple variables

PaigeMiller — Sat, 03 Oct 2015 18:43:51 GMT

I'm sorry if I am sounding like a cantakerous old model builder, I agree that the problems using variable selection techniques are well documented, and I agree that you shouldn't use these procedures blindly, but the original problem as stated tries to use these problematic model building procedures blindly with silly and meaningless restrictions (model can have only five variables).

Re: Run regressions with combinations of multiple variables

lizzy28 — Mon, 12 Oct 2015 16:27:54 GMT

I tend to write a macro to do this because I have to utimately run Vector Autoregression (proc varmax), but don't really know how to start.

Thank you!

Lizi

Re: Run regressions with combinations of multiple variables

MikeZdeb — Mon, 12 Oct 2015 20:23:35 GMT

Hi. New situation, six variables, VAR1 is dependent. How many regressions taking VAR2-VAR6 three variables at a time ... 10 combinations ...

var2 var3 var4
var2 var3 var5
var2 var3 var6
var2 var4 var5
var2 var4 var6
var2 var5 var6
var3 var4 var5
var3 var4 var6
var3 var5 var6

Given your 19 variables taken 5 at a time, that's 11,628 regressions. You can write a macro (no problem, see below), but do you really want to " ... run all the possible regressions ... " ?

* generate all combinations of 5 vars taken 3 at a time;

data vars (keep=v1-v3);
array v(2:6) $4 ('var2' 'var3' 'var4' 'var5' 'var6');
ncomb=comb(5,3);
do j=1 to ncomb;
   call lexcomb(j, 3, of v(*));
   put (v1-v3) ($5.);
   output;
end;

* macro variable with total number of combinations, 5 vars taken 3 at a time;
call symputx('regs',ncomb);
run;

* read combination, run regeression;

%macro reg;
%do j=1 %to &regs;
data _null_;
rec=&j;
set vars point=rec;
call symput('indpt',catx(' ',of v1-v3));
stop;
run;

proc reg data=x;
model var1 = &indpt;
run;

quit;
%end;
%mend;

Re: Run regressions with combinations of multiple variables

SteveDenham — Tue, 13 Oct 2015 13:18:11 GMT

I want to nominate @PaigeMiller's response for the Hall of Fame, if we had one. To quote John Tukey twice:

There is no point in being precise when you don't know what you're talking about.

The combination of some data and an aching desire for an answer does not ensure that a reasonable answer can be extracted from a given body of data.

Steve Denham

Re: Run regressions with combinations of multiple variables

lizzy28 — Tue, 13 Oct 2015 16:04:20 GMT

Thanks a lot, Mike!

I know it's unsual to "run all possible regressions", but this will allow me to exclude those with higher forecast errors.

Thanks again,

Lizi

Re: Run regressions with combinations of multiple variables

PaigeMiller — Tue, 13 Oct 2015 16:56:38 GMT

Just because something can be programmed, it doesn't mean that it produces a good result.

In particular, the models that wind up with higher forecast errors may be due to lots of reasons, including multi-collinearity among the X-variables, and in any event @PGStats has provided a link that explains why this type of model selection is misleading at best, and should be avoided "because it violates every principle of statistical estimation and hypothesis testing".

So I'll say it again, your restriction of having exactly 5 independent variables in the model is silly and meaningless and most likely misleading; and again I recommend PROC PLS on all 19 independent variables.