BookmarkSubscribeRSS Feed
sams8765
Fluorite | Level 6

Hello - This is not a coding question but an interpretation question. I ran a regression model in SAS and the model results look good except I notice that one of my categorical predictor variables is missing from the parameter estimates. What does this mean? How do I interpret these results?

8 REPLIES 8
Reeza
Super User
Is there a note in the log?
Is it a level of a categorical variable or all levels for that categorical variable?
sams8765
Fluorite | Level 6

So it was just one level of my categorical variable. So overall, the categorical variable had 21 levels but only 20 of them showed up in the parameter estimates. I'm curious as to why just one of the levels of the categorical variable is missing?

 

 

There also was no notes/errors in the log that would indicate anything.

Reeza
Super User
How did you parameterize the variable? If you used reference coding that is expected, the estimate for that level, your reference level, get combined with the intercept.

PaigeMiller
Diamond | Level 26

@sams8765 wrote:

So it was just one level of my categorical variable. So overall, the categorical variable had 21 levels but only 20 of them showed up in the parameter estimates. I'm curious as to why just one of the levels of the categorical variable is missing?

 

 

There also was no notes/errors in the log that would indicate anything.


Did the 21st level show up with a zero coefficient, or is it not present in the output? Show us what you see.

 

Are two of the levels identical in the first 32 characters (even if they are different in the 33rd or later characters)? What is the name of the level that is missing?

--
Paige Miller
ballardw
Super User

Since there many regression procedures perhaps you can share code.

 

That way we know which options you used that might affect output. Then also sharing the specific output you are looking at and which parameter.

sams8765
Fluorite | Level 6

Here is the regression code I am using. Please note that it's embedded within a macro. I am only including the actual proc hpgenselect statement. 

 

mantor12_0-1636116973478.png

 

Here is a screenshot of the output. The predictor variables used as input was A*B (so the interaction of these 2 variables where A has 2 levels and B has 23 levels (i originally send 21)). The 5.1 relates to the intercept and then the first set of 1 through th relate to A level 1. You'll notice the A level 2 starts with 02 so the 01 is missing. This is what I'm trying to solve. Why would the (A level2)-01 be missing?

mantor12_1-1636117260856.png

 

 

PaigeMiller
Diamond | Level 26

Oh come on, why be so stingy with information? Show us a screen capture of the output that is not chopped off so we can read the labels and columns headings. And show us the values of your macro variables &class and &target and &predictors so we might understand what the model is you are creating.

--
Paige Miller
Reeza
Super User
How many observations do you have in your data set?

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 8 replies
  • 593 views
  • 2 likes
  • 4 in conversation