The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Reproductive Health » % Consanguinity Jordan 2017/18 and 2012 (Calculating different % than the ones in the final report)
% Consanguinity Jordan 2017/18 and 2012 Sun, 03 January 2021 03:20
 olympiaca Messages: 6Registered: January 2021 Member
Hi,

I happened to calculate myself the % of marriages that are consanguineous by region in the Jordan DHS 2017/18 as well as 2012.

However, I am receiving different results to what is presented in table 4.4 in the 2017 and 2012 final reports.

For example, for Amman 2017 using the S711A (whether blood related) and V024 (governorate region) variables the dataset tells me that 25.11312% of marriages are between blood relatives. However, table 4.4 states that it is 24.4%.

Additionally I have also calculated the % of marriages that are a first cousin on the father's side (ibn al amm). Again I get different percentages. For example for Amman 2017 I got that the proportion of blood related marriages that are 'ibn al amm' is 0.290540541 which if you multiply it by the proportion of marriages that are between blood relatives (0.2511312) gives you a an proportion of 0.07296379 - 7.296% of all marriages in Amman are between first cousins on the father's side (ibn al amm). However table 4.4 states that it is 7.0%.

It is not just Amman for which I get different results but for all the regions and for 2017 and 2012. Is consanguinity defined in a different way in the final report?

Many thanks
Olympia

Re: % Consanguinity Jordan 2017/18 and 2012 [message #21875 is a reply to message #21862] Mon, 04 January 2021 15:40
 Shireen-DHS Messages: 104Registered: August 2020 Location: USA Senior Member
Hello,

Working with the 2017 data, I am able to match the final report with the Stata code found below.
I think perhaps you have forgotten to weight the data. You need to apply weights to match the final report tables.

Thank you.
Best,
Shireen Assaf
The DHS Program

Stata code:

gen consang=s711b
replace consang=0 if s711a==0
label values consang S711B

gen wt=v005/1000000

ta s711a [iw=wt]
ta consang [iw=wt]

*by region
ta v024 s711a [iw=wt], row

*get get ibn al amm, see category #3
ta v024 consang [iw=wt], row
Re: % Consanguinity Jordan 2017/18 and 2012 [message #21882 is a reply to message #21875] Tue, 05 January 2021 03:28
 olympiaca Messages: 6Registered: January 2021 Member
Of course.. the weights. I knew there was something i was missing.

Thank you so much for the code.

Olympia
Goto Forum:

Current Time: Sat Dec 4 23:47:24 Coordinated Universal Time 2021