The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Water and Sanitation » Need clarification on Kenya DHS 2022 Dataset (Major source of drinking water)
Need clarification on Kenya DHS 2022 Dataset [message #28517] Tue, 23 January 2024 10:32 Go to previous message
Lubana
Messages: 3
Registered: January 2024
Member
Hello,

I hope this message finds you well.

I am working in a Project where I am going to create a comprehensive map of social vulnerability to climate change hazards in Kenya.

In pursuit of this goal, I have chosen to leverage the DHS-2022 dataset for Kenya. Having recently downloaded the Household data file (KEHR8BSD.zip) from the DHS website, I converted it to CSV format for streamlined integration into my research workflow. Unfortunately, I have found some challenges related to identifying the variable associated with the 'major source of drinking water.' I have looked at the DHS guidelines, such as the Microdata Library for Kenya and the USAID Guide to DHS Statistics, I have encountered difficulty in decoding the information contained in the Excel Sheet. The Microdata Library indicates that the code 'V113' corresponds to the major source of drinking water. Yet, upon examining the Excel file, I discovered 24 columns labeled HV113_01, HV113_02, and so forth. Unfortunately, the documentation does not shed light on the significance of these extension numbers, leaving me uncertain about the distinct sources represented by HV113_01 and HV113_02.

Moreover, I have encountered another code, 'V87 hv201 Source of drinking water' in in Microdata Library document, in Page 18, Regrettably, I am grappling with understanding the nuances of this code. I need help to figure this out. I not sure if I am using the right dataset since I am working with DHS data for the very first time. My apologies for bothering you. But I genuinely appreciate any guidance or insights you can provide.

Attached herewith is the Excel sheet containing the a small part of downloaded data for your convenience.

Thank you for your time and consideration.


Kind regards
 
Read Message
Read Message
Previous Topic: Menstrual health and hygiene
Next Topic: Understanding DHS Data
Goto Forum:
  


Current Time: Thu Jul 11 07:46:55 Coordinated Universal Time 2024