BookmarkSubscribeRSS Feed
L_L
Calcite | Level 5 L_L
Calcite | Level 5

Dear all

I' m running a model with proc glm to fit a multiple regression.

Y = score 's questionnaire (to measure quality of life)

X1 = treatment  (value a, b, c)

X2= age (continuos)

X3= education (low and high)

X4= gendere (Male, Female)

X5=BMI (continuos)

There's no multicollinearity  between covariates

The code is:

proc glm data=mydataset;

     class X1 X3 X4;

     model Y= X1 X2 X3 X4 X5 /solution;

run;

In the output tables with parameter estimate there's a footnote:

The X'X matrix has been found to be singular, and a generalized inverse was used to solve the normal equations.  Terms whose estimates are followed by the letter 'B' are not uniquely estimable.

What's the meaning? The results validity are questionable?

Is it recommend to run a different model? What kind of model?

Thanks in advance

1 REPLY 1
lvm
Rhodochrosite | Level 12 lvm
Rhodochrosite | Level 12

This occurs when you have class variable. In GLM (and in MIXED, and many other procedures), an over-parameterized model is used, where there is a parameter for every level of the class (factor) variable. WHen there is an intercept in the model (the default), this is one more parameter than needed to model the data. The generalized inverse essentially makes the 'last' parameter 0. By itself, this is fine. For a situation with X1 (3 levels), for instance, the mean Y is the intercept plus the parameter for the level of X1. WIth the listed constraint, this means that the mean for the last level of X1 is intercept + 0 = intercept. The SAS User's Guides gives great details on this topic (a vast topic).

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
  • 1 reply
  • 1406 views
  • 0 likes
  • 2 in conversation