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
9720
Downloads
149
- Data files
- combined_ses_hh
- combined_ses_ind
Second source of income (D) (inc2hh)
Data file: combined_ses_hh
Overview
Valid:
27287
Invalid:
31972
Type:
Discrete
Decimal:
0
Start:
149
End:
150
Width:
2
Range:
1 - 13
Format:
Numeric
Questions and instructions
Categories
| Value | Category | Cases | |
|---|---|---|---|
| 1 | regular employment | 519 |
1.9%
|
| 2 | piecework | 4685 |
17.2%
|
| 3 | farming | 6909 |
25.3%
|
| 4 | fishing | 1629 |
6%
|
| 5 | selling prepared food | 1384 |
5.1%
|
| 6 | manufactoring goods | 1050 |
3.8%
|
| 7 | trading | 4673 |
17.1%
|
| 8 | gathering natural products | 735 |
2.7%
|
| 9 | letting property | 867 |
3.2%
|
| 10 | providing a service | 1361 |
5%
|
| 11 | support from relatives | 2339 |
8.6%
|
| 12 | support from non-relative | 940 |
3.4%
|
| 13 | other | 196 |
0.7%
|
| Sysmiss | 31972 |
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
Second 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
}