The DHS Program User Forum: Merging data files » DRC merge individuals records contained in household data to child data

Home » Data » Merging data files » DRC merge individuals records contained in household data to child data

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

DRC merge individuals records contained in household data to child data [message #13521]

Mon, 13 November 2017 16:25

mcarrel
Messages: 2
Registered: November 2017

Member

Hello,
The DRC 2013 DHS included several indicators of healthcare usage, jaundice (the jaundice variables are listed as SH318F_01 to SH318F_20) and vaccination in the HR file. The HR file also lists individual line numbers as HVIDX_01--HVIDX_20. I want to merge the information about individual children's vaccination and jaundice status from the HR file to the KR file. I cannot determine how to create a new, unique ID from the HV001, HV002 and the 20 HVIDX or 20 SH318F variables in the household records that will match the V001+V002+V003 ID in the KR file. Please advise on how best to go about this, I could not find an example of this in earlier postings. SAS code would be great.
Thanks,
MC

Report message to a moderator

[Message index]

		DRC merge individuals records contained in household data to child data By: mcarrel on Mon, 13 November 2017 16:25
		Re: DRC merge individuals records contained in household data to child data By: Bridgette-DHS on Tue, 14 November 2017 13:54

Previous Topic:	merging household data with female data
Next Topic:	Merging the child, household and wealth file for Philippines 1998

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Dec 24 08:10:48 Coordinated Universal Time 2024