BookmarkSubscribeRSS Feed
Terry
Calcite | Level 5

Hi to all,

I ran a linear model with proc glm and got a very weired result that I cannot explain what is going on.

I got one categorical variable in the model with 4 levels and I put it in the class statement. Normally I would expect that 3 levels except the reference level would have the estimates. But the output I got resulted in two levels of the variable with nothing estimated.

               educ      0           0.0000000 B       .                       .            .

               educ      1           1.1880336 B      0.99728636       1.19      0.2337

               educ      2          -0.9403576 B      1.06206014      -0.89      0.3760

               educ      3           0.0000000 B       .                       .            .

There's no error message in the log.

Besides, I also tried to create 3 dummy variables and replaced the categorical variable with them. Still, SAS gave no estimate for one of the 3 dummy variables.

I just wonder if there is any statistical trick in the procedure that does not match my conventional thinking. Or there might be some other things I missed or did wrong?

Mostly importantly, do I adjust for this categorical variable sufficiently given this result, since I include this covariate in the model as a confounder?

Thanks so much for the help!

2 REPLIES 2
Terry
Calcite | Level 5

I've got some ideas of what the problem might be. One level of the covariate is exactly the same as the level of another predictor in the model, that is, one level of the education was assigned to represent the education level for children<18 while the age variable also has a category for <18yr. Since they provide essentially the same information mathematically, one of them is omitted in the computation.

SteveDenham
Jade | Level 19

Bingo!  Full credit for discovering what was happening.

Steve Denham

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 2 replies
  • 1370 views
  • 0 likes
  • 2 in conversation