The DHS Program User Forum: Merging data files » Merging IR and PR 2016 UDHS

Home » Data » Merging data files » Merging IR and PR 2016 UDHS (Matching a variable from IR and PR give wrong number of women)

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

Merging IR and PR 2016 UDHS [message #19996]

Sat, 12 September 2020 06:32

gusblocaq
Messages: 1
Registered: September 2020

Member

I have managed to merge IR and PR one to one (thought IR should be base, have also tried PR as base to see the difference). I am looking into the variables of "Getting medical help for self" and want to assess the perceived barriers with disability (PR file only). When merged it looks alright, I am getting the number of women answered "getting medical help" to 18505 which is in line. Number of women 15-49 who answered the disability module is a bit more which makes sense. Problem is when you match them (cross-tabulation) the number of women reduces to 8560. What could I be doing wrong?

I've tried everything I have found on websites and forums etc when it comes to merging (using v001, v002,v003) and tried to limit the PR dataset to only contain women age 15-49 but I am still getting the same result. I also tried merging one to many (using v001, v002, v003) but it don't work, get the error.

I would assume the women in IR will be in the PR so honestly a bit confused to why it doesn't work?

Thanks in advance!
Camilla

Report message to a moderator

[Message index]

		Merging IR and PR 2016 UDHS By: gusblocaq on Sat, 12 September 2020 06:32
		Re: Merging IR and PR 2016 UDHS By: Bridgette-DHS on Tue, 15 September 2020 07:44

Previous Topic:	Weighing countries in a multi-country study
Next Topic:	How to merge a person-level data with a child-level data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Apr 25 05:59:21 Coordinated Universal Time 2024