The DHS Program User Forum: Reproductive Health

Home » Topics » Reproductive Health » birth order (problem in calculating the percentages for birth order)

Show: Today's Messages :: Show Polls :: Message Navigator

birth order [message #23638]

Mon, 25 October 2021 05:40

tlk.lem
Messages: 4
Registered: 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?

Report message to a moderator

Re: birth order [message #23639 is a reply to message #23638]

Mon, 25 October 2021 10:13

Shireen-DHS
Messages: 140
Registered: 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" ///
4 "Traditional birth attendant" ///
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

Report message to a moderator

Re: birth order [message #23645 is a reply to message #23639]

Tue, 26 October 2021 08:00

tlk.lem
Messages: 4
Registered: 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

Report message to a moderator

Re: birth order [message #23646 is a reply to message #23645]

Tue, 26 October 2021 08:43

Shireen-DHS
Messages: 140
Registered: August 2020
Location: USA

Senior Member

Hello,

You're welcome. Please read the instructions on the main page: https://github.com/DHSProgram/DHS-Indicators-Stata
as well as the main do file for each chapter before running any do file to calculate indicators.

Best,
Shireen Assaf

Report message to a moderator

Re: birth order [message #23652 is a reply to message #23646]

Wed, 27 October 2021 08:59

tlk.lem
Messages: 4
Registered: 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

Report message to a moderator

Re: birth order [message #23653 is a reply to message #23652]

Wed, 27 October 2021 09:11

Shireen-DHS
Messages: 140
Registered: 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

Report message to a moderator

Re: birth order [message #23668 is a reply to message #23653]

Fri, 29 October 2021 10:32

tlk.lem
Messages: 4
Registered: 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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jun 20 16:13:39 Coordinated Universal Time 2025