| 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
|
|
|
|
| Re: DRC merge individuals records contained in household data to child data [message #13527 is a reply to message #13521] |
Tue, 14 November 2017 13:54  |
Bridgette-DHS
Messages: 3214
Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS Stata Specialist, Tom Pullum:
You should use the PR file, not the HR file. The PR file has one record per individual in the household, rather than one record per household, and is much easier to use. In the KR file, the id variables v001, v002, b16 should be matched with hv001, hv002, and hvidx in the PR file. Some of the variables you want may already be in the KR file. However, I just looked and it appears that some or most of them are not. Only 65 children are reported to have symptoms of jaundice. This may not be enough cases for a useful analysis.
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
