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: 893
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: Thu Nov 28 03:36:21 Coordinated Universal Time 2024
.:: Contact :: Home :: Privacy Policy ::.

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

The information provided on this Web site is not official U.S. Government information and
does not represent the views or positions of the U.S. Agency for International Development or the U.S. Government...