The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Biomarkers » Merging Women's and Men's File
Merging Women's and Men's File [message #24991] Tue, 16 August 2022 01:28 Go to previous message
parul is currently offline  parul
Messages: 1
Registered: May 2022
Dear DHS User Forum,

Dataset: National Family Health Survey (IAIR7ADT, IAKR7ADT, and IAPR7ADT)
Year: 2019-21
Country: India

For my research objective, I want to identify pairs of siblings (all siblings in one household), mother-child pairs (including all possible children a mother has), father-child pairs (including all possible children a father has), mother-father pairs, and parent-child pairs (including all possible children parent have). Thus, I need information on mothers, fathers, and all their kids in one row.

I have been using the women's file, as it already has all kids a mother has in one row. Thus, only information from men remains to be merged. However, the men's file did not include information on height and weight. So, I merged the person's file and the men's file.

Now I am trying to merge the (men's+person's) file to the women's file. However, I am unable to do so. Although there is an already existing couple's file available in the dataset, it does not contain any information that I need. As one man can have more than one wife, I am using m:1 merging. I have attached the codes that I have been using.

I have already searched the existing queries posted in the DHS User Forum. However, none of them addresses the issue I have. I would request you to please have a look at my query and please suggest a way out. If you need any additional information on the issue, please write back.


  • Attachment:
    (Size: 3.24KB, Downloaded 157 times)

[Updated on: Tue, 16 August 2022 04:58]

Report message to a moderator

Read Message
Read Message
Previous Topic: HT/age standard deviations in DHS India 1998-1999
Next Topic: Hypertension
Goto Forum:

Current Time: Mon Jun 17 05:43:38 Coordinated Universal Time 2024