BookmarkSubscribeRSS Feed
jawon
Fluorite | Level 6
Can't figure out how to address this warning...

WARNING: The variable l12_drop_giv_obchan_other has zero or negative sum of squares after being adjusted for the intercept, if there is one. Hence, it will not be used in any subset selection.

Then the procedure stops. My code is this...

proc reg data = input_dataset;
model dep_var = <<< 32 independent vars >>>
/ selection = rsquare adjrsq cp
best = 3
noint ;
run;

Funny thing is it runs fine when there are 31 variables, but not when I add more. And it doesn't seem to matter which variable I added. All the values in the variables appear to be fine. I can't seem to find any documentation about this warning.

Anyone have some ideas? Thank you.
4 REPLIES 4
Ksharp
Super User
Hi.
Do you use another selection method other than rsquare.
Such as:

/ selection = stepwise cp

/ selection = backward cp


I supposed that the model includes a lot of variables, So the Rsquare of model is almost to approach to one,when you add thirty-second var, the model cann't promote the Rsquare any more.



Ksharp Message was edited by: Ksharp
jawon
Fluorite | Level 6
I have not tried other selection methods, but I suppose I should try.

And the r2 is no where near 1 so that wouldn't be the prob.

Thanks for your thoughts.
Paige
Quartz | Level 8
32 independent variables and no intercept? I certainly don't recommend doing that.

Can't add variable number 32, no matter what it is? Perhaps you have run out of degrees of freedom??

The whole idea of having 32 independent variables and then doing some variable selection is usually doomed to fail. A better approach, in my opinion, is something like Partial Least Squares regression, where you don't have to drop variables, and you find linear combinations of independent variables that are predictive of Y.
Chinecherem
Calcite | Level 5

I had a similar problem and I was made after several attempts. The problem most like is that one or more variables are not yet in the data file. Take time to cross-check that. Thank you.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 2826 views
  • 0 likes
  • 4 in conversation