| Re: Wealth Index for Indonesian Adolescents Survey 2017 [message #27925 is a reply to message #27456] |
Mon, 23 October 2023 06:09  |
charleswinfrey
Messages: 1
Registered: October 2023
|
Member |
|
|
Jean wrote on Tue, 15 August 2023 19:09Hello
So I want to merge Indonesian male adolescent dataset with household dataset. Apparently, in male adolescent data set, wealth index is not included so I have to draw it from the household data set. However, the problem is that there is not key variable to use. I tried to use QCLUSTER and QNUMBER (number of household) but apparently those fail me miserable as they are not unique and therefore can't be drawn to my adolescent data set.
Have you tried creating a new variable that combines multiple variables from both datasets? For example, you could create a new variable that combines the household number and the individual number from the male adolescent dataset. This new variable would be unique and could be used as a key variable for merging. I think that it's a option for you.
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
