Cleaned spouse and marriage data

Malawi

Get Microdata

Reference ID

MWI-MEIRU-SPOUSELINKS-2002-v01

Producer(s)

Professor Amelia (Mia) Crampin

Collections

Karonga HDSS Combined / Harmonized Datasets

Metadata

Documentation in PDF DDI/XML JSON

Created on

Nov 14, 2025

Last modified

Nov 19, 2025

Page views

6795

Downloads

108

Partners ever CRS members (D) (crs)

Data file: all_spouse_pairs_full

Overview

Valid: 188811

Invalid: 7592

Type: Discrete

Decimal: 0

Start: 33

End: 33

Width: 1

Range: 1 - 3

Format: Numeric

Questions and instructions

Value	Category	Cases
1	wife	7473	4%
2	husband	774	0.4%
3	both	180564	95.6%
Sysmiss		7592

Description

Definition

Partners ever CRS members

Imputation and derivation

Derivation

<A listing of all idents that were ever CRS members is created:>
use ${gendata}\crs_residency_episodes_clean_nopoly, clear
bys ident: egen lastincrs=max(stopdate)
bys ident (stopdate): gen laststop=stoptype[_N]
format %td lastincrs
keep ident lastincrs laststop
duplicates drop
gen crs=1
save ${tempfiles}\allcrsmembers, replace
<then this is merged into the main dataset for each partner:>
merge m:1 ident using ${tempfiles}\allcrsmembers, keep(master match) keepusing(crs) nogen
merge m:1 ident using ${tempfiles}\indices_lafd, keep(master match) nogen
rename (ident husband lastalive firstdead crs) (wife ident w_lastalive w_firstdead w_crs)
merge m:1 ident using ${tempfiles}\allcrsmembers, keep(master match) keepusing(crs) nogen
merge m:1 ident using ${tempfiles}\indices_lafd, keep(master match) nogen
rename (ident lastalive firstdead crs) (husband h_lastalive h_firstdead h_crs)
gen crs=1 if w_crs==1 & h_crs~=1
replace crs=2 if w_crs~=1 & h_crs==1
replace crs=3 if w_crs==1 & h_crs==1
la val crs repby

Back to Catalog