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
|
|
|