Home » Topics » General » gender matching interviewer / participant in Zimbabwe & Burundi (Zimbabwe & Burundi appear to have mismatched genders for interviewer/respondent?)
| Re: gender matching interviewer / participant in Zimbabwe & Burundi [message #23878 is a reply to message #23873] |
Tue, 28 December 2021 18:02   |
Bridgette-DHS
Messages: 3038
Registered: February 2013
|
Senior Member |
|
|
Following is another response from DHS Research & Data Analysis Director, Tom Pullum:
I have found (thanks to to Ruben Hume of the Data Processing staff) that MZ71 included some survey-specific codes for interviewers, etc. In the IR file, the health technician was identified with sbtecnum4. (In general, look for variables that contain "num4" in their name.) In the MR file, the variable is smbtecnum4. I see that these are 4-digit codes that begin with 4, specifically 4001 through 4050, and they match with fieldworkers 4001 through 4050 in the FW file. The following Stata code will do the complete merge. I will also paste the 2x2 table for sex of respondent vs sex of interviewer for the merged cases. It shows that there is no relationship between these two variables. Note that by redefining "int_id" to be one of the other interviewer codes you can link to other 4-digit codes in the FW file.
cd e:\DHS\DHS_data\scratch
* Prepare the IR file
use "...MZIR71FL.DTA", clear
gen cluster=v001
gen hh=v002
gen line=v003
*gen int_id=v028
gen int_id=sbtecnum4
keep cluster hh line int_id
gen sex=2
save IR.dta, replace
* Prepare the MR file
use "...MZMR71FL.DTA", clear
gen cluster=mv001
gen hh=mv002
gen line=mv003
*gen int_id=mv028
gen int_id=smbtecnum4
keep cluster hh line int_id
gen sex=1
save MR.dta, replace
* Prepare the AR file
use "...MZAR72FL.DTA", clear
gen cluster=hivclust
gen hh=hivnumb
gen line=hivline
gen result=hiv03
sort cluster hh line
save AR.dta, replace
* Prepare the FW file
use "...MZFW71FL.DTA", clear
gen int_id=fw101
gen int_sex=fw105
keep int_id int_sex
sort int_id
save FW.dta, replace
* Append IR and MR
use IR.dta, clear
append using MR.dta
sort cluster hh line
* Merge with AR
merge cluster hh line using AR.dta
rename _merge AR_merge
sort int_id
* Merge with FW
merge int_id using FW.dta
rename _merge FW_merge
* Compare sex of interview and sex of respondent
tab sex int_sex,m
tab sex int_sex if FW_merge==3
-
Attachment: merge.png
(Size: 6.02KB, Downloaded 437 times)
[Updated on: Tue, 28 December 2021 18:21] Report message to a moderator |
|
|
|
Current Time: Wed Apr 24 04:55:42 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
