Home / Central Data Catalog / DDI-MWI-MEIRU-SES-2007-V01B / variable [F1]
central

SES Combined socio-economic data

Malawi
Get Microdata
Reference ID
DDI-MWI-MEIRU-SES-2007-v01b
Collections
Combined / Harmonized Datasets Karonga HDSS
Metadata
Documentation in PDF DDI/XML JSON
Created on
Nov 14, 2025
Last modified
Nov 19, 2025
Page views
9735
Downloads
149

Main source of water used by the household (D) (water2)

Data file: combined_ses_hh

Overview

Valid: 49164
Invalid: 10095
Type: Discrete
Decimal: 0
Start: 105
End: 105
Width: 1
Range: 1 - 9
Format: Numeric

Questions and instructions

Categories
Value Category Cases
1 Tap to house 7490
15.2%
2 Shared communal tap 5889
12%
3 Bore hole 25745
52.4%
4 Lake/river/well 10040
20.4%
8 Unknown 0
0%
9 Missing 0
Sysmiss 10095
Warning: these figures indicate the number of cases found in the data file. They cannot be interpreted as summary statistics of the population of interest.

Description

Definition
Main source of water used by the household.

Imputation and derivation

Derivation
variable: water (table[s]: css_seh, gp_gphhold)
variable: wtap (table[s]: caps_blhse)
variable: wctap (table[s]: caps_blhse)
variable: wbore (table[s]: caps_blhse)
variable: wcwell (table[s]: caps_blhse)
variable: wowell (table[s]: caps_blhse)
variable: wlake (table[s]: caps_blhse)
variable: hhwate_fmode (table[s]: NCD_combined_data_all_final [derived table])

<SEH data are recoded to match gphhold categories:>
recode water1 4/max=4, gen(water2)
<CAPS data is collected as multiple binary variables which are convered to one variable:>
gen water2=1 if wtap==1
replace water2=2 if wctap==1 & water2==.
replace water2=3 if wbore==1 & water2==.
replace water2=4 if (wlake==1 | wcwell==1 | wowell==1) & water2==.
Back to Catalog