Missing data only in one year while present in other years

[skal]

Hello all,

I have to perform ANOVA on the set of three years data. I have the sample size of 100 in all years but in one year few lines didn't grow so I have data only for 95 lines. which method can be used to perform ANOVA and how to represent those missing 5 lines in one year while performing ANOVA?

Thanks  

[ed_sas_member · Accepted solution]

Hi @skal 

Do you mean you would like to impute values to missing data?

Here is an interesting resource to achieve this: https://support.sas.com/content/dam/SAS/support/en/books/multiple-imputation-of-missing-data-using-s...

Best,

[SteveDenham]

If you are going to model only the existing data, then PROC GLM is a good starting place.  See this: https://support.sas.com/documentation/onlinedoc/stat/141/glm.pdf .  Now look at the section called Getting Started.  The first example is PROC GLM for Unbalanced ANOVA.  Once you go through that example, you could try it on your data.

SteveDenham