Home » Countries » India » Wealth Index variables
| Re: Wealth Index variables [message #26576 is a reply to message #26575] |
Mon, 03 April 2023 12:31  |
Bridgette-DHS
Messages: 3230
Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS staff member, Tom Pullum:
For these two surveys you should be able to find files IAWI22FL.dta and IAWI41FL.dta ("WI" for "wealth index"), which include hhid (the household id), wlthindf (the continuous wealth index, the same as v191, mv191, or hv271), and wlthindf5 (the wealth quintiles, the same as v190, mv190, or hv270). You need to merge the WI file with the other files (PR, IR, KR, MR). The wealth index is household-specific, so the merge does not need to specify the line numbers of individual household members.
For the PR merge, whhid is the same as hhid. You go through the usual steps of giving them the same name, sorting the WI file, saving the sorted file, and merging.
The IR and KR files include a string id called "caseid". You extract hhid from that with "gen hhid=substr(caseid,1,12)". You then do the merge, again just with hhid and whhid, not using line number. Similarly in the MR file if you want to attach the wealth index to that file.
You will find examples of merges on the forum, but let us know if this is not clear.
|
|
|
|
Current Time: Sun Feb 16 23:17:39 Coordinated Universal Time 2025
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
