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
24680
Downloads
151
- Data files
- combined_tb_cases_controls_final
What relationship is this person to you [wide] (D) (crelship1)
Data file: combined_tb_cases_controls_final
Overview
Valid:
1673
Invalid:
11238
Type:
Discrete
Decimal:
0
Start:
1081
End:
1082
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 | 141 |
8.4%
|
| 2 | Neighbour | 91 |
5.4%
|
| 3 | Visitor to h/hold | 2 |
0.1%
|
| 4 | Friend | 20 |
1.2%
|
| 5 | Colleague at work | 17 |
1%
|
| 6 | Someone visited | 2 |
0.1%
|
| 7 | Other | 13 |
0.8%
|
| 8 | Self | 0 |
0%
|
| 9 | Parent/step-parent | 346 |
20.7%
|
| 10 | Spouse | 168 |
10%
|
| 11 | Sibling | 458 |
27.4%
|
| 12 | Child | 98 |
5.9%
|
| 13 | Uncle/aunt | 99 |
5.9%
|
| 14 | G/mother/father/step | 47 |
2.8%
|
| 15 | Mother/father-inlaw | 6 |
0.4%
|
| 16 | Sister/brother-inlaw | 30 |
1.8%
|
| 17 | Cousin | 35 |
2.1%
|
| 18 | Nephew/niece | 16 |
1%
|
| 19 | Wifemate | 2 |
0.1%
|
| 20 | Grandson/daughter | 2 |
0.1%
|
| 21 | Uncle/aunt in-law | 1 |
0.1%
|
| 22 | Son/daughter in-law | 2 |
0.1%
|
| 23 | Distant cousin/relation | 1 |
0.1%
|
| 98 | Unknown | 0 |
0%
|
| 99 | Missing | 76 |
4.5%
|
| Sysmiss | 11238 |
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