topic Missing data only in one year while present in other years in Statistical Procedures

Missing data only in one year while present in other years

skal — Tue, 05 May 2020 14:40:04 GMT

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

Re: Missing data only in one year while present in other years

ed_sas_member — Tue, 05 May 2020 14:59:25 GMT

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-sas/65370_excerpt.pdf

Best,

Re: Missing data only in one year while present in other years

SteveDenham — Tue, 05 May 2020 15:27:02 GMT

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