Home / Central Data Catalog / MWI-MEIRU-SPOUSELINKS-2002-V01 / variable [F4]
central

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
6716
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

Categories
Value Category Cases
1 wife 12540
6.5%
2 husband 2958
1.5%
3 both 177552
92%
Sysmiss 3353
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
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