SPSS Statistics

 View Only
  • 1.  Multiple imputation for selected cases only

    Posted Tue June 21, 2022 10:09 AM
      |   view attached
    Dear SPSS community

    I am running multiple imputation to fix missing data in my dataset. However, for some variables I need for SPSS to impute data for selected cases only and not for the whole dataset for that given variable. The reason I need imputed data for selected cases for a given variable is because some cases have skipped that question/variable because of skip logic in the survey (the question would not apply to them). Is there any way to tell SPSS which cases should be considered for multiple imputation? I am attaching my file in case it would help. I need SPSS to impute data for the variables "adol_water_liters" and "child_water_liters" but only for those cases who used water, meaning "adol_used_water" and "child_used_water" are coded as 1. When I run multiple imputation, SPSS imputes data to all cases for these variables.

    Thank you very much, karen

    ------------------------------
    Mark Marti
    ------------------------------

    #SPSSStatistics

    Attachment(s)

    sav
    Intervention_4.sav   5 KB 1 version


  • 2.  RE: Multiple imputation for selected cases only

    Posted Tue June 21, 2022 10:17 AM
    There is:

    TEMPORARY.
    SELECT IF (adol_used_water=1 & child_used_water=1).
    MULTIPLE IMPUTATION command...etc.

    That will impute only for cases for whom that is true.

    If you also need other variables imputed that do NOT have that restriction, that is more complicated, but I'm sure still possible. I'd need a little more time than I have at the moment. Please let me know.


    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------



  • 3.  RE: Multiple imputation for selected cases only

    Posted Tue June 21, 2022 11:19 AM
    Hi Rick

    Thank you very much for your feedback. I have cases which have adol_used_water=1 and child_used_water=0 or the other way around, so when I select  both 1 it drops those cases which have 1 and 0 or 0 and 1. If there is no way to configure this then I think I need to run impute for each variable separately? Would appreciate your advice. Thanks a lot!






  • 4.  RE: Multiple imputation for selected cases only

    Posted Tue June 21, 2022 11:21 AM
    OK. Change AND to OR:

    TEMPORARY.
    SELECT IF (adol_used_water=1 OR child_used_water=1).
    MULTIPLE IMPUTATION command...etc.

    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------



  • 5.  RE: Multiple imputation for selected cases only

    Posted Thu June 23, 2022 11:24 AM
    Thank you very much!