Senegal2018

[wengxyu1030]

WORKFLOW DOC

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

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

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

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

• [x] Child Illness

  • 20210510 For Providers, focus on the skilled providers rather than all
  • Diarrhea treatment provider
  • c_diarrhea_pro formal provider list: government hospital, cs public health center, private hospital/clinic
  • Check provider list being consistent with existing list (if not make changes in program)
    • didn't make changes in the codes
  • Fever/Ari1/Ari2 treatment provider
    • formal provider list: government hospital, cs public health center, private hospital/clinic
  • Provider list being consistent with existing list
  • didn't make changes in the codes
  • 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 [may I know what medicines should be treated as special here?]
  • h15 given antibiotic pills or syrups,h15a given antimotility, h15b given antibiotic injection, h15c given intravenous (iv), h15d given home remedy, herbal medicine, h15e given zinc, h15f given other, h15g given unknown pill or syrup, h15h given non-antibiotic injection, h15i given unknown injection
  • c_diarrhea_medfor, medicine and formal meds to treat are survey-specific. 20210510 focus on special medicines
    • h15 given antibiotic pills or syrups,h15a given antimotility, h15b given antibiotic injection, h15c given intravenous (iv), h15e given zinc, h15g given unknown pill or syrup, h15h given non-antibiotic injection, h15i given unknown injection
  • 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)

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

  • 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

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

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

  • [ ] Successfully produced the indicators: the survey is too new, and there is no relevant surveyid in the HEFPI.dta or DHS.dta.
  • [ ] Check if there's a flag that the indicator value produced is too off from the published data

[robin-wang]

RW PARALLEL TEST SENEGAL2019

A. General Procedural Steps

• [x] Run script without error
• [ ] Pass other internal testing
• [ ] Document as comments any materials referenced (in addition to survey documentation)
• [ ] 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

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

[yining-sun]

Senegal2018

Document as comments any notable changes/caveats (if any)

Changed the 13_adult.do to resolve the variable duplication problem and run smoothly.

• [x] ANC

  • Skill providers
  • p.336 doctor, midwife, nurse/ICP
  • Tetanus Injection
  • Number of Injection Before/During Pregnancy: both exist
  • Recall period for last injection: last birth only
  • Relevant data comes other sections: no
  • Blood Pressure / Blood Sample / Urine Sample
  • Samples (m42c/d/e) are sub-questions for "receive antenatal care" in questionnaire or not: subquestions of Q413 (p.337)

• [x] Delivery Care

  • c_facdel / delivery institutions / c_hospdel / delivery institutions
  • Consistent with the regular expression section in Programs: Q430 (p.342)
  • c_skin2skin
  • Check if available; if, then note which variable. Available, m77
  • 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, 12) delivery location (Q430) is a filter question for m77 skin to skin (Q 434) p.342

• [x] PNC

  • child pnc
  • See if child pnc is only avaliable when (m15=11,12,96) or (m15!=11,12,96). No, child PNC is available to the whole sample. Q438, p.343
  • 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. Full sample

• [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. (Measles 1)
  • Other vaccines, if any, h9a (Measles 2)

• [x] Child Illness

  • Diarrhea treatment provider: government hospital, cs public health center, cs public health post, cs clinic mobile, cs health worker, cs others public, private hospital.clinic, private pharmacy, private doctor, cs private clinic mobile, cs private health worker, cs private other sector, cs shop, cs traditional pratician, cs market, cs drugs vendor.
  • Check provider list being consistent with existing list (if not make changes in program)
  • Fever/Ari1/Ari2 treatment provider: h32a-x government hospital, health center, health post, Clinique mobile, health worker, cs other public sector, private hospital/clinic, private pharmacy, private doctor, clinic mobile, community health worker, other private sector, shop, traditional practitioner, market, drugs vendor, other
  • Provider list being consistent with existing list
  • Fever/Fever Treatment/Cough/Cough Treatment from Full Sample: yes
  • c_diarrhea_med, medicine and formal meds to treat are survey-specific: h15 given antibiotic pills or syrups,h15a given antimotility, h15b given antibiotic injection, h15c given intravenous (iv), h15d given home remedy, herbal medicine, h15e given zinc, h15f given other, h15g given unknown pill or syrup, h15h given non-antibiotic injection, h15i given unknown injection
  • c_diarrhea_medfor, medicine and formal meds to treat are survey-specific: h15 given antibiotic pills or syrups,h15a given antimotility, h15b given antibiotic injection, h15c given intravenous (iv), h15e given zinc, h15g given unknown pill or syrup, h15h given non-antibiotic injection, h15i given unknown injection
  • Validate c_ari can be generated or not: generated

• [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 available, only treated bednet

• [x] Child Anthropometrics

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

• [x] Reproductive Health

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

• [x] Female Anthropometrics and Cancer Screening: indicators 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: no observations

  • Hospitalisation, general observations: no obs

  • 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) checked all the data sources, none is available

  • 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): no obs

  • HIV, general observations: no obs

  • 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

[wengxyu1030]

@yining-sun Thanks for the update. The code works smoothly and well on my end..

I was checking the quality checking result in the OneDrive folder: \OneDrive\MEASURE UHC DATA\STATA\DATA\SC\INTER, there's no observation for the produced file quality_control-Senegal2018.dta, I found the reason is that because the DHS public website hasn't updated the indicator stats yet, so there's no public data available to be compared.

[yining-sun]

@yining-sun Thanks for the update. The code works smoothly and well on my end..

I was checking the quality checking result in the OneDrive folder: \OneDrive\MEASURE UHC DATA\STATA\DATA\SC\INTER, there's no observation for the produced file quality_control-Senegal2018.dta, I found the reason is that because the DHS public website hasn't updated the indicator stats yet, so there's no public data available to be compared.

@wengxyu1030 Thanks Aline. I replied to the data whale email stream earlier and I was not sure if you were cced. I will make sure to comment on Github next time.

[yuqiliao]

It seems that this issue is resolved and merged to master (https://github.com/wengxyu1030/DHS-Recode-VII/pull/8), and therefore can be closed. Please feel free to open it if there are any follow-up comments/action items. Thanks!

[Xian152]

@yining-sun @robin-wang Comments: 1.do - ANC You record the skilled provider for anc and sba properly but it seems to me that it is not reflected in the code. As I am thinking the the m2h(auxiliary midwife (matrone)) refers to "MATRONE ACCOCHEUSE TRADITIONNELLE" in the questionnaire, which regarded as not skilled. As "midwife" is an important key words for general skilled provider, I don't suggest to change the key words list. You can make it survey specific: if inlist(name,"Senegal2018"){ replace m2h=. } this also applies to c_sba and m3h

2.do -Delivery Care Don't worry about m15 and m77. Actually m15 (Q430) is not a filter question for m77 (Q434), as the questionnaie says "skip to 434", m77(Q434) happends to be the first question not effected by the filter question Q430.

7.do -Child Vaccination: Actually the survey have record of a vaccine svpi, which is IPV. (By using "lookfor receive", it is really hard to miss any vaccine variables in the datafiles ;) ). We need to double check with Sven whether this should be counted as a dose of polio, and if so, how we want to that. So is mealse2.

11.do: -Sleeping Under Bednet ml0=2 "both treated and nontreated". I think we should counted as ITN.

Suggestion about the record of the survey details: 8.do -Child Illness: h12 & h32: I noticed that you record all providers for h12 and h32. I think there is not need for that. Actually if it is time consuing, you don't need to list out the providers. Suppose if we want a list, I would say recording the skilled provider rather than all of them might be more informative. med & medfor: no need to record everything about the medicine, just the special medicines would be fine. Luckily, Senegal2018 is so standardized that they don't collect any speical medicine.

[wengxyu1030]

Thanks, Xian, your comment is helpful.

• I see your pull request where you made changes that reflecting your comments. I have merged these changes to the master branch.

• Some outstanding issue is pending as we are waiting for Sven's comments.

• At the same time, @robin-wang is working on refining the checklist, I believe he;'s incorporating your comments accordingly.

[robin-wang]

Update: Template updated based on comments from Xian and Aline.

@yining-sun Could you please amend based on Xian's instructions in comments above? Please note that the checklist has been lightly updated. CHILD ILLNESS section has updated instructions for you.

Additionally, three notes on vaccination and women's education level:

1. Vaccination: Senegal2018&2019 collect one dose of IPV separately from regular 3 doses of polio OPV. The report says nothing about how they treat this dose of IPV. Should we count it as a dose of polio to c_polioX? i.e. polio1->polio2, polio2->polio3, etc.

Let's ignore the IPV one, that’s also what the report seems to do. We might want to check irregular ways by which vaccination information is stored in the future.

2. Vaccination: Senegal2018&2019 collect data on measles2. There exist some observations that the child didn’t receive measles1 but received measles2 (not much, 6 cases in 2018, 15 cases in 2019). If these kids are also 15-23 months old, let’s count them as having received measles1 since we are sure they received at least one shot of measles at the age we are interested in.

3. V106(woman’s education level). Usually this variables only have value 0(no education), 1(primary), 2(secondary),3(higher). In Senegal2019, there exist V106=6(other), but the data doesn’t record the exact education level for “other”. This might be more pertinent for Senegal2019, but please make sure "Other" are treated as missing. Many thanks!

[yining-sun]

@robin-wang @Xian152 @wengxyu1030

Dear all,

I have updated the codes for senegal2018 and senegal2019 accordingly, and also updated my comments on the Child Illness section. Let me know if you have any other questions or changes that I should make.

One question about the child illness, what should be counted as special medicines? As I look into the do-file, almost every medicine (no matter country specific or not) is examined during the process.

[robin-wang]

@yining-sun GREAT WORK! Thanks for your update. I think Senegal 2018/19 might not require another look at special medicines. Xian shared that these two surveys are relatively standardised on that matter.

8.do -Child Illness: h12 & h32: I noticed that you record all providers for h12 and h32. I think there is not need for that. Actually if it is time consuing, you don't need to list out the providers. Suppose if we want a list, I would say recording the skilled provider rather than all of them might be more informative. med & medfor: no need to record everything about the medicine, just the special medicines would be fine. Luckily, Senegal2018 is so standardized that they don't collect any speical medicine.

[wengxyu1030]

The issues raised by Xian are resolved in the new pull request and merged to master, and therefore can be closed. Please feel free to open it if there are any follow-up comments/action items. Thanks!

[wengxyu1030]

@yining-sun updated the code in pull request #14 and @wengxyu1030 has reviewed and merged to the master.