SES Combined socio-economic data
Malawi
Get Microdata
Reference ID
DDI-MWI-MEIRU-SES-2007-v01b
Collections
Metadata
Created on
Nov 14, 2025
Last modified
Nov 19, 2025
Page views
9923
Downloads
151
- Data files
- combined_ses_hh
- combined_ses_ind
Main source of water used by the household. (S) (water1)
Data file: combined_ses_hh
Overview
Valid:
37774
Invalid:
21485
Type:
Discrete
Decimal:
0
Start:
104
End:
104
Width:
1
Range:
1 - 9
Format:
Numeric
Questions and instructions
Categories
| Value | Category | Cases | |
|---|---|---|---|
| 1 | Tap to house | 6434 |
17%
|
| 2 | Shared communal tap | 4499 |
11.9%
|
| 3 | Bore hole | 19253 |
51%
|
| 4 | Covered well | 4139 |
11%
|
| 5 | Open well | 2100 |
5.6%
|
| 6 | Lake/river | 1338 |
3.5%
|
| 7 | Other | 11 |
0%
|
| 8 | Unknown | 0 |
0%
|
| 9 | Missing | 0 | |
| Sysmiss | 21485 |
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)
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])
<CAPS data is collected as multiple binary variables which are converted to one variable:>
water1=1 if wtap==1
replace water1=2 if wctap==1 & water1==.
replace water1=3 if wbore==1 & water1==.
replace water1=4 if wcwell==1 & water1==.
replace water1=5 if wowell==1 & water1==.
replace water1=6 if wlake==1 & water1==.
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])
<CAPS data is collected as multiple binary variables which are converted to one variable:>
water1=1 if wtap==1
replace water1=2 if wctap==1 & water1==.
replace water1=3 if wbore==1 & water1==.
replace water1=4 if wcwell==1 & water1==.
replace water1=5 if wowell==1 & water1==.
replace water1=6 if wlake==1 & water1==.