DHS VII 2023 - Gabon2019-21-RW

[robin-wang]

[CHECKLIST] WORKFLOW DOC Tracker for Project Management https://github.com/Data-Whale-DC/HEFPI2022-SC-update-tasks/issues/1

[WORKING BRANCH] https://github.com/wengxyu1030/DHS-Recode-VII/tree/Gabon2019-21-RW

[RAW DATA] https://worldbankgroup-my.sharepoint.com/:f:/g/personal/sneelsen_worldbank_org/Eu36TLZJIb5NuKfRQk_SdrYBKpl3yQhq8jkPCtdrsfM5_A

{FOR REVIEWERS}

• [x] They can run the code smoothly on the reviewer's end, where the microdata could be generated without error
• [x] Review and validate the quality checking output

{FOR CODERS} A. General Procedural Steps

• [x] Rebase current branch based on Master, ensure your branch is the latest. Tutorial: Rebasing your project branch onto another branch https://docs.github.com/en/desktop/contributing-and-collaborating-using-github-desktop/syncing-your-branch#rebasing-your-project-branch-onto-another-branch

• [x] Run script without error

• [x] Pass internal quality checking (the embedded quality check result: successfully produced value for the indicators and check if there're flags that the indicator value produced is too off from the published data)

• [x] Document as comments any notable changes/caveats (if any)

• [x] When Fully Completed Survey Edits, proceed to record hours worked: https://forms.gle/tLh7fxCMMsLobGHA6

B. Checklist and Guidance

• [x] ANC

  • Skill providers【prestataires qualifiés, comme les médecins, les gynécologues, les sage-femmes, les infirmiers accoucheurs/infirmières accoucheuses et les infirmiers/infirmières】
  • Checked in the regular express section in Programs
  • Tetanus Injection
  • Number of Injection Before/During Pregnancy 【Deux injections de vaccin antitétanique au cours de la grossesse ou; Deux injections ou plus, la troisième ayant été effectuée dans les 3 années avant la naissance ou; Trois injections ou plus, la dernière ayant été effectuée dans les 5 années avant la naissance ou; Quatre injections ou plus, la dernière ayant été effectuée dans les 10; années avant la naissance ou; Cinq injections ou plus à n’importe quel moment avant la naissance】
  • Recall period for last injection【5 years per survey report】
  • Relevant data comes other sections
  • Blood Pressure / Blood Sample / Urine Sample
  • Samples (m42c/d/e) are sub-questions for "receive antenatal care" in questionnaire or not【yes, all conditional on receiving care in m2n】

• [x] Delivery Care

  • c_facdel / delivery institutions / c_hospdel / delivery institutions【Place of delivery - private hospital/clinic wrapped in one category, accounting for 7.2% of all responses. This is currently incorporated as hospital delivery】
  • Consistent with the regular expression section in Programs 【Updated to include gynecologist for sba-skill】
  • c_skin2skin
  • Check if available; if, then note which variable【m34】
  • m15 skip condition
  • Usually delivery location is a filter question for c_caesarean(m17) / stay(m61) / mother or child PNC; list the conditions used for m15 if pattern is peculiar (normally (【m15=11,12】 etc))

• [x] PNC

  • child pnc 【updated to include gynecologist】
  • See if child pnc is only avaliable when (m15=11,12,96) or (m15!=11,12,96)
  • Check if Child PNC is designed to be from full sample, i.e not a subquestion within fertility section. If a subquestion, don't generate c_pnc_any and c_pnc_eff

• [x] Child Vaccination (search receive/month in birth.dta. if unknown vaccine pops up, search definition in DHS report)

  • BCG 【h2】
  • DTP/DPT, DTaP, DTwP or pentavalent 1-3 against diphtheria, tetanus and pertussis 【h3/h5/h7】
  • Polio 1-3 (IPV, OPV) 【h4 h6 h8】
  • Measles/MMR 【h9】
  • Other vaccines, if any, 【】

• [x] Child Illness

  • 20210510 For Providers, focus on the skilled providers rather than all
  • Diarrhea treatment provider【government dispensary/dispensaire du governement is considered public facilities for Gabon】
  • Check provider list being consistent with existing list (if not make changes in program)【Updated to exclude Nganga】
  • Fever/Ari1/Ari2 treatment provider【Secteur public, secteur médical privé, boutique, marché et vendeur de médicaments itinérants. Non compris les conseils ou traitements fournis par un praticien traditionnel; note that the report includes market, shop, and itinerant vendors where our template excludes them.】
  • Provider list being consistent with existing list【Updated to exclude Nganga】
  • Fever/Fever Treatment/Cough/Cough Treatment from Full Sample【check】
  • c_diarrhea_med, medicine and formal meds to treat are survey-specific. 20210510 focus on special medicines
  • c_diarrhea_medfor, medicine and formal meds to treat are survey-specific. 20210510 focus on special medicines
  • Validate c_ari can be generated or not【check】

• [x] Child Mortality

  • General Observations

• [x] Sleeping Under Bednet

  • Adhere to program's logic, but please list any specific bednet related observations (tricky cases for presumed treated or the like) 【ml0 not available】

• [x] Child Anthropometrics

  • General Observations (No need to generate "Wasting")

• [x] Reproductive Health

  • Contraceptive, check modern methods
  • In Need - most updated version of logics in program (temporarily no actions needed)

• [x] Female Anthropometrics and Cancer Screening【Papsmear】

  • Mammogram (X-ray, mamm...)
  • Pap Smear (Cervical vaginal cytology) : 【this is coded based on cervical cancer test, may not be directly corresponding to papsmear】
  • Note recall indicators for Mamm or Pap Smear (for example, s1012n used as filter for s1012m)

• [x] Miscellaneous: Hospitalisation, NCD & HIV 【Available for HIV/BP/DIAB indicators, harmonised from ind/men】

  • Hospitalisation, general observations
  • Hypertension treatment , blood pressure measure in the past or during the survey, for example check hm.dta/ind.dta/men.dta (generate a_bp_treat a_bp_sys a_bp_dial a_bp_meas a_hi_bp140 a_hi_bp140_or_on_med from ind.dta & men.dta by combining them)
  • Diabetes treatment/measure in the past (for example, a_diab_treat)

• [x] Cross-validate statistics in survey report, if applicable.

• [x] Reference the NAME-SURVEY branch when your edits are finalised.

  • Refer to the github working branch created for [Name-SurveyName]

• [x] Update micro data in Onedrive

• [x] Examine Quality Checking Output Files

  • [x] Successfully produced the indicators
  • [x] Check if there's a flag that the indicator value produced is too off from the published data

[robin-wang]

Place of delivery - private hospital/clinic wrapped in one category, accounting for 7.2% of all responses. This is currently incorporated as hospital delivery

[robin-wang]

Gynecologist included in delivery care and PNC categories.

[robin-wang]

Template redone directly in DHS-VII Master branch - ITN/NCD