TB cases (1974-2018) and controls (1998-2018) analytical dataset (Karonga)

Malawi

Get Microdata

Reference ID

MWI-MEIRU-TB-COMBINE-FINAL-2022-v01

Producer(s)

Mia Crampin, Estelle McLean

Collections

Karonga -District-wide Combined / Harmonized Datasets Karonga HDSS

Metadata

Documentation in PDF DDI/XML JSON

Created on

Nov 14, 2025

Last modified

Nov 15, 2025

Page views

24390

Downloads

148

Last known outcome of person (D) (lastfuoutcome)

Data file: combined_tb_cases_controls_final

Overview

Valid: 12911

Invalid: 0

Type: Discrete

Decimal: 0

Start: 1430

End: 1430

Width: 1

Range: 1 - 9

Format: Numeric

Questions and instructions

Literal question

Last known outcome of person

Value	Category	Cases
1	Alive	8620	66.8%
2	Dead	3436	26.6%
3	Left	855	6.6%
4	Missed	0	0%
8	Unknown	0	0%
9	Missing	0	0%

Imputation and derivation

Derivation

variable: adl [status: alive/dead/left] (table[s]: indices, tbfu_stata, tb_tbfu)

<the follow up data is created separately:>
use ${newstata}\indices, clear
recode dthlftyy 0/1900=. 9999=.
gen outcomdate=mdy(6,15,dthlftyy)
drop crsno
append using ${newstata}\tbfu_stata
gen dthdate=outcomdate if adl==2 //2=died
gen leftdate=outcomdate if adl==3 //3=left
append using ${newstata}\tb_tbfu
drop if adl==8 //8=unknown
replace intdate=. if dthdate~=. | leftdate~=. | alivedate~=.
egen lastdate=rowmax(intdate dthdate leftdate alivedate)
bys ident: egen lastfudate=max(lastdate)
gen lastadl=adl if lastdate==lastfudate
bys ident: egen lastfuoutcome=max(lastadl)
la val lastfuoutcome adl
keep ident lastfudate lastfuoutcome
format %td lastfudate
duplicates drop
save ${tempfiles}\fu_dates, replace
<then merged into the main data file:>
merge m:1 ident using ${tempfiles}\fu_dates, keep(master match) nogen

Back to Catalog