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
24508
Downloads
151
- Data files
- combined_tb_cases_controls_final
What relationship is this person to you [wide] (D) (crelship5)
Data file: combined_tb_cases_controls_final
Overview
Valid:
2
Invalid:
12909
Type:
Discrete
Decimal:
0
Start:
1089
End:
1090
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 | 0 |
0%
|
| 2 | Neighbour | 0 |
0%
|
| 3 | Visitor to h/hold | 0 |
0%
|
| 4 | Friend | 0 |
0%
|
| 5 | Colleague at work | 0 |
0%
|
| 6 | Someone visited | 0 |
0%
|
| 7 | Other | 0 |
0%
|
| 8 | Self | 0 |
0%
|
| 9 | Parent/step-parent | 0 |
0%
|
| 10 | Spouse | 0 |
0%
|
| 11 | Sibling | 1 |
50%
|
| 12 | Child | 0 |
0%
|
| 13 | Uncle/aunt | 0 |
0%
|
| 14 | G/mother/father/step | 1 |
50%
|
| 15 | Mother/father-inlaw | 0 |
0%
|
| 16 | Sister/brother-inlaw | 0 |
0%
|
| 17 | Cousin | 0 |
0%
|
| 18 | Nephew/niece | 0 |
0%
|
| 19 | Wifemate | 0 |
0%
|
| 20 | Grandson/daughter | 0 |
0%
|
| 21 | Uncle/aunt in-law | 0 |
0%
|
| 22 | Son/daughter in-law | 0 |
0%
|
| 23 | Distant cousin/relation | 0 |
0%
|
| 98 | Unknown | 0 |
0%
|
| 99 | Missing | 0 |
0%
|
| Sysmiss | 12909 |
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