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

9772

Downloads

149

Score of amount of food harvested by household (D) (harvestscore)

Data file: combined_ses_hh

Overview

Valid: 24912

Invalid: 34347

Type: Discrete

Decimal: 0

Start: 65

End: 66

Width: 2

Range: 1 - 10

Format: Numeric

Description

Definition

Score of amount of food harvested by household

Imputation and derivation

Derivation

variable: maizeharv (table[s]: css_seh)
variable: riceharv (table[s]: css_seh)
variable: gnutharv (table[s]: css_seh)

<Cans of harvest is added together and then turned into a decile variable in relation to all other records with this data within the same year>
egen harvesttot=rowtotal(maizeharv riceharv gnutharv)
replace harvesttot=. if maizeharv==. & riceharv==. & gnutharv==.
foreach var in plot harvest harvsell {
foreach y in `yearlist' { /*make relative score by year*/
cap xtile `var'scorey`y'=`var'tot if year==`y', nq(10) /*score is created by splitting the population into deciles*/
if _rc~=0 gen `var'scorey`y'=.
}
egen `var'score=rowmax(`var'scorey*)
drop `var'scorey*
}

Back to Catalog