Pakistan2017 - NingJiang

[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/Pakistan2017-NingJiang

[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【doctors, nurses, midwives, and lady health visitors？】
  • Checked in the regular express section in Programs
  • Tetanus Injection
  • Number of Injection Before/During Pregnancy 【m1】
  • Recall period for last injection【5 years】
  • 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】

• [x] Delivery Care

  • c_facdel / delivery institutions / c_hospdel / delivery institutions【bhu, community midwife, private clinic?】
  • Consistent with the regular expression section in Programs
  • c_skin2skin
  • Check if available; if, then note which variable【available】
  • 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
  • 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【question 457】

• [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 and h7】
  • Polio 1-3 (IPV, OPV) 【h4, h6 and h8】
  • Measles/MMR 【h9】
  • Other vaccines, if any, 【pneumococcal, rotavirus, hepatitis and his】

• [x] Child Illness

  • 20210510 For Providers, focus on the skilled providers rather than all
  • Diarrhea treatment provider【bhu】
  • Check provider list being consistent with existing list (if not make changes in program)【】
  • Fever/Ari1/Ari2 treatment provider【need to be checked again; delete homeopath, dispenser and hakim】
  • Provider list being consistent with existing list【need to be checked again】
  • Fever/Fever Treatment/Cough/Cough Treatment from Full Sample【yes】
  • 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【yes】

• [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) 【untreated net】

• [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【no data found】

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

• [x] Miscellaneous: Hospitalisation, NCD & HIV 【no data found 】

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

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

@a24680bjiang Sorry for my delayed response. Here is the assignment for you, Pakistan2017 in DHS RecodeVII. You can find the working branch and raw data linked in the issue content above; if any of this is unclear at this point by writing alone, let me know : )

[a24680bjiang]

there are some questions that I put a "?" there like: whether lady health visitors equals to ready health workers; whether basic health unit( bhu) can be defined as formal delivery institutions; for Measles, data value of h9a does not equal to h9; and what should I do if there are any vaccination else for child?

[robin-wang]

there are some questions that I put a "?" there like: whether lady health visitors equals to ready health workers; whether basic health unit( bhu) can be defined as formal delivery institutions; for Measles, data value of h9a does not equal to h9; and what should I do if there are any vaccination else for child?

Noted! Let me look into it. Thanks much for looking into such level of details. Will be back with resolutions asap

[robin-wang]

• Skilled ANC: The survey report, page 156 tells us 86% received ANC from skilled providers. When you look at the coded output, what is the rate for this variable with and without lady health visitors?

• Per table 9.7, note 1, skilled provider includes doctor, nurse, midwife, lady ehalth visitor, and community midwife

• For facility delivery, page 171, report 9.6 shows 65.9%. Could you please benchmark?

• on whether m15 is a filter question, you can cross-tabulate m15 against m17, and m15 against m61. When you do tab m61 m15, it becomes clear that time spent at place of delivery is not recorded when giving birth at home.

• Other Vaccinations: great to have the information recorded. Let's only recognise their presence.

• Measles: Good catch. if respondent reported having received measles vaccination on either h9 or h9a, let's treat them as having vaccination.

[a24680bjiang]

question about do file 8-c_diarrhea_pro, report wrote as "The survey data show that the prevalence of diarrhoea among children under age 5 is 19%. Overall, 71% of children with diarrhoea were taken to a health provider for advice or treatment ", and the mean of c_diarrhea_pro is 0.61. When I add the var to the !regexm, the mean of c_diarrhea_pro does not change. I believe there isn't the story of double-counting.

[robin-wang]

question about do file 8-c_diarrhea_pro, report wrote as "The survey data show that the prevalence of diarrhoea among children under age 5 is 19%. Overall, 71% of children with diarrhoea were taken to a health provider for advice or treatment ", and the mean of c_diarrhea_pro is 0.61. When I add the var to the !regexm, the mean of c_diarrhea_pro does not change. I believe there isn't the story of double-counting.

Interesting observation here. I suspect maybe one of the categories that contributed to c_diarrhea_pro is making up for the 10 percentage point difference. Do you have a sense of which categories are constituents of the c_diarrhea_pro variable?

[a24680bjiang]

question about do file 8-c_diarrhea_pro, report wrote as "The survey data show that the prevalence of diarrhoea among children under age 5 is 19%. Overall, 71% of children with diarrhoea were taken to a health provider for advice or treatment ", and the mean of c_diarrhea_pro is 0.61. When I add the var to the !regexm, the mean of c_diarrhea_pro does not change. I believe there isn't the story of double-counting.

Interesting observation here. I suspect maybe one of the categories that contributed to c_diarrhea_pro is making up for the 10 percentage point difference. Do you have a sense of which categories are constituents of the c_diarrhea_pro variable?

I suppose some categories, but these var also does not appear the difference. Like h12c-bhu is the var I think is not included, but sum h12c still shows observations.

[robin-wang]

Let me look into this, let's move on with the rest of the recoding : )

[robin-wang]

I had a quick look at c_diarrhea_pro, you were right to have confusions. Our coding is correct, despite the differences. Let's move on. Thanks for flagging this out!

[a24680bjiang]

Hi, Robin! For delivery care. do file, "*c_sba_eff1: Effective delivery care (baby delivered in facility, by skilled provider, mother and child stay in facility for min. 24h, breastfeeding initiated in first 1h after birth)". What do you mean when we say "facility"? Does any place other than home count as facility, or only the formal facility mentioned before in delivery?

[robin-wang]

I am circling back on reviewing / responding to your question.

This is a good one, and the judgment on the scope of facilities should ultimately come from the report, in two ways:

1. Whether the survey report has specifically said anything about which are formal facilities. It might appear in the associated tables, as a footnote, or even as header.

2. Whether our calculated rate of facility delivery agrees with the reported (if possible) rate of children/babes delivered in formal facilities. Refer to the first point also.

Another angle to understand this, in our coding template:

Please note that in the delivery_care.do file, around row 60, we have defined [c_facdel]. This speaks to facility delivery status. The understanding of facility delivery in the context of c_sba_eff1 should be consistent with c_facdel.

c_sba_eff1 is an aggregate indicator, based on multiple inputs, and these inputs are clues across the delivery_care.do file.

In some countries, however, judgments may be harder to arrive at. For example, when combing through the countries in Central Asia, we noted that most of the delivery was carried out in [Maternity homes], and we had gone to great length to validate the definition with the World Bank team, to make sure their Country Assignment Office shares insights on how to interpret them in light of the health care system in the associated region/country. Some caveats here, as background information for you.