The DHS Program User Forum: Malaria » Nigeria Malaria Indicator survey 2021

Home » Topics » Malaria » Nigeria Malaria Indicator survey 2021

Show: Today's Messages :: Show Polls :: Message Navigator

Nigeria Malaria Indicator survey 2021 [message #27406]

Mon, 07 August 2023 19:54

Nikky
Messages: 2
Registered: August 2023

Member

Dear DHS team,

I am working with 2021 NMIS women questionnaire. I need to include the "number of rooms used for sleeping - HV216" from household dataset, please how do I go about this?

I attempted by filtering "HV010" in the household dataset, I got a total of 10,418 households while I have 14,647 for HV010?

Also please how do I remove women that were not interviewed from household dataset to match the 14,476 women in the women dataset.

Warm regards,
Nky

Report message to a moderator

Re: Nigeria Malaria Indicator survey 2021 [message #27443 is a reply to message #27406]

Tue, 15 August 2023 11:57

Janet-DHS
Messages: 888
Registered: April 2022

Senior Member

Following is a response from DHS staff member, Tom Pullum:

You need to do a merge, copying hv216 in the household data onto the data for the women. Below I will paste Stata lines that do this. This program will copy ALL the household-level variables, not just hv216.

* Stata program to copy household-level variables into the IR file

* Specify workspace
cd e:\DHS\DHS_data\scratch

* Prepare household data
use "...NGHR81FL.DTA" , clear
drop *_*
rename hv001 cluster
rename hv002 hh
sort cluster hh
save NGHR81_temp.dta, replace

* Prepare the IR file and merge
use "...NGIR81FL.DTA" , clear
rename v001 cluster
rename v002 hh
sort cluster hh
merge m:1 cluster hh using NGHR81_temp.dta
keep if _merge==3
drop _merge

Report message to a moderator

Re: Nigeria Malaria Indicator survey 2021 [message #27460 is a reply to message #27443]

Wed, 16 August 2023 05:47

Nikky
Messages: 2
Registered: August 2023

Member

Hi Janet,

Thank you so much for the information, 100% helpful.

Thanks Tom!!

Report message to a moderator

Previous Topic:	Missingness in strata variables (Madagascar MIS- 2011 and 2013)
Next Topic:	Gambia DHS 2019-20

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 22 07:56:25 Coordinated Universal Time 2024