The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Wealth Index » Wealth Index for Indonesian Adolescents Survey 2017
Wealth Index for Indonesian Adolescents Survey 2017 [message #27456] Tue, 15 August 2023 19:09 Go to next message
Jean is currently offline  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 #27487 is a reply to message #27456] Mon, 21 August 2023 13:08 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 899
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

Can you give me the filename of the "male adolescent dataset"?
Re: Wealth Index for Indonesian Adolescents Survey 2017 [message #27925 is a reply to message #27456] Mon, 23 October 2023 06:09 Go to previous messageGo to next message
charleswinfrey is currently offline  charleswinfrey
Messages: 1
Registered: October 2023
Member
Jean wrote on Tue, 15 August 2023 19:09
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.
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 #28389 is a reply to message #27487] Mon, 25 December 2023 22:07 Go to previous messageGo to next message
traloas is currently offline  traloas
Messages: 1
Registered: December 2023
Member
His newly created variable would be one of a kind and might be used as a key variable for the purpose of merging.

[Updated on: Mon, 25 December 2023 22:08]

Report message to a moderator

Re: Wealth Index for Indonesian Adolescents Survey 2017 [message #28426 is a reply to message #27487] Thu, 04 January 2024 02:52 Go to previous messageGo to next message
talentstale is currently offline  talentstale
Messages: 1
Registered: January 2024
Member
Janet-DHS wrote on Mon, 21 August 2023 13:08
Following 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.
Re: Wealth Index for Indonesian Adolescents Survey 2017 [message #28455 is a reply to message #28426] Tue, 09 January 2024 22:34 Go to previous message
prfinrl610 is currently offline  prfinrl610
Messages: 1
Registered: January 2024
Member
In the implicit stratification, the census blocks were stratified by urban and rural areas and ordered by wealth index category. Slope Game
Previous Topic: Understanding wealth index
Next Topic: Constructing Wealth Index in IR file
Goto Forum:
  


Current Time: Mon Dec 9 06:02:26 Coordinated Universal Time 2024