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

6696

Downloads

108

Spouse id (2) (idspouse2)

Data file: all_marital_reports

Overview

Valid: 11388

Invalid: 0

Type: Discrete

Start: 34

End: 40

Width: 7

Range: -

Format: character

Description

Definition

Spouse id

Imputation and derivation

Derivation

variable: idspouse (table[s]: gen_spouse)

This is mostly the spouse id variable as recorded reshaped wide by interview (so it repeats, idspouse1, idspouse2 etc.), but the code 'noid' is added when a spouse is reported but id not recorded.
replace idspouse="noid" if _m~=1 & idspouse==""
replace idspouse="" if idspouse~="noid" | marital~=1
bys ident intdate idspouse: gen n=_n
tostring n, replace
replace idspouse=idspouse+n if idspouse=="noid"
bys ident intdate (idspouse): gen n=_n
reshape wide idspouse, i(ident intdate) j(n)

Back to Catalog