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
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?
@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...
I have attached the dataset. Both variables are numeric but I am still getting missing values.
@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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.