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
Metadata
Created on
Nov 14, 2025
Last modified
Nov 15, 2025
Page views
24907
Downloads
151
- Data files
- combined_tb_cases_controls_final
What relationship is this person to you [wide] (D) (crelship2)
Data file: combined_tb_cases_controls_final
Overview
Valid:
295
Invalid:
12616
Type:
Discrete
Decimal:
0
Start:
1083
End:
1084
Width:
2
Range:
0 - 99
Format:
Numeric
Questions and instructions
Literal question
What relationship is this person to you?
Categories
| Value | Category | Cases | |
|---|---|---|---|
| 0 | No informant | 0 |
0%
|
| 1 | Relative | 32 |
10.8%
|
| 2 | Neighbour | 12 |
4.1%
|
| 3 | Visitor to h/hold | 1 |
0.3%
|
| 4 | Friend | 5 |
1.7%
|
| 5 | Colleague at work | 4 |
1.4%
|
| 6 | Someone visited | 0 |
0%
|
| 7 | Other | 4 |
1.4%
|
| 8 | Self | 0 |
0%
|
| 9 | Parent/step-parent | 62 |
21%
|
| 10 | Spouse | 18 |
6.1%
|
| 11 | Sibling | 82 |
27.8%
|
| 12 | Child | 20 |
6.8%
|
| 13 | Uncle/aunt | 23 |
7.8%
|
| 14 | G/mother/father/step | 6 |
2%
|
| 15 | Mother/father-inlaw | 0 |
0%
|
| 16 | Sister/brother-inlaw | 7 |
2.4%
|
| 17 | Cousin | 6 |
2%
|
| 18 | Nephew/niece | 4 |
1.4%
|
| 19 | Wifemate | 1 |
0.3%
|
| 20 | Grandson/daughter | 0 |
0%
|
| 21 | Uncle/aunt in-law | 0 |
0%
|
| 22 | Son/daughter in-law | 2 |
0.7%
|
| 23 | Distant cousin/relation | 0 |
0%
|
| 98 | Unknown | 0 |
0%
|
| 99 | Missing | 6 |
2%
|
| Sysmiss | 12616 |
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.
Imputation and derivation
Derivation
variable: relship (table[s]: tb_contact, tb_contactto2007, tbold_contact)
<the exposure contacts are processed separately first:>
reshape wide idcontac famcont contvil contplace trtdate trtdatex trtplace certtbcon wardvisit relship contaccon cough nurseill houseill sleepill contacind contaclong contacdays, i(ident frm_intdate) j(n)
rename * c*
rename (cident cidcontac* cfrm_intdate cnumtbcont) (ident idcontac* intdate numtbcont)
save ${tempfiles}\tbcontacts_wide, replace
<and then merged into the main file:>
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen
<the exposure contacts are processed separately first:>
reshape wide idcontac famcont contvil contplace trtdate trtdatex trtplace certtbcon wardvisit relship contaccon cough nurseill houseill sleepill contacind contaclong contacdays, i(ident frm_intdate) j(n)
rename * c*
rename (cident cidcontac* cfrm_intdate cnumtbcont) (ident idcontac* intdate numtbcont)
save ${tempfiles}\tbcontacts_wide, replace
<and then merged into the main file:>
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen