The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Reproductive Health » birth order (problem in calculating the percentages for birth order)
birth order Mon, 25 October 2021 05:40
 tlk.lem Messages: 4Registered: October 2021 Member
while I try to recategorize the birth order variable using the model data into
"1"
"2-3"
"4+"
"Don't know"
I failed to find the output (both percentage and total values) displayed in table 9.6 of the reproductive health section.
Is there any means how to arrive at the results?
Re: birth order [message #23639 is a reply to message #23638] Mon, 25 October 2021 10:13
 Shireen-DHS Messages: 140Registered: August 2020 Location: USA Senior Member
Hello,

You would use bord to recode birth order to match table 9.6 as follows:
recode bord (1=1) (2/3=2 "2-3") (4/5=3 "4-5") (6/max=4 "6+"), gen(birthor)

Then if you would like to code assistance during delivery, please use the following code also found on our code share page for this chapter in the RH_DEL.do file. Before you run this code you need to run the code in the RH_age_period.do file: https://github.com/DHSProgram/DHS-Indicators-Stata/tree/mast er/Chap09_RH

gen rh_del_pv = 9
replace rh_del_pv = 6 if m3n == 1
replace rh_del_pv = 5 if m3h == 1 | m3i == 1 | m3j == 1 | m3k == 1 | m3l == 1 | m3m == 1
replace rh_del_pv = 4 if m3g == 1
replace rh_del_pv = 3 if m3c == 1 | m3d == 1 | m3e == 1 | m3f == 1
replace rh_del_pv = 2 if m3b == 1
replace rh_del_pv = 1 if m3a == 1
replace rh_del_pv = 9 if m3a == 8 | m3a == 9
replace rh_del_pv = . if age>=period

label define pv ///
1 "Doctor" ///
2 "Nurse/midwife" ///
3 "Country specific health professional" ///
5 "Relative/other" ///
6 "No one" ///
9 "Don't know/missing"
label val rh_del_pv pv
label var rh_del_pv "Person providing assistance during delivery"

Then to match the table you can use the following:
gen wt=v005/1000000
ta birthor rh_del_pv [iw=wt], row

Best,
Shireen Assaf
The DHS Program

Re: birth order [message #23645 is a reply to message #23639] Tue, 26 October 2021 08:00
 tlk.lem Messages: 4Registered: October 2021 Member
Hi Shireen,

Thank you so much for your swift and worthwhile response. It is very helpful and helps me resolve my difficulties. Your additional information and the attached link are also very important. Through the link I have been able to get access to the .do files of the whole chapters, I had no idea about its availability. I am now exercising all the .do files for _ANC, _DEL, and _TABLES. I will revert to you if I need more support.

kind regards,
tlk.lem
Re: birth order [message #23646 is a reply to message #23645] Tue, 26 October 2021 08:43
 Shireen-DHS Messages: 140Registered: August 2020 Location: USA Senior Member
Hello,

as well as the main do file for each chapter before running any do file to calculate indicators.

Best,
Shireen Assaf
Re: birth order [message #23652 is a reply to message #23646] Wed, 27 October 2021 08:59
 tlk.lem Messages: 4Registered: October 2021 Member
Hello,

Sure I will do. I have downloaded all of the folders and is now working on them. I am familiarizing myself with those .do files for chapter 9, starting right from the !RHmain. I think I might be needing some more support as some of .do files I run produced results somehow different from the published report in the tables. Hope you will be available for more support.

kind regards,
tlk.lem
Re: birth order [message #23653 is a reply to message #23652] Wed, 27 October 2021 09:11
 Shireen-DHS Messages: 140Registered: August 2020 Location: USA Senior Member
Hello,

Please post your question and we will try to answer it as soon as we can. Please be clear on what table your are not matching and the data file you are using.

Note that some indicators are country specific and you will need to read the footnote in the tables to adjust the standard code. For instance for ANC, skilled provider differs from country to country. Be sure to check if this is the reason you are not matching the report.

Best,
Shireen Assaf
The DHS Program
Re: birth order [message #23668 is a reply to message #23653] Fri, 29 October 2021 10:32
 tlk.lem Messages: 4Registered: October 2021 Member
Hello,

Thank you for your response with valuable information supported by the example I am interested in. I am currently working on the model dataset to get familiar with the process of developing the tables. Once I have learned how they are constructed I will move to a specific country case, the case of Ethiopia.

one more support I need is on developing Table 9.8 and 9.10. The way the providers coded in the .do files and displayed in the table is somehow different and I could not resolve the differences. The codes used in the .do file is different from those indicated in the model dataset.

kind regards
tlk.lem
 Previous Topic: Health Service provision for females living with FGM/C Next Topic: Matching Variables from IDIR and IDOD for 2002, 2007, 2012, 2017
Goto Forum:

Current Time: Mon Sep 16 19:30:39 Coordinated Universal Time 2024