The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Malaria » Nigeria Malaria Indicator survey 2015 (Women data)
Nigeria Malaria Indicator survey 2015 [message #18283] Mon, 28 October 2019 08:13 Go to next message
Meerah is currently offline  Meerah
Messages: 3
Registered: January 2019
Member
Hello Team,
I am currently working with the women data of Nigeria Malaria Indicator survey, I saw that 861 women confirm their pregnancy, but in other questions like the taking of antimalarial drugs or the use of mosquito nets while pregnant has different response rate. I mean the number of pregnant women is higher in these questions. I thoroughly checked the data, recode book and questionnaire before posting the question. I need your help please. Thank you
Re: Nigeria Malaria Indicator survey 2015 [message #18307 is a reply to message #18283] Mon, 04 November 2019 16:50 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
A response from Malaria Technical Coordinator, Cameron Taylor:
Quote:

Dear user,
Thanks for your question. What you are asking is a result of the structure of our questionnaires and the corresponding datasets.

The 861 you are referring to is the unweighted number of women in the individual recode (IR) dataset (variable v213). These are women with a completed women's questionnaire (age 15-49) who are de facto members of the household. When comparing the currently pregnant women in the person recode dataset (PR file) (variable hml18) you will see a slightly higher number of pregnant women since this file includes women who are de jure or de facto and not necessarily if they had a completed interview. If a woman is de jure non-de facto they would not be included in the IR file. The 2015 Nigeria MIS also has a country specific variable (PR file: sh09 currently pregnant) which was asked in the household roster but this variable was not used in any calculation for malaria indicators on pregnancy.

If you want to replicate "Among pregnant women age 15-49, the percentage who slept the night before the survey under an ITN" you need to use the PR file. You can see examples of the code to replicate the Nigeria MIS report using the following link:
Stata: https://github.com/DHSProgram/DHS-Indicators-Stata/tree/mast er/Chap12_ML
SPSS: https://github.com/DHSProgram/DHS-Indicators-SPSS/tree/maste r/Chap12_ML

Lastly, it is important to keep in mind that all tables in the MIS final report are weighted. That might be another reason why you are seeing discrepant results between what you are tabulating in a statistical software and what you see in the final report

Let us know if you have any additional questions
Cameron

Re: Nigeria Malaria Indicator survey 2015 [message #18316 is a reply to message #18307] Fri, 08 November 2019 02:48 Go to previous messageGo to next message
Meerah is currently offline  Meerah
Messages: 3
Registered: January 2019
Member
Thank you so much for this information, I am very grateful! I have checked the PR file as you mentioned. My objectives are to assess the use of mosquito nets and antimalarial drugs among pregnant women. In the PR file, I didn't see any variable that is linked with the use of antimalarial drugs among pregnant women. Does it mean that I can't use the PR file for the analysis? And does the MIS have a clear manual just like the DHS recode book?. Thank you for the support
Re: Nigeria Malaria Indicator survey 2015 [message #18576 is a reply to message #18316] Thu, 02 January 2020 13:25 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User, the PR file is a household member recode file. The recode variable related to malaria medications is in the woman's file starting with M49A.
From P65, The Standard Recode Manual:
Quote:

Medication taken to prevent from Malaria
BASE: In the DHS VII core questionnaire use of SP/Fansidar by the mother was asked for
last births. Other malaria medications (M49B M49Z) were removed but kept in the DHV
VII recode.
M49A During pregnancy - took SP/Fansidar for Malaria
M49B During pregnancy - took Chloroquine for Malaria
M49C During pregnancy - took country specific drug for Malaria
M49D During pregnancy - took country specific drug for Malaria
M49E During pregnancy - took country specific drug for Malaria
M49F During pregnancy - took country specific drug for Malaria
M49G During pregnancy - took country specific drug for Malaria
M49X During pregnancy - took other drug for Malaria
Re: Nigeria Malaria Indicator survey 2015 [message #26247 is a reply to message #18307] Fri, 24 February 2023 05:14 Go to previous messageGo to next message
Titus is currently offline  Titus
Messages: 3
Registered: February 2023
Member
Hi
Pls. kindly assist in providing guidance. I tried to import Nigeria 2021 GPS shapefile but the administrative level 2 is showing as NULL on ARCGIS. Pls.kindly assit solve this issue.
Re: Nigeria Malaria Indicator survey 2015 [message #26263 is a reply to message #26247] Wed, 01 March 2023 09:18 Go to previous messageGo to next message
brad-DHS is currently offline  brad-DHS
Messages: 7
Registered: October 2021
Location: Rockville, MD
Member
Hello, Titus. Thank you for the post. I took a look at the GPS data for both the 2015 and 2021 MIS in Nigeria. When you refer to the Admin 2, are you referring to the 774 LGAs? If so, neither GPS file contains the LGA names.

Both GPS files contain the names of the 37 states of Nigeria as well as 6 regions which are groups of states. These names are stored in the ADM1NAME and DHSREGNA variables respectively.

If you want the LGA names for each cluster, I recommend using a spatial join in ArcGIS to join the LGA names from an LGA shapefile. If this doesn't answer your question or if you have follow-up questions, please let me know in the discussion thread below. I hope this helps!
Re: Nigeria Malaria Indicator survey 2015 [message #26346 is a reply to message #26263] Fri, 10 March 2023 03:44 Go to previous messageGo to next message
Titus is currently offline  Titus
Messages: 3
Registered: February 2023
Member
Dear Brad,

Thank you for your prompt response.
My focus on the GPS data is on LGA and Ward level to enable me trace and identified Cluster Number/code used at the ward level which in turn will assist me in selecting the right cluster code for sampling.
However, the major issue is that the LGA and Ward level names is returning as "Null" on the online ArcGIS.

I think the source of the issue is from unavailability of the sub-national administrative division code data from the source programmed in the GPS dataset and documented in the "DHS README" as attached.

Upon importing the shapefile, it is expected that there will be link up between the ArcGIS and the various websites programmed in the shapefile to provide the sub-national administrative division data but if the data is not available, it will return "Null"

I will appreciate if the GPS programming can revert to initial sources for the sub-national administrative division code GPS data or if there is a way you could assist with this information.

Personally, I have taken time to access the data directly form the website but the data are not available and that is the reason why its returning "Null" on ArcGIS.

I want to guess that this programming was recently changed for Nigeria because I have done analysis at this level before with all the sub national information up to cluster level coming out on ArcGIS.

I will really appreciate your assistance if you can pass this information to the backend programmers to look at it and profer soultion.

See example on the source of the problem below:

ADM1FIPS = Federal Information Processing Standards (FIPS) 2 letter country code plus 2 letter/digit first sub-national administrative division code (http://www.itl.nist.gov/fipspubs/fip10-4.htm).
*NOTE: If this information is not available, this field will be "NULL".

ADM1FIPSNA = Federal Information Processing Standards (FIPS) first sub-national administrative division name (http://www.itl.nist.gov/fipspubs/fip10-4.htm).
*NOTE: If this information is not available, this field will be "NULL".

ADM1SALBCO = Second Administrative Level Boundaries (SALB) first sub-national administrative division code (http://www.unsalb.org).
*NOTE: The website requires free registration for downloads.
*NOTE: If this information is not available, this field will be "NULL".

ADM1SALBNA = Second Administrative Level Boundaries (SALB) first sub-national administrative division name (http://www.unsalb.org).
*NOTE: The website requires free registration for downloads.
*NOTE: If this information is not available, this field will be "NULL".

Thanks and regards

Titus
Re: Nigeria Malaria Indicator survey 2015 [message #26393 is a reply to message #26346] Wed, 15 March 2023 11:52 Go to previous messageGo to next message
brad-DHS is currently offline  brad-DHS
Messages: 7
Registered: October 2021
Location: Rockville, MD
Member
Hello, Titus. To clarify, we don't include the LGA names in our datasets. We only include the names of the 37 states and the 6 regions. If you want to add LGA names to the GPS dataset, you'll have to do so using a spatial join and your own LGA shapefile. I wish you all the best! If you have any additional questions, please let me know.

All the best,
Brad
Re: Nigeria Malaria Indicator survey 2015 [message #26460 is a reply to message #26393] Thu, 23 March 2023 03:25 Go to previous message
Titus is currently offline  Titus
Messages: 3
Registered: February 2023
Member
Dear Brad,

Thank you for your response.

Please, can you kindly guide on how to do the spatial join and where to access the LGA shapefile.
I will really appreciate if you can provide this guidance or any document/guideline on this

Thank you and regards

Titus
Previous Topic: MOST APPROPRIATE DENOMINATOR
Next Topic: Children Data NMIS 2015
Goto Forum:
  


Current Time: Thu Oct 10 10:32:55 Coordinated Universal Time 2024