Multiple imputations error message - 'There are no missing values to impute the requested variables'?

07 July 2018 2 3K Report

I'm trying to run multiple imputations to fill in some missing values in a dataset. If I ask SPSS to analyze patterns, it shows that there are missing values and gives me the correct information. When I ask it to run imputations, the command 'scan data' in the 'constraints' menu also shows the same proportions of missing data. However, when I actually tell SPSS to run the imputations, I get this error message in my output:

'There are no missing values to impute the requested variables'.

I've played around with giving it min and max value constraints and this does not make a difference. I've got the imputation method set to 'automatic'. Does anyone know how to resolve this?

EDIT: The issue has been resolved. In order to impute the missing values, you have to include some values in the MI process that do not have any missing values.

Waqas Jamil

From toolbar go to Transform->Random number generator. A dialogue box should open. Now set Active Generator as Merssenne_Twister and set Staring point as Fixed values. Than from toolbar choose Analyse -> Multiple Imputation. Move the variables with missing values to the variables in model. Below in create a new dataset write some name xyz. In output tab check imputation model, display descriptive statistics and iteration history (if you want).

Emma Claire

Thanks, I have my Random Number Generator set as you suggested. This is my syntax for the MI that is giving me the above error message, if this is helpful:

DATASET ACTIVATE DataSet1.

*Impute Missing Data Values.

DATASET DECLARE IM_TEST_210718.

DATASET DECLARE MI_TEST_210718.

MULTIPLE IMPUTATION SCARED2_Q1 SCARED2_Q2 SCARED2_Q3 SCARED2_Q4 SCARED2_Q5 SCARED2_Q6 SCARED2_Q7

SCARED2_Q8 SCARED2_Q9 SCARED2_Q10 SCARED2_Q11 SCARED2_Q12 SCARED2_Q13 SCARED2_Q14 SCARED2_Q15

SCARED2_Q16 SCARED2_Q17 SCARED2_Q18 SCARED2_Q19 SCARED2_Q20 SCARED2_Q21 SCARED2_Q22 SCARED2_Q23

SCARED2_Q24 SCARED2_Q25 SCARED2_Q26 SCARED2_Q27 SCARED2_Q28 SCARED2_Q29 SCARED2_Q30 SCARED2_Q31

SCARED2_Q32 SCARED2_Q33 SCARED2_Q34 SCARED2_Q35 SCARED2_Q36 SCARED2_Q37 SCARED2_Q38 SCARED2_Q39

SCARED2_Q40 SCARED2_Q41 SCARED2_GLOBAL SCARED2_PD SCARED2_GAD SCARED2_SEP SCARED2_SAD

SCARED2_SCHOOLAVOID

/IMPUTE METHOD=AUTO NIMPUTATIONS=5 MAXPCTMISSING=NONE maxmodelparam = 500

/MISSINGSUMMARIES NONE

/IMPUTATIONSUMMARIES MODELS DESCRIPTIVES

/OUTFILE IMPUTATIONS=IM_TEST_210718 FCSITERATIONS=MI_TEST_210718

How to compare two groups with only two measurements?

Binary Logistic Generalized Linear Mixed model in SPSS. Is it doable?

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10?

What test should i use in comparing the correlation between categorical and continuous variables?

Logistical regression using SPSS for a dichotomous dependent variable, with an independent variable of 1, 2, 5 and 10 seconds?

How to increase a model accuracy ?

1. What is the impact of having different scales in a survey? and how can we solve this problem before and after data collection (Literature)?

How to find the mean, SD and CI in SPSS?

What degree of missing data in a particular case/participant results in Expectation-Maximisation no longer working?

How to code open-ended questions in SPSS?