I am working on malaria using Nigeria Malaria Indicator survey 2015, I am finding it difficult to know the exact data set to use since children record and household record contain so much MISSING VALUES. Please advice me, this is my first time using DHS data set and it seems i am finding it difficult to get the exact tabulations. Which weight variable do i use for malaria data analysis? Can i merge two data sets?

When the 2015 Nigeria Malaria Indicator Survey data (Household member recode file or children's file ) and the 2015 Nigeria GPS datasets are merged using their cluster numbers (HV001 in survey data and DHSCLUST in GPS data) using spss. I will be getting this error message as i want to do further analysis ERROR: Missing value(s) found in XC or YC variable(s). Missing values not allowed for coordinate
variables. I think this is because they have different cluster numbers. Please i need help maybe i might not be merging them properly .

I used the following STATA code to join between the GC (points) and the IR file

/******************************************************************************************
* Title: NigeriaMerge.do
* Created by: Tom Fish
* Created on: 30 October 2018
* Purpose: Explan how to merge an IR file with the GC (points) file in STATA
******************************************************************************************/
clear all
set more off
* Set folders that I am working on
local ptsDir "C:\Data\08_GPS\04_Completed_Surveys\Nigeria\Nigeria_2015_MIS\Upload_file\"
local dataDir "C:\Data\DHSdata\"
local working "C:\working\"
* Make sure we are working in our working directory
cd "`working'"
* Convert the shapefile into a dta file to merge in STATA
shp2dta using "`ptsDir'NGGE71FL.shp", database(ngpts) coordinates(ngcoord) genid(id)
* Open up the table portion of the shapefile
use ngpts
* Rename and sort to allow for the merge to be successful
rename DHSCLUST v001
sort v001
* Resave the table
save ngpts, replace
* Open the IR file
use "`dataDir'NGIR71FL.DTA", clear
* Do a 1 to Many merge/join between the points and the IR file
sort v001
merge v001 using ngpts.dta
* Show that the merge was 100% successful and then drop the unneed column
tab _merge
drop _merge id
* Save the merged file
save NG_Merged, replace

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.