The DHS Program User Forum: Domestic Violence

Home » Topics » Domestic Violence » Discrepancies in results

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

Discrepancies in results [message #24589]

Sat, 04 June 2022 06:50

Mason92
Messages: 33
Registered: December 2021

Member

Hello,

For Pakistan DHS 2012-13 and 2017-18, the proportions for emotional and physical violence reported in the country reports are different from the ones I am getting, by provinces, as well as by provincial urban/rural residency status.

Please see attached the table where, discrepancies are specified in red color, between the results I got, and the ones reported in country reports; Pakistan DHS 2012-13, table 14.6 on page 228, and for Pakistan DHS 2017-18, table 16.10 on page 319.

I did use the correct survey weights i.e. [d005 / 1000000].

Please guide.
Thanks

Attachment: Discrepancies.docx
(Size: 17.44KB, Downloaded 249 times)

Report message to a moderator

Re: Discrepancies in results [message #24603 is a reply to message #24589]

Mon, 06 June 2022 16:26

Janet-DHS
Messages: 888
Registered: April 2022

Senior Member

Thank you for submitting your question. Could you please let us know which software you are using (Stata, SPSS, R, etc.)?

If you can share your code with us this will make it easier to look into where the mismatch is coming from.

Report message to a moderator

Re: Discrepancies in results [message #24608 is a reply to message #24603]

Tue, 07 June 2022 12:39

Mason92
Messages: 33
Registered: December 2021

Member

I am using Stata; for Pakistan DHS 2017-18, most (not all though) of my results match exactly with the ones provided in the country report. But for Pakistan DHS 2012-13 there are lots of discrepancies.

My code is attached.

Kindly guide.

Thanks

Attachment: __code_used.docx
(Size: 14.35KB, Downloaded 230 times)

Report message to a moderator

Re: Discrepancies in results [message #24643 is a reply to message #24608]

Mon, 13 June 2022 11:08

Janet-DHS
Messages: 888
Registered: April 2022

Senior Member

Following is a response from Senior DHS Specialist, Kerry MacQuarrie:

The issue is a very small one. In 2012-13 Pakistan DHS, the "ever experienced emotional violence by spouse" and "ever experienced physical violence by spouse" variables have 1-2 cases that are coded as 9 (declined to answer). See below:
/index.php?t=getfile&id=1862&private=0

In the DHS construction of the variable, these cases are included in the denominator, but not the numerator. In your code, these cases are excluded from both the numerator and denominator (set to missing). If you recode them as "no" (ie, include them in the denominator), the results match those in the DHS final report tables. The following code does exactly that and works for both survey years:

*emotional violence
recode d104 (9=0),g(ev)

*physical violence
gen pv=d106
replace pv=1 if d107==1
recode pv(9=0)

The discrepancy you are getting in the 2017-18 survey results is a matter of the difference in the way Stata versus the program DHS uses to run Final Report tabulations handles rounding, e.g. 21.25 will get rounded down to 21.2 instead of rounded up to 21.3.

Attachment: Response 24589.png
(Size: 14.72KB, Downloaded 577 times)

Report message to a moderator

Re: Discrepancies in results [message #24650 is a reply to message #24643]

Tue, 14 June 2022 12:34

Mason92
Messages: 33
Registered: December 2021

Member

Thank you so, so very much indeed.

Report message to a moderator

Re: Discrepancies in results [message #24708 is a reply to message #24643]

Sat, 25 June 2022 14:00

Mason92
Messages: 33
Registered: December 2021

Member

Thanks again, but I notice that for 2012-13 Pakistan DHS, the urban and rural provincial indices for intimate partner violence are flipped. I am getting exactly the same proportions for emotional and physical violence by provincial urban rural residency status, but my urban proportions match with the rural proportions and vice versa, based on variable v023 coding.

Please guide.

Thanks

Report message to a moderator

Re: Discrepancies in results [message #24719 is a reply to message #24708]

Tue, 28 June 2022 09:38

Janet-DHS
Messages: 888
Registered: April 2022

Senior Member

Following is a response from Senior DHS Specialist, Kerry MacQuarrie:

Attached is the full code that I ran and which produces estimates matching Table 14.6 on p.228 of the Pakistan DHS 2012-13 final report. I hope this helps!

Stata code:
use "C:\DHSdata\PKIR61FL.DTA", clear
gen wt=d005/1000000

lab def yesno 1 "Yes" 0 "No"

*emotional violence
recode d104 (9=0),g(ev)
lab var ev "Ever experienced spousal emotional violence"
lab val ev yesno

*physical violence
gen pv=d106
replace pv=1 if d107==1
recode pv(9=0)
lab var pv "Ever experienced spousal physical violence"
lab val pv yesno

ta v025 ev [iw=wt], row
ta v023 ev [iw=wt], row
ta v025 pv [iw=wt], row
ta v023 pv [iw=wt], row

Output:
/index.php?t=getfile&id=1871&private=0

Attachment: Response 24589 1.png
(Size: 10.31KB, Downloaded 565 times)
Attachment: Response 24589 2.png
(Size: 25.83KB, Downloaded 560 times)
Attachment: Response 24589 3.png
(Size: 9.25KB, Downloaded 425 times)
Attachment: Response 24589 4.png
(Size: 24.90KB, Downloaded 567 times)

Report message to a moderator

Re: Discrepancies in results [message #24735 is a reply to message #24719]

Thu, 30 June 2022 13:44

Mason92
Messages: 33
Registered: December 2021

Member

Thank you so very much, I am very grateful.

Report message to a moderator

Previous Topic:	India DHS 2019-21: Mismatch in number of observations
Next Topic:	India- NFHS-4 Discrepancy in getting data data on ever experienced physical violence

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Nov 23 22:23:40 Coordinated Universal Time 2024