topic Re: Missing values in PROC ANOVA/GLM output table in Statistical Procedures

Missing values in PROC ANOVA/GLM output table

CeeElle — Wed, 07 Oct 2020 03:18:32 GMT

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

Re: Missing values in PROC ANOVA/GLM output table

Reeza — Wed, 07 Oct 2020 03:58:52 GMT

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?

Re: Missing values in PROC ANOVA/GLM output table

PaigeMiller — Wed, 07 Oct 2020 10:59:28 GMT

@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-with-Categorical/m-p/591230#M28913

Re: Missing values in PROC ANOVA/GLM output table

CeeElle — Wed, 07 Oct 2020 23:56:30 GMT

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

Re: Missing values in PROC ANOVA/GLM output table

Reeza — Thu, 08 Oct 2020 00:41:30 GMT

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....

Re: Missing values in PROC ANOVA/GLM output table

Reeza — Thu, 08 Oct 2020 00:43:40 GMT

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

Re: Missing values in PROC ANOVA/GLM output table

PaigeMiller — Thu, 08 Oct 2020 10:27:30 GMT

@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.

Re: Missing values in PROC ANOVA/GLM output table

SASJedi — Tue, 13 Oct 2020 18:15:03 GMT

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