Codebook, output file, and template consistency

wengxyu1030 commented 2 years ago

Codebook consistency

[x] birth order in MICS: remove mor_bord, and harmonise mor_bord and hm_birthorder
[x] keep vars in MICS: mor_int, mor_male, mor_wght
[x] hh_religion / hh_toilet/hh_watersource : some missing in MICS, in household file
[x] hh_drinkwater / hh_sanfacilities in MICS : change name from h to hh_, in household file
[x] c_mateduc, in DHS, currently w_mateduc 11 child other & label

MICS Labels : !!! on the education and attainment variables

[x] Make available the original vars for maternal and household head education variables in the survey (the ones make the three categories from.... ??? He misunderstood, but request recorded here)
[x] DHS for maternal education: v106
[x] DHS for education of household head:
[x] suffix : _raw

Resource: Final Codebook: Final Codebook: link

Codebook DW internal use to track correction progress: link

[x] DHS-VI INDIA2015!!!!!
[ ] DHS-III Chad1996
[x] DHS-III Uzbekistan
[ ] Check if raw data is of the latest version
[ ] Check w_CPR/vaccination methodology update and the difference it creates
[x] MICS Series hh_watersource/hh_san_facilities

wengxyu1030 commented 2 years ago

Final Codebook: link

robin-wang commented 2 years ago

Thanks for keeping things organised... ~

robin-wang commented 2 years ago

[x] To confirm: Household head?
[currently we are implementing with partner/husband]
Resolved: to generate household leve indicator
DW Apr 2021 label var c_mateduclvl_raw "Level of education of child's mother - raw variable" label var c_maleduclvl_raw "Level of education of husband/partner - raw variable" label var hh_headage_raw "Age of head of household - raw" label var hh_headsex_raw "Sex of head of household - raw" label var hh_headedu_comp "Education of head of household - computed"
Note: hh_headed is already there, our methodology for hh_headedu_comp is compatible, but more detailed.

[DHS] VII

[x] c_mateduc name change from w_mateduc. including in labels.
[x] keep maternal education raw variables : v106
[x] keep household head raw variables : computed with hv106
[x] check labels of the cloned variables in updated template
[x] Maternal birth age / c_magebrt : v012 - (v007-b2), including labels
[x] Check birth order variable
[x] vaccination age cut-off - 15-23
[x] hm_headrel in main file - label correction
[x] Code Push
[x] Microdata upload
[x] Check Task Tracker for anything missing
[x] c_anc_public/hosp
[x] check h1
[x] loop replace output labels

VI

[x] c_mateduc name change from w_mateduc. including in labels.
[x] keep maternal education raw variables : v106
[x] keep household head raw variables : computed with hv106
[x] check labels of the cloned variables in updated template
[x] Maternal birth age / c_magebrt : v012 - (v007-b2), including labels
[x] Check birth order variable
[x] vaccination age cut-off
[x] hm_headrel in main file - label correction
[x] w_papsmear_ref/age
[x] Code Push
[x] Microdata upload
[x] Check Task Tracker for anything missing
[x] c_anc_public/hosp
[x] check h1
[x] loop replace output labels

V

[x] c_mateduc name change from w_mateduc. including in labels.
[x] keep maternal education raw variables : v106
[x] keep household head raw variables : computed with hv106
[x] check labels of the cloned variables in updated template
[x] Maternal birth age / c_magebrt : v012 - (v007-b2), including labels
[x] Check birth order variable
[x] vaccination age cut-off
[x] hm_headrel in main file - label correction
[x] w_papsmear_ref/age
[x] Code Push
[x] Microdata upload
[x] Check Task Tracker for anything missing
[x] c_anc_public/hosp
[x] check h1
[x] loop replace output labels

IV

[x] c_mateduc name change from w_mateduc. including in labels.
[x] keep maternal education raw variables : v106
[x] keep household head raw variables : computed with hv106
[x] check labels of the cloned variables in updated template
[x] Maternal birth age / c_magebrt : v012 - (v007-b2), including labels
[x] Check birth order variable
[x] vaccination age cut-off
[x] hm_headrel in main file - label correction
[x] w_papsmear_ref/age
[x] Code Push
[x] Microdata upload
[x] Check Task Tracker for anything missing
[x] c_anc_public/hosp
[x] check h1
[x] loop replace output labels

III

[x] c_mateduc name change from w_mateduc. including in labels.
[x] keep maternal education raw variables : v106
[x] keep household head raw variables : computed with hv106
[x] check labels of the cloned variables in updated template
[x] Maternal birth age / c_magebrt : v012 - (v007-b2), including labels
[x] Check birth order variable
[x] vaccination age cut-off
[x] hm_headrel in main file - label correction
[x] w_papsmear_ref/age
[x] Code Push
[x] Microdata upload
[x] Check Task Tracker for anything missing
[x] c_anc_public/hosp
[x] check h1
[x] loop replace output labels

II

[x] c_mateduc name change from w_mateduc. including in labels.
[x] keep maternal education raw variables : v106
[x] keep household head raw variables : computed with hv106
[x] check labels of the cloned variables in updated template
[x] Maternal birth age / c_magebrt : v012 - (v007-b2), including labels
[x] Check birth order variable
[x] hm_headrel in main file - label correction
[x] vaccination age cut-off
[x] w_papsmear_ref/age
[x] Code Push
[x] Microdata upload
[x] Check Task Tracker for anything missing
[x] c_anc_public/hosp
[x] check h1
[x] loop replace output labels

I

[x] c_mateduc name change from w_mateduc. including in labels.
[x] keep maternal education raw variables : v106
[x] keep household head raw variables : computed with hv106
[x] check labels of the cloned variables in updated template
[x] Maternal birth age / c_magebrt : v012 - (v007-b2), including labels
[x] Check birth order variable
[x] hm_headrel in main file - label correction
[x] vaccination age cut-off
[x] w_papsmear_ref/age
[x] Code Push
[x] Microdata upload
[x] Check Task Tracker for anything missing
[x] c_anc_public/hosp
[x] check h1

robin-wang commented 2 years ago

General Notes

Vaccination methodology for MICS already up to date, taking into account the vaccination card as denominator; months updated to [15,23]
anc_public/anc_hosp could not be generated in MICS, as initially assumed
hh_watersource, renamed from hh_drinkwater
to keep hh_water for raw inputs, due to special methodology for generating hh_watersource in MICS surveys
c_magebrt : updated methodology

MICS6

[x] anc_public/hosp implementable or not : 1 anc
[x] mor_bord / hm_birthorder : 10 mortality & label
[x] hh_religion / hh_toilet/hh_watersource : check every survey has them - 15 household
[x] hh_drinkwater / hh_san_facilities: change var name from h to hh - 20 sanitation
[x] c_mateduc
[x] c_air2 / c_fever / c_fevertreat / c_TreatARI2 / c_illness2 / c_illtreat2
[x] check c_sampleweight, was it coming from ant_sampleweight in DHS
[x] Labels harmonisation with DHS
[x] Maternal education & household head education
[x] Vaccination methodology update
[x] Modern method of contraception methodology update
[x] Maternal birth age / c_magebrt : labels in output
[x] Check birth order variable
[x] hm_headrel in main file - label correction
[x] vaccination age cut-off
[x] w_papsmear_ref/age
[x] Code Push
[x] Microdata upload
[x] Check Task Tracker for anything missing

MICS5

[x] mor_bord / hm_birthorder : 10 mortality & label
[x] anc_public/hosp implementable or not : 1 anc
[ ] hh_religion / hh_toilet/hh_watersource : check every survey has them - 15 household
[x] hh_drinkwater / hh_san_facilities: change var name from h to hh - 20 sanitation
[x] c_mateduc
[x] c_air2 / c_fever / c_fevertreat / c_TreatARI2 / c_illness2 / c_illtreat2
[x] check c_sampleweight, was it coming from ant_sampleweight in DHS
[x] Labels harmonisation with DHS
[x] Maternal education & household head education
[x] Vaccination methodology update
[x] Modern method of contraception methodology update
[x] Maternal birth age / c_magebrt : labels in output
[x] Check birth order variable
[x] hm_headrel in main file - label correction
[x] vaccination age cut-off
[x] w_papsmear_ref/age
[x] Code Push
[x] Microdata upload
[x] Check Task Tracker for anything missing

MICS4

[x] mor_bord / hm_birthorder : 10 mortality & label
[x] anc_public/hosp implementable or not : 1 anc
[ ] hh_religion / hh_toilet/hh_watersource : check every survey has them - 15 household
[x] hh_drinkwater / hh_san_facilities: change var name from h to hh - 20 sanitation
[x] c_mateduc
[x] c_air2 / c_fever / c_fevertreat / c_TreatARI2 / c_illness2 / c_illtreat2
[x] check c_sampleweight, was it coming from ant_sampleweight in DHS
[x] Labels harmonisation with DHS
[x] Maternal education & household head education
[x] Vaccination methodology update
[x] Modern method of contraception methodology update
[x] Maternal birth age / c_magebrt : labels in output
[x] Check birth order variable
[x] hm_headrel in main file - label correction
[x] vaccination age cut-off
[x] w_papsmear_ref/age
[x] Code Push
[x] Microdata upload
[x] Check Task Tracker for anything missing

MICS3

[x] mor_bord / hm_birthorder : 10 mortality & label
[x] anc_public/hosp implementable or not : 1 anc
[x] hh_religion / hh_toilet/hh_watersource : check every survey has them - 15 household
[x] hh_drinkwater / hh_san_facilities: change var name from h to hh - 20 sanitation
[x] c_mateduc
[x] c_air2 / c_fever / c_fevertreat / c_TreatARI2 / c_illness2 / c_illtreat2
[x] check c_sampleweight, was it coming from ant_sampleweight in DHS
[x] Labels harmonisation with DHS
[x] Maternal education & household head education
[x] Vaccination methodology update
[x] Modern method of contraception methodology update
[x] Maternal birth age / c_magebrt : labels in output
[x] Check birth order variable
[x] hm_headrel in main file - label correction
[x] vaccination age cut-off
[x] w_papsmear_ref/age
[x] Code Push
[x] Microdata upload
[x] Check Task Tracker for anything missing

MICS2

[x] mor_bord / hm_birthorder : 10 mortality & label
[x] anc_public/hosp implementable or not : 1 anc
[x] hh_religion / hh_toilet/hh_watersource : check every survey has them - 15 household
[x] hh_drinkwater / hh_san_facilities: change var name from h to hh - 20 sanitation
[x] c_mateduc
[x] c_air2 / c_fever / c_fevertreat / c_TreatARI2 / c_illness2 / c_illtreat2
[x] check c_sampleweight, was it coming from ant_sampleweight in DHS
[x] Labels harmonisation with DHS
[x] Maternal education & household head education
[x] Vaccination methodology update
[x] Modern method of contraception methodology update
[ ] Maternal birth age / c_magebrt : labels in output
[x] Check birth order variable
[x] hm_headrel in main file - label correction
[x] vaccination age cut-off
[x] w_papsmear_ref/age
[x] Code Push
[x] Microdata upload
[x] Check Task Tracker for anything missing

wengxyu1030 / UHC-Time-Trend

Codebook, output file, and template consistency #29