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

6792

Downloads

108

Union ever reported by (D) (repby)

Data file: all_spouse_pairs_full

Overview

Valid: 193050

Invalid: 3353

Type: Discrete

Decimal: 0

Start: 26

End: 26

Width: 1

Range: 1 - 3

Format: Numeric

Questions and instructions

Value	Category	Cases
1	wife	12540	6.5%
2	husband	2958	1.5%
3	both	177552	92%
Sysmiss		3353

Description

Definition

Union ever reported by

Imputation and derivation

Derivation

variable: ident (table[s]: gen_spouse)
variable: idspouse (table[s]: gen_spouse)

The data from gen_spouse is split into male and female reports which are merged into each other, the resulting merge variable is used to create repby. NB. the spouse_match_ datasets referred to below are the separated datasets:
use ident idspouse using ${tempfiles}\spouse_match_1, clear
rename (ident idspouse) (wife husband)
duplicates drop
save ${tempfiles}\couples_Freport, replace
use ident idspouse using ${tempfiles}\spouse_match_0, clear
rename (ident idspouse) (husband wife)
duplicates drop
merge 1:1 wife husband using ${tempfiles}\couples_Freport
gen repby=3 if _m==3 /*if they match they have both reported each other at least once*/
replace repby=1 if _m==2 /*if the union is only in the using data then only the wife has ever reported it*/
replace repby=2 if _m==1 /*if the union is only in the master data then only the husband has ever reported it*/
la val repby repby
drop _m
save ${tempfiles}\spouses_ever_reported, replace

Back to Catalog