The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merging Palestine
Merging Palestine [message #9857] Tue, 31 May 2016 22:17 Go to previous message
alburezg is currently offline  alburezg
Messages: 3
Registered: May 2016
Member
Hi, I am using the Palestinian 2004 DHS, which, I am aware, is not an official DHS. Still, I though that someone might be able to help. Sadly, the variable names do not follow standard DHS conventions, which is evident in my explanation below.

I am trying to merge the children's vaccination data (in file vaccination) with their mothers demographic data. This should be a trivial task since there is supposed to be a variable linking the vaccination data to the birth history records. The question IM02 in the questionnaire recorded the "line number of the individual in the birth history", but this variable is not available in the "vaccination" file. I spent a couple of hours trying to find the variable or another way of finding the mother's data for the children in the vaccination file, but I was unable to find a direct way. I can link the records in the "vaccination" file with the HH roster data via the idh00 variable (questionnaire number) and the hr01 variable (line number in household). But all I can gather from this is that the children live in the same household as the mother, not who is the child of whom.

In summary, I am sure the files should be linked through a common variable. The relevant variable linking the vaccination data to the birth history (IM02) was asked in the questionnaire but is for some reason missing from the data.

Has anyone worked with these data before or has any suggestions on this?
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Dropping cases with HIV05 missing in SPSS
Next Topic: merging household and individual data
Goto Forum:
  


Current Time: Sun Dec 22 03:54:44 Coordinated Universal Time 2024