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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 2855 views
  • 0 likes
  • 4 in conversation