The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » General » About extracting information on household characteristics (BR file and PR file used interchangeably)
Re: About extracting information on household characteristics [message #28717 is a reply to message #28668] Wed, 28 February 2024 14:04 Go to previous messageGo to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 938
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:
There is a secret for this survey. You have to specify another field when doing a merge. In the HH and PR files it is "shconces" and in the IR, KR, BR files it is "sconces". The following lines will work.



A few other surveys conducted about this time also have a secret identifier, but with various names that you would never guess. Fortunately when I found this one in 2015 I made a note of it.



* Specify a workspace

cd e:\DHS\DHS_data\scratch



use "...MLHR41FL.dta", clear

rename hv001 cluster

rename shconces concession

rename hv002 hh

save HR.dta, replace



use "..MLBR41FL.dta", clear

rename v001 cluster

rename sconces concession

rename v002 hh

merge m:1 cluster concession hh using HR.dta

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: v362 future intent to use contraception
Next Topic: DHS-MIS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Mon Oct 6 15:16:15 Coordinated Universal Time 2025
.:: Contact :: Home :: Privacy Policy ::.

Powered by: FUDforum 3.0.9.
Copyright ©2001-2018 FUDforum Bulletin Board Software