SierraLeone2013-JW

[robin-wang]

WORKFLOW DOC

{FOR REVIEWERS}

• [ ] They can run the code smoothly on the reviewer's end, where the microdata could be generated without error
• [ ] 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)

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

B. Checklist and Guidance

• [x] ANC

  • Skill providers【doctor, nurse or midwife, or Maternal and Child Health Aide】
  • Checked in the regular express section in Programs
  • Tetanus Injection【not available】
  • Number of Injection Before/During Pregnancy
  • Recall period for last injection
  • Relevant data comes other sections
  • Blood Pressure / Blood Sample / Urine Sample【not available】
  • Samples (m42c/d/e) are sub-questions for "receive antenatal care" in questionnaire or not

• [x] Delivery Care【not available】

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

• [x] PNC【not available】

  • 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

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

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

• [x] Child Illness

  • 20210510 For Providers, focus on the skilled providers rather than all
  • 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. 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

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

• [x] Child Anthropometrics

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

• [x] Reproductive Health【not available】

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

• [x] Female Anthropometrics and Cancer Screening【not available】

  • 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] Hospitalisation, NCD & HIV【not available】

  • 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

[jianingwwww]

Sierra Leone2013 is not available (the type of data is DHS, not MIS).

[robin-wang]

Hi Jianing, could you please take a look to see if MIS related datasets are in place for SierraLeone2013? Thanks!

[jianingwwww]

Hi Jianing, could you please take a look to see if MIS related datasets are in place for SierraLeone2013? Thanks!

Thank you for the suggestion! SierraLeone2013 DHS also has MIS related datasets (birth/household/household member/children.dta) and I will give a try.

[jianingwwww]

Hi @robin-wang , I have some questions about this survey when I try to match it with public data. I can only find the public data of DHS, not MIS (i.e., SL2013DHS). DHS data can also be matched, of course, but then it will generate lots of missing values in the quality check result, given that the DHS contains 58 variables, whilst the MIS contains only 4 variables. The only way to avoid these missing values is to transform all the codes into DHS codes. But it seems weird in this MIS repository (and time-consuming). So should I make this change? or just leave it and not generate the quality control file?

[robin-wang]

Hi Jianing @jianingwwww Two options, choose the one you feel makes most sense.

1. Screenshot the public data values, and compare that against our values. this might mean some manual tabulations.
2. Just go ahead and take the DHS data, disregard the missing variables. Leave a note, and that will do.

[jianingwwww]

I matched the public data with our values manually. This is the quality control result I uploaded to the OneDrive, but it cannot be generated automatically by codes.

m14 for c_anc and ml0 for c_ITN tabulated but no problem found.

[robin-wang]

@wengxyu1030 Hey Aline, re anc visits, based on the data we have, it is unlikely that the public data value of 76 could be replicated. Thoughts?

[wengxyu1030]

Dear @robin-wang and @jianingwwww, thanks for the question.

If there's no MIS however only DHS data, please use the DHS template instead of the MIS template. As the DHS microdata has been generated accordingly, this MIS template-generated microdata would only be a subset of it, which I will delete to avoid confusion.

Talking about the c_anc and c_ITN, comparing to the HEFPI public statistics, it's not flagged. Considering the methodology between DHS and HEFPI is slightly different, we would prioritize the comparison to HEFPI public data but also keep in mind the difference for future references.

Regards, Aline

[robin-wang]

Thanks @wengxyu1030 I guess this issue should be closed.

@jianingwwww Hats off to your hard work on the MIS series. No need to upload micro-data. We will share further instructions on the DHS repository if you are open to carrying through with DHS-SierraLeone2013 ?

[jianingwwww]

We will share further instructions on the DHS repository if you are open to carrying through with DHS-SierraLeone2013 ?

@robin-wang Sure, I'd love to start with DHS-SierraLeone2013 in the DHS repository~

[robin-wang]

Okay, thanks! I'll confirm with World Bank team first; if they have done DHS SL2013, then we don't have to reinvent the wheel. Will keep you posted.