The DHS Program User Forum: Merging data files » Merging data from woman (individual) with verbal autopsy

Home » Data » Merging data files » Merging data from woman (individual) with verbal autopsy

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

Merging data from woman (individual) with verbal autopsy [message #10105]

Mon, 27 June 2016 18:43

lyang52@jhu.edu
Messages: 3
Registered: June 2016
Location: Baltimore

Member

I'm using the Afghanistan 2010 standard DHS and Verbal Autopsy data. I want to merge the woman's data file with verbal autopsy data file (containing deceased children). But it seems that they can only be matched on household level. Do they have some linking variables that could be used to match them individual by individual?

Thanks

Report message to a moderator

Re: Merging data from woman (individual) with verbal autopsy [message #10111 is a reply to message #10105]

Tue, 28 June 2016 14:08

Trevor-DHS
Messages: 802
Registered: January 2013

Senior Member

See qh308 in the verbal autopsy data which gives the line number of the mother and can be used (in conjunction with the cluster and household number) to match to the women's data.

Report message to a moderator

Re: Merging data from woman (individual) with verbal autopsy [message #10147 is a reply to message #10111]

Thu, 30 June 2016 22:40

lyang52@jhu.edu
Messages: 3
Registered: June 2016
Location: Baltimore

Member

What about linking the Children's data to the Verbal Autopsy data? Do they have some variables in common that could be linked one by one?

Thanks a lot

Report message to a moderator

Re: Merging data from woman (individual) with verbal autopsy [message #10164 is a reply to message #10147]

Fri, 01 July 2016 14:41

Trevor-DHS
Messages: 802
Registered: January 2013

Senior Member

The data on the verbal autopsy are collected based on the identification of deaths in the household in the few (five?) years preceding the survey. However with the cluster number, household number and line number of the mother it should be possible to identify the children. Most women will have no more than one child who died in the time period. You also have the age at death in qh305 and the sex in qh306 that you may be able to match to q323 and q315 in the women's data. For those with two or more children who died you may be able to use other information to identify the matching child. It is probably not going to be perfect, but you should be able to get a match in the vast majority of matching cases (I haven't tried this, but it looks possible).

Report message to a moderator

Re: Merging data from woman (individual) with verbal autopsy [message #13871 is a reply to message #10164]

Tue, 16 January 2018 20:13

chr8850
Messages: 20
Registered: July 2016

Member

Hi there,

I am also trying to merge the VA file with the women's file in the AMS 2010 datasets. As I want to look at all the births including stillbirths i could not use qh305 or qh306 i the women's file. I have tried merging using cluster, hh and woman's line number as well either date of death (qv305f from VA and 322c & 324c in women's) or date of birth (qv303f and q317c& 324c from women's). I keep getting 116 cases that do not merge and it seems some of the dates from the women's file and the VA file do not match. Do you have any suggestion how to manage this and why the dates would not match?

thanks

Report message to a moderator

Re: Merging data from woman (individual) with verbal autopsy [message #14045 is a reply to message #13871]

Tue, 06 February 2018 12:09

Trevor-DHS
Messages: 802
Registered: January 2013

Senior Member

Can you include your code so that we can review where the issues are?

Report message to a moderator

Previous Topic:	Merging children to their mothers
Next Topic:	Merging Child and Household Data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 8 06:36:43 Coordinated Universal Time 2024