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
9895
Downloads
151
- Data files
- combined_ses_hh
- combined_ses_ind
Third source of income (D) (inc3hh)
Data file: combined_ses_hh
Overview
Valid:
11453
Invalid:
47806
Type:
Discrete
Decimal:
0
Start:
151
End:
152
Width:
2
Range:
1 - 13
Format:
Numeric
Questions and instructions
Categories
| Value | Category | Cases | |
|---|---|---|---|
| 1 | regular employment | 117 |
1%
|
| 2 | piecework | 1858 |
16.2%
|
| 3 | farming | 1656 |
14.5%
|
| 4 | fishing | 566 |
4.9%
|
| 5 | selling prepared food | 798 |
7%
|
| 6 | manufactoring goods | 522 |
4.6%
|
| 7 | trading | 1755 |
15.3%
|
| 8 | gathering natural products | 761 |
6.6%
|
| 9 | letting property | 527 |
4.6%
|
| 10 | providing a service | 628 |
5.5%
|
| 11 | support from relatives | 1472 |
12.9%
|
| 12 | support from non-relative | 706 |
6.2%
|
| 13 | other | 87 |
0.8%
|
| Sysmiss | 47806 |
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
Third source of income
Imputation and derivation
Derivation
variable: employ (table[s]: css_seh, gp_gphhold)
variable: employo (table[s]: css_seh, gp_gphhold)
variable: piecew (table[s]: css_seh, gp_gphhold)
variable: piecewo (table[s]: css_seh, gp_gphhold)
variable: farm (table[s]: css_seh, gp_gphhold)
variable: farmo (table[s]: css_seh, gp_gphhold)
variable: fish (table[s]: css_seh, gp_gphhold)
variable: fisho (table[s]: css_seh, gp_gphhold)
variable: snacks (table[s]: css_seh, gp_gphhold)
variable: snackso (table[s]: css_seh, gp_gphhold)
variable: manuf (table[s]: css_seh, gp_gphhold)
variable: manufo (table[s]: css_seh, gp_gphhold)
variable: trade (table[s]: css_seh, gp_gphhold)
variable: tradeo (table[s]: css_seh, gp_gphhold)
variable: gather (table[s]: css_seh, gp_gphhold)
variable: gathero (table[s]: css_seh, gp_gphhold)
variable: letting (table[s]: css_seh, gp_gphhold)
variable: lettingo (table[s]: css_seh, gp_gphhold)
variable: service (table[s]: css_seh, gp_gphhold)
variable: serviceo (table[s]: css_seh, gp_gphhold)
variable: supportf (table[s]: css_seh, gp_gphhold)
variable: supportfo (table[s]: css_seh, gp_gphhold)
variable: support (table[s]: css_seh, gp_gphhold)
variable: supporto (table[s]: css_seh, gp_gphhold)
variable: othinc (table[s]: css_seh, gp_gphhold)
variable: othinco (table[s]: css_seh, gp_gphhold)
<individual income sources are ranked for each household (variables employ, employo, piecew, piecewo etc.), this are summarised to indicate top 4 income sources:>
forvalues y=1/4 { /*loop to create the variables*/
gen inc`y'hh=.
}
local x=1 /*start a local of x which will be 1 to start the loop at employ, then increased to 2 for piecew etc*/
foreach var in employ piecew farm fish snacks manuf trade gather letting service supportf support othinc { /*these vars are yes/no of whether they are a source of income and the var with o after (e.g. employo) is the rank of order of importance, with no duplication so only one has rank 1 for each record*/
recode `var'o 0=. /*apparently 00 in rank var is code for missing*/
forvalues y=1/4 { /*loop through 1-4 to capture the top 4 most important into the variables created above*/
replace inc`y'hh=`x' if `var'o==`y' /*x is 1 for employ, 2 for piecework etc. so inc1 is 1 if employ==1, inc3 is 4 if fish==3 etc.*/
}
local x=`x'+1 /*add 1 to the local x before going through the foreach var loop again*/
}
la def activity 1 "regular employment" 2 "piecework" 3 "farming" 4 "fishing" 5 "selling prepared food" 6 "manufactoring goods" 7 "trading" 8 "gathering natural products" 9 "letting property" 10 "providing a service" 11 "support from relatives" 12 "support from non-relative" 13 "other"
la val inc1hh inc2hh inc3hh inc4hh activity
gen tag=1 if inc1==.
forvalues a=1/3 { /*if no income source 1 reported move all the sources up one*/
local b=`a'+1
replace inc`a'hh=inc`b'hh if tag==1
}
variable: employo (table[s]: css_seh, gp_gphhold)
variable: piecew (table[s]: css_seh, gp_gphhold)
variable: piecewo (table[s]: css_seh, gp_gphhold)
variable: farm (table[s]: css_seh, gp_gphhold)
variable: farmo (table[s]: css_seh, gp_gphhold)
variable: fish (table[s]: css_seh, gp_gphhold)
variable: fisho (table[s]: css_seh, gp_gphhold)
variable: snacks (table[s]: css_seh, gp_gphhold)
variable: snackso (table[s]: css_seh, gp_gphhold)
variable: manuf (table[s]: css_seh, gp_gphhold)
variable: manufo (table[s]: css_seh, gp_gphhold)
variable: trade (table[s]: css_seh, gp_gphhold)
variable: tradeo (table[s]: css_seh, gp_gphhold)
variable: gather (table[s]: css_seh, gp_gphhold)
variable: gathero (table[s]: css_seh, gp_gphhold)
variable: letting (table[s]: css_seh, gp_gphhold)
variable: lettingo (table[s]: css_seh, gp_gphhold)
variable: service (table[s]: css_seh, gp_gphhold)
variable: serviceo (table[s]: css_seh, gp_gphhold)
variable: supportf (table[s]: css_seh, gp_gphhold)
variable: supportfo (table[s]: css_seh, gp_gphhold)
variable: support (table[s]: css_seh, gp_gphhold)
variable: supporto (table[s]: css_seh, gp_gphhold)
variable: othinc (table[s]: css_seh, gp_gphhold)
variable: othinco (table[s]: css_seh, gp_gphhold)
<individual income sources are ranked for each household (variables employ, employo, piecew, piecewo etc.), this are summarised to indicate top 4 income sources:>
forvalues y=1/4 { /*loop to create the variables*/
gen inc`y'hh=.
}
local x=1 /*start a local of x which will be 1 to start the loop at employ, then increased to 2 for piecew etc*/
foreach var in employ piecew farm fish snacks manuf trade gather letting service supportf support othinc { /*these vars are yes/no of whether they are a source of income and the var with o after (e.g. employo) is the rank of order of importance, with no duplication so only one has rank 1 for each record*/
recode `var'o 0=. /*apparently 00 in rank var is code for missing*/
forvalues y=1/4 { /*loop through 1-4 to capture the top 4 most important into the variables created above*/
replace inc`y'hh=`x' if `var'o==`y' /*x is 1 for employ, 2 for piecework etc. so inc1 is 1 if employ==1, inc3 is 4 if fish==3 etc.*/
}
local x=`x'+1 /*add 1 to the local x before going through the foreach var loop again*/
}
la def activity 1 "regular employment" 2 "piecework" 3 "farming" 4 "fishing" 5 "selling prepared food" 6 "manufactoring goods" 7 "trading" 8 "gathering natural products" 9 "letting property" 10 "providing a service" 11 "support from relatives" 12 "support from non-relative" 13 "other"
la val inc1hh inc2hh inc3hh inc4hh activity
gen tag=1 if inc1==.
forvalues a=1/3 { /*if no income source 1 reported move all the sources up one*/
local b=`a'+1
replace inc`a'hh=inc`b'hh if tag==1
}