Missing values in PROC ANOVA/GLM output table

[CeeElle]

When I perform PROC ANOVA or GLM I am getting missing values in my output tables usually in F value and p-value. In looking for the solution I have seen that this often occurs when you only have 2 levels as explanatory variables. How do I fix this? 

-My dataset consist two column table of Bone mineral density and Group # (which corresponds with different diagnosis classifications).

Thanks

[Reeza]

If you have a categorical variable, one level will always be missing. 
It’s hard to know if that’s what’s happening here without more details but that would be my guess. Or you have small Ns in some groups? 

[PaigeMiller]

---

@CeeElle wrote:

When I perform PROC ANOVA or GLM I am getting missing values in my output tables usually in F value and p-value. In looking for the solution I have seen that this often occurs when you only have 2 levels as explanatory variables. How do I fix this? 

---

But there's nothing wrong here. So you can't fix it. I wrote an article explaining this: https://communities.sas.com/t5/Statistical-Procedures/Interpreting-Multivariate-Linear-Regression-wi...

[CeeElle]

I have attached the dataset. Both variables are numeric but I am still getting missing values. 

[Reeza]

You also need to share your code, log and output. We have no idea if you're doing things correctly to know what's going on....

[Reeza]

I run GLM on your data and get missing values only for Group = 5 which is correct.

[PaigeMiller]

---

@CeeElle wrote:

I have attached the dataset. Both variables are numeric but I am still getting missing values. 

---

Show us the output. Show us the code.

Numeric is irrelevant, if these are variables in a CLASS statement, then my previous statement applies. 

[SASJedi]

I moved this to the Statistical Procedures community, where it may get additional attention from folks more familiar with this topic.