| Wealth Index for Indonesian Adolescents Survey 2017 [message #27456] |
Tue, 15 August 2023 19:09  |
Jean
Messages: 1
Registered: August 2023
|
Member |
|
|
Hello
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.
|
|
|
|
|
|
| Re: Wealth Index for Indonesian Adolescents Survey 2017 [message #27925 is a reply to message #27456] |
Mon, 23 October 2023 06:09  |
|
|
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.
|
|
|
|
|
|
| Re: Wealth Index for Indonesian Adolescents Survey 2017 [message #28426 is a reply to message #27487] |
Thu, 04 January 2024 02:52 |
|
|
Janet-DHS wrote on Mon, 21 August 2023 13:08Following is a response from DHS staff member, Tom Pullum:
Can you give me the filename of the "male adolescent dataset"?
In the directory and filename textboxes, enter 'renamed file' and @replace(item(). name, ' ','_') respectively. What the above step does is it tells ADF to copy the csv files into a different container called renamed file and replace the blank spaces in file name with an underscore.
|
|
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
