Pakistan2019

[wengxyu1030]

WORKFLOW DOC

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

• [ ] Run script without error

• [ ] 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)

• [ ] 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

• [ ] ANC

  • Skill providers
  • Checked in the regular express section in Programs
  • Tetanus Injection
  • Number of Injection Before/During Pregnancy
  • Recall period for last injection
  • 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

• [ ] Delivery Care

  • c_facdel / delivery institutions / c_hospdel / delivery institutions
  • Consistent with the regular expression section in Programs
  • c_skin2skin
  • Check if available; if, then note which variable
  • m15 skip condition
  • Usually delivery location is a filter question for c_caesarean(m17) / stay(m61) / mother or child PNC; is it m15, if not which one, and list the conditions used for m15 if pattern is peculiar (normally (m15 = 11, 12 etc))

• [ ] PNC

  • child pnc
  • 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

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

  • BCG
  • DTP/DPT, DTaP, DTwP or pentavalent 1-3 against diphtheria, tetanus and pertussis
  • Polio 1-3 (IPV, OPV)
  • Measles/MMR
  • Other vaccines, if any,

• [ ] Child Illness

  • Diarrhea treatment provider
  • Check provider list being consistent with existing list (if not make changes in program)
  • Fever/Ari1/Ari2 treatment provider
  • Provider list being consistent with existing list
  • Fever/Fever Treatment/Cough/Cough Treatment from Full Sample
  • c_diarrhea_med, medicine and formal meds to treat are survey-specific
  • c_diarrhea_medfor, medicine and formal meds to treat are survey-specific
  • Validate c_ari can be generated or not

• [ ] Child Mortality

  • General Observations

• [ ] Sleeping Under Bednet

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

• [ ] Child Anthropometrics

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

• [ ] Reproductive Health

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

• [ ] Female Anthropometrics and Cancer Screening

  • Mammogram (X-ray, mamm...)
  • Pap Smear (Cervical vaginal cytology)
  • Note recall indicators for Mamm or Pap Smear (for example, s1012n used as filter for s1012m)

• [ ] Hospitalisation, NCD & HIV

  • 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)

  • Note from WB team for reference: "don't worry if you cannot find men.dta, not all surveys have it. if it is collected from ind.dta and men.dta seperately (some survey have female & male questionnarie, collecting these data seperately), you will need to combine these 2 dataset, generating these indicators and merge them back to hm.dta. If only from ind.dta or men.dta, i.e. only for female or male, don't generate these variables. If a new/survey-specific datafile occurs, it is highly likely that it contains info. for 13.do. "

  • Diabetes treatment/measure in the past (for example, a_diab_treat)

  • HIV, general observations

  • HIV questionnaire might exsit in Section 4 of "HEALTH ISSUES QUESTIONNAIRE". If they don't ask hiv test results, they are not helpful. but please document these observations.

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

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

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

• [ ] Update micro data in Onedrive

• [ ] Examine Quality Checking Output Files

[robin-wang]

@yining-sun Pakistan2019 would be your next assignment, please note we added a step "REBASE Repository to Master". This means you need to ensure your current repository reflects the updated master; rather than mirroring the master when respective branches were created.

Pakistan2019 is a very special case. Many variables don't exist in the form/name as they are supposed to be. Take your time on this one, and do shout out when in trouble/doubt.

Cheers!

[yining-sun]

Summary of the findings

1. Useful variables only exist in ind.dta.
2. None of the variables have the same variable name recorded in the existing do-file.
3. Below is the list of the variables that I found can be replaced.

• 1_antenatal_care.do :

  • m14 (number of visits) ~ind.dta q411 “antenatal visits during pregnancy”
  • m2n (filter question) ~ind.dta q406 received antenatal care for pregnancy
  • m13 (timing of 1st antenatal check): not found
  • m2a-c (skilled providers): ~ind.dta q407 (provider of antenatal care for pregnancy)
  • m42c-e (during pregnancy: blood pressure, urine, and blood sample): ~ind.dta q412a-c (antenatal care: blood pressure, urine sample, blood sample)
  • m45 (during pregnancy, given or bought iron tablets /syrup): ~ind.dta q419 (iron tablets during pregnancy)
  • m1 (number of tetanus injections before birth): ~ind.dta q610 / q415 [not sure which one]
  • m1a (number of tetanus injections before pregnancy): ~ind.dta q417a

• 2_delivery_care.do:

  • m3a-m (assistance: doctor -...): ~ind.dta q423 (assistance at delivery)
  • m15 (place of delivery): ~ind.dta q424
  • m34 (put to the breast): not available
  • m4 (duration of breastfeeding): not available
  • m77 (skin to skin) : not available
  • m17 (delivery by caesarean section): ~ind.dta q425 (delivery type = 3)

• 3_postnatal_care.do

  • ~ind.dta
    • q431 postnatal check on respondent while in facility; q432u, n: time
    • q434 checkup on respondent after discharge from place of delivery
    • q436 person giving checkup on respondent after discharge
    • q437 place of checkup on respondent after discharge
    • q438a person giving checkup on respondent after discharge
    • ...

• 4_sexual_health.do: none available.

  • related variables include ~ind.dta q302 ever used contraceptive method.

• 5_woman_anthropometrics.do

  • woman's BMI related height and weight not found

• 7_child_vaccination.do: None is available

• 8_child_illness.do: None is available

• 9_child_anthropometrics.do: None is available

• 10_child_mortality.do: all variables are available in ~child.dta, but the variable names are different. The labels are very straightforward 1:1

• 11_child_other.do:

  • bednet: not available
  • mother's educational level: qwfeduc (all woman factor - educational), but it has too many categories, I am not sure if it works.

• 12_hiv.do: not available

• 13_adult.do:

  • a_inpatient_1y: the only related variable, ~ind.dta q510 is about hospitalization during pregnancy. But the variable is supposed to measure if any household member is hospitalized in the past year.
  • treatment of high blood pressure and other problems: not available.

• 14_demographics.do

  • all can be found in hm.dta

• 15_household.do

  • Not all can be found in hm.dta. Some exist in the hm.dta, such as household id, residence regions / labels.

• 16_woman_cancer.do: none is available

[wengxyu1030]

Talked with Task Team Leader Sven and decided to park this survey for now.