The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Linking variables from SA 1998 HR, PR & IR files to Adult Health respondents (Linking variables from SA 1998 HR, PR & IR files to Adult Health respondents)
Linking variables from SA 1998 HR, PR & IR files to Adult Health respondents [message #16333] Fri, 14 December 2018 12:05 Go to next message
kafuia is currently offline  kafuia
Messages: 2
Registered: May 2014
Member
I am trying to link variables from the household recode, person's recode, and individual recode (women's survey) files to the Adult Health (AH) file in the South Africa 1998 DHS. The Adult Health survey included male and female household members aged 15 years and over. However, the adult health file contains the ea number, cluster number, household number and a variable called 'qline' as identifiers. Qline is described as 'line number of woman'. There is not a variable called 'respondent's line number' in that file, such as v003, hv003, hvidx or index to the household schedule (idx4) that appear in the other files. Is the variable qline in fact supposed to be the same as the 'respondent's line number' and was just mis-labelled? Or does it only represent the line number of the woman in the household who participated in the women's survey? If so, how can we link variables from the HR and PR files to respondents in the AH (adult health) file, and how can we link data from individuals in the files to the data for members listed in the household schedule? Is there another variable that can be used to link the individuals across files so that analyses can include variables from different files?

Thank you
Re: Linking variables from SA 1998 HR, PR & IR files to Adult Health respondents [message #16334 is a reply to message #16333] Fri, 14 December 2018 14:56 Go to previous message
kafuia is currently offline  kafuia
Messages: 2
Registered: May 2014
Member
I think I have figured it out. It looks like the variable was actually mis-labelled, and the qline variable in the adult health file is in fact the same as the respondent's line number in the other files (not just the woman's line number).

Previous Topic: Identifying parental education for women's age cohort 15-49
Next Topic: husbands to their wives
Goto Forum:
  


Current Time: Fri May 24 01:49:07 Eastern Daylight Time 2019