The DHS Program User Forum: Wealth Index » Wealth Index for Indonesian Adolescents Survey 2017

Home » Topics » Wealth Index » Wealth Index for Indonesian Adolescents Survey 2017

Show: Today's Messages :: Show Polls :: Message Navigator

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.

Report message to a moderator

Re: Wealth Index for Indonesian Adolescents Survey 2017 [message #27487 is a reply to message #27456]

Mon, 21 August 2023 13:08

Janet-DHS
Messages: 938
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"?

Report message to a moderator

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

Hello

bloxd io

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.

Report message to a moderator

Re: Wealth Index for Indonesian Adolescents Survey 2017 [message #28389 is a reply to message #27487]

Mon, 25 December 2023 22:07

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.

geometry dash subzero

[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

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.

Report message to a moderator

Re: Wealth Index for Indonesian Adolescents Survey 2017 [message #28455 is a reply to message #28426]

Tue, 09 January 2024 22:34

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

Report message to a moderator

Previous Topic:	Understanding wealth index
Next Topic:	Constructing Wealth Index in IR file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Mar 16 19:27:47 Coordinated Universal Time 2025