BY-COVID - WP5 - Baseline Use Case: SARS-CoV-2 vaccine effectiveness assessment

Imputation of missing values

Handling missing data

Variable Method Nr_missing Pct_missing Number of imputed values Missing_values Comorbidity comorb_incl Immunestatus imm_incl Core MCAR Perc_miss_lt Perc_miss_lt5 Perc_miss_lt15
person_id No missing values 0 0.000 0 FALSE FALSE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
age_nm No missing values 0 0.000 0 FALSE FALSE TRUE FALSE TRUE TRUE FALSE TRUE TRUE TRUE
sex_cd No missing values 0 0.000 0 FALSE FALSE TRUE FALSE TRUE TRUE FALSE TRUE TRUE TRUE
socecon_lvl_cd Imputation of missing values (not MCAR) 187223 0.037 43531 TRUE FALSE TRUE FALSE TRUE TRUE FALSE FALSE TRUE TRUE
residence_area_cd Imputation of missing values (not MCAR) 70381 0.014 30343 TRUE FALSE TRUE FALSE TRUE TRUE FALSE TRUE TRUE TRUE
country_cd No missing values 0 0.000 0 FALSE FALSE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
foreign_bl No missing values 0 0.000 0 FALSE FALSE TRUE FALSE TRUE TRUE FALSE TRUE TRUE TRUE
exitus_dt Allow missing values and don’t impute missing values (no core variable) 4969024 0.971 0 TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
exitus_bl No missing values 0 0.000 0 FALSE FALSE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
essential_worker_bl Imputation of missing values (not MCAR) 43531 0.009 43531 TRUE FALSE TRUE FALSE TRUE TRUE FALSE TRUE TRUE TRUE
institutionalized_bl Exclude core variable as matching variable (more than 15% missing values) 5118597 1.000 0 TRUE FALSE TRUE FALSE TRUE TRUE FALSE FALSE FALSE FALSE
dose_1_brand_cd Allow missing values and don’t impute missing values (no core variable) 794593 0.155 0 TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
dose_1_dt Allow missing values and don’t impute missing values (no core variable) 794593 0.155 0 TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
dose_2_brand_cd Allow missing values and don’t impute missing values (no core variable) 956237 0.187 0 TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
dose_2_dt Allow missing values and don’t impute missing values (no core variable) 956237 0.187 0 TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
dose_3_brand_cd Allow missing values and don’t impute missing values (no core variable) 2196259 0.429 0 TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
dose_3_dt Allow missing values and don’t impute missing values (no core variable) 2196259 0.429 0 TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
doses_nm Allow missing values and don’t impute missing values (no core variable) 794593 0.155 0 TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
fully_vaccinated_dt Allow missing values and don’t impute missing values (no core variable) 956170 0.187 0 TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
fully_vaccinated_bl No missing values 0 0.000 0 FALSE FALSE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
vaccination_schedule_cd Allow missing values and don’t impute missing values (no core variable) 956170 0.187 0 TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
confirmed_case_dt Allow missing values and don’t impute missing values (no core variable) 4155429 0.812 0 TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
confirmed_case_bl No missing values 0 0.000 0 FALSE FALSE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
previous_infection_dt Allow missing values and don’t impute missing values (no core variable) 5029125 0.983 0 TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
previous_infection_bl No missing values 0 0.000 0 FALSE FALSE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
test_type_cd Allow missing values and don’t impute missing values (no core variable) 4155429 0.812 0 TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
variant_cd Allow missing values and don’t impute missing values (no core variable) 5088065 0.994 0 TRUE FALSE TRUE FALSE TRUE FALSE FALSE FALSE FALSE FALSE
diabetes_bl No missing values 0 0.000 0 FALSE TRUE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
obesity_bl No missing values 0 0.000 0 FALSE TRUE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
heart_failure_bl No missing values 0 0.000 0 FALSE TRUE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
copd_bl No missing values 0 0.000 0 FALSE TRUE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
solid_tumor_without_metastasis_bl No missing values 0 0.000 0 FALSE TRUE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
chronic_kidney_disease_bl No missing values 0 0.000 0 FALSE TRUE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
sickle_cell_disease_bl No missing values 0 0.000 0 FALSE TRUE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
hypertension_bl No missing values 0 0.000 0 FALSE TRUE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
chronic_liver_disease_bl No missing values 0 0.000 0 FALSE TRUE TRUE FALSE TRUE FALSE FALSE TRUE TRUE TRUE
blood_cancer_bl No missing values 0 0.000 0 FALSE FALSE TRUE TRUE TRUE FALSE FALSE TRUE TRUE TRUE
transplanted_bl No missing values 0 0.000 0 FALSE FALSE TRUE TRUE TRUE FALSE FALSE TRUE TRUE TRUE
hiv_infection_bl No missing values 0 0.000 0 FALSE FALSE TRUE TRUE TRUE FALSE FALSE TRUE TRUE TRUE
primary_immunodeficiency_bl No missing values 0 0.000 0 FALSE FALSE TRUE TRUE TRUE FALSE FALSE TRUE TRUE TRUE
immunosuppression_bl No missing values 0 0.000 0 FALSE FALSE TRUE TRUE TRUE FALSE FALSE TRUE TRUE TRUE
pregnancy_bl Exclude core variable as matching variable (more than 15% missing values) 5118597 1.000 0 TRUE FALSE TRUE FALSE TRUE TRUE FALSE FALSE FALSE FALSE

Listwise deletion

flag_listwise_del==TRUE flag_listwise_del==FALSE
181379 4937218