The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Wealth Index » Variable WHHID on RStudio (Merging Wealth Recode with Household and Children's Recode)
Variable WHHID on RStudio [message #31963] Tue, 01 September 2026 04:44 Go to next message
angelialexia2002 is currently offline  angelialexia2002
Messages: 1
Registered: September 2026
Member
Hello everyone,
I'm trying to merge the Wealth Recode with the Children and Household Recodes for Ghana (1993 and 1998 surveys) on RStudio and I don't know how to do it, since it's different from v001, v002 and v003 which I'm using. Can somebody help, please? I'm trying to make 1993 and 1998 surveys comparable with the other waves, which have hv270 directly assigned in the Household Recode.
Re: Variable WHHID on RStudio [message #31968 is a reply to message #31963] Thu, 10 September 2026 00:39 Go to previous message
Walkeaul is currently offline  Walkeaul
Messages: 2
Registered: August 2025
Member
In the older DHS datasets like Ghana 1993 and 1998, WHHID in the Wealth Recode is a string identifier created by combining the cluster (v001 or hv001) and household number (v002 or hv002), padded with spaces. You can use R's substr() or string extraction functions to extract v001 and v002 from WHHID before merging with your Household or Children's Recode using those keys.

Previous Topic: How wealth indices align with income and consumption measures
Goto Forum:
  


Current Time: Tue Sep 15 02:52:06 Eastern Daylight Time 2026