Pakistan2006-forJianing

[robin-wang]

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

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

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

B. Checklist and Guidance

• [x] ANC

  • Skill providers
  • Checked in the regular express section in Programs 【Skilled provider includes doctor, nurse, midwife, and Lady Health Visitor】
  • Tetanus Injection
  • Number of Injection Before/During Pregnancy 【number of injection during pregnancy - not available in birth.dta；but respondents were asked in q420】
  • 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 【(?) subquestion of q407： Did you see anyone for antenatal care for this pregnancy?】

• [x] Delivery Care

  • c_facdel / delivery institutions / c_hospdel / delivery institutions
  • Consistent with the regular expression section in Programs 【c_hospdel: private hosp/clinic、govt. hospital；c_facdel: private hosp/clinic、govt. hospital、govt. health center/mch】
  • c_skin2skin
  • Check if available; if, then note which variable 【not available】
  • 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)) 【m15=11(your home), 12(other home), 96(other) - q449】

• [x] PNC

  • child pnc
  • See if child pnc is only avaliable when (m15=11,12,96) or (m15!=11,12,96) 【full sample】
  • 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 【shbv1-3：received hbv1-3 (hepatitis B vaccine); ho: polio 0】

• [x] Child Illness

  • Diarrhea treatment provider【GOVT. HOSPITAL , RHC/MCH, BHU/FWC, LADY H.WORKER , PVT. HOSPITAL/CLINIC , CHEMIST, PVT. DOCTOR , HOMEOPATH, DISPENSER / COMPOUNDER, OTHER PRIVATE MED. , SHOP, HAKIM, DAI/ TBA 】
  • Check provider list being consistent with existing list (if not make changes in program) 【(?)h12a-x: chemist, homeopath, shop, hakim, Dai&Tba are NA or excluded】
  • Fever/Ari1/Ari2 treatment provider 【GOVT. HOSPITAL , RHC/MCH, BHU/FWC, LADY H.WORKER , PVT. HOSPITAL/CLINIC , CHEMIST, PVT. DOCTOR , HOMEOPATH, DISPENSER / COMPOUNDER, OTHER PRIVATE MED. , SHOP, HAKIM, DAI/ TBA 】
  • Provider list being consistent with existing list
  • Fever/Fever Treatment/Cough/Cough Treatment from Full Sample【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 【h15g-unknown pill or syrup, h15i-unknown injection, can they also be considered as formal meds?】
  • Validate c_ari can be generated or not 【h31, h31b/c available】

• [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)【ml10: 0(no bednet), 3(untreated bednet), 4(presumed treated bednet)】

• [x] Child Anthropometrics

  • General Observations (No need to generate "Wasting") 【hc70 and hc71 are NA】

• [x] Reproductive Health

  • Contraceptive, check modern methods 【eight modern methods：female sterilization, male sterilization, the pill, intrauterine device [IUD], injectables, implants, male condoms, and emergency contraception】
  • In Need - most updated version of logics in program (temporarily no actions needed)

• [x] Female Anthropometrics and Cancer Screening

  • Mammogram (X-ray, mamm...) 【not available, no related questions in the questionnaire】
  • Pap Smear (Cervical vaginal cytology)【not available, no related questions in the questionnaire】
  • Note recall indicators for Mamm or Pap Smear (for example, s1012n used as filter for s1012m)

• [x] Hospitalisation, NCD & HIV

  • Hospitalisation, general observations 【not available, no related questions in the questionnaire】

  • 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) 【not available in dataset, no related questions in the questionnaire】

  • 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) 【not available, no related questions in the questionnaire】

  • HIV, general observations

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

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

[jianingwwww]

Hi @robin-wang , sorry to bother you but I met with some problems when I run the codes used to merge the dataset to the microdata. I need to match them with the external iso data, which I suppose to be some external features of the country? I have searched the branch and the documents and data you shared with me, but the iso dta seems not to be in there. Would you mind showing me where I can find it and what it represents? Thank you very much!

[robin-wang]

@imarabbit Hi Jianing, thank you for your time just now. You raised very good questions!

With regard to your points on quality checking, could you please share them in writing again? I also invite @Xian152 from the Bank's side to share insights if needed.

On the actions needed after checking specific parts of the survey for data validity and coding consistency, it might be helpful when in doubt to reach out to us for clarification or discussion.

[jianingwwww]

Here are the two questions:

1. How do I understand the variables in the quality control results (i.e., value_my, value_dhs, flag_dhs, value_hefpi, flag_hefpi)? What's their formal definitions? - @robin-wang @Xian152

2. What am I suppose to do after checking specific parts of the survey? - delve into each do file and keep in touch with you if I have any questions

[Xian152]

@imarabbit Hi Jianing,

0. external iso data can be found in raw/Recode XX/external. Please remember to download the external file as well when setting up the raw datafile locally.
1. value_my are weighted average for each variables generated from the dataset. value_dhs & value_hefpi are the weighted average generated by DHS and 'old' HEFPI, extracted from an exisiting datafiles. Actually you can find more details and the generaing process of value_my, flag_dhs, flag_hefpi in Quality_control.do.
2. Theoritically, you need to check if EACH variable is generated properly according to the definition given by 'DHS Codebook.xlsx', not just for variables appear in the quality control result.
   In practice, since we are using one set of codes for all surveys from the same wave and the code for the most common/standard situation have been set up, you need to at least identify the survey-specific situation for EACH variable and adjust the code accordingly (such as different missing value, different definition of skilled provider...). The code have shown how we are dealing with survey-specific situation and those variables that vary across survey (usually by if inlist(name,"survey")....). Focusing on those variables in the early stage would help you to start easily. Also, if you could identify the mistakes in the code for would be great.

[robin-wang]

@Xian152 Thank you Xian. So very thoughtful of you!

[robin-wang]

@imarabbit Hi Jianing, I have done a quick review on your training homework, here are my notes:

1. Internal checks would be most relevant as we move forward to formal assignments.

2. Child Illness - how did you check and arrive at this list? "Check provider list being consistent with existing list (if not make changes in program) 【(?)h12a-x: chemist, homeopath, shop, hakim, Dai&Tba are NA or excluded】"

3. Child Illness - Diarrhea Med On this one, you asked about whether the two types of meds should be considered formal. We could have a small discussion on this, but what was your observation in the survey? Notably, the notes under the table?

4. Child Anthropometrics Very good that you raised hc70 and hc71 not available, even though you might referenced our earlier discussions. No actions needed on this homework specifically. In formal assignments, we would certainly have a chat about what to do.

5. Reproductive Health You did the right thing by looking at the modern methods of birth control. No need to write them all down though. Cheers.

6. Vaccination I commend you on identfying the extra vaccines. Have you searched DHS survey reports for definitions on these extra vaccines?

7. ANC

   • Did the right commentary on blood pressure/blood sample/urine sample. Exactly what we wanted to note down in writing
   • Tetanus: in theory, i would not only noting this in writing ( as you did ), but in terms of other questions or other datasets that might be used for this particular question/variable, i would advise doing so. Let's talk about this if not clear enough.

[Xian152]

@robin-wang Hi Robin, thank you for your well-summarized and detailed intrusction. @imarabbit Hi,Jianing. Glad you capture most of the survey-specific cases and find some mistakes. I have left comments on your commit in the 2 pull requests you opened