combined_tb_cases_controls_final
DDI-MWI-MEIRU-TB-COMBINE-FINAL-2022-v01
Themba Chirwa
Elizabeth Nancy Munthali
Estelle McLean
Malawi Epidemiology and Intervention Research Unit
2022-04-07
Nesstar Publisher
Version 1 (April 2022)
combined_tb_cases_controls_final
TB cases (1974-2018) and controls (1998-2018) analytical dataset (Karonga)
MWI-MEIRU-TB-COMBINE-FINAL-2022-v01
Mia Crampin
Estelle McLean
MEIRU Core datamanagement team
2017-05-12
Nesstar Publisher
Estelle McLean
Demographic Surveillance
Data on TB cases and controls have been collected in 3 distinct eras, pre-2000, 2000-2007 and 2007-2018, and within these eras data have been stored on different tables. This dataset combines data from all of the tables to have one dataset for all TB cases and controls, including all their questionnaire, laboratory and outcome data.
Malawi
karonga, chilumba
Individual
Malawi Epidemiology and Intervention Research Unit
Face-to-face [f2f]
Added as external resources
Malawi Epidemiology and Intervention Research Unit
combined_tb_cases_controls_final.NSDstat
The interview data for TB cases from the 3 eras are appended together and merged to the 'tbcpu' file. This latter file is the results of an algorithm that goes through all the TB data and creates TB episodes and assigns them to a category of how likely the episode was actually TB (see documentation on tbcpu algorithm). Only episodes on the tbcpu file are kept so other questionnaire data are dropped. Questionnaire data on controls from the 3 eras are appended to the cases dataset. Existing variables are modified and new ones created using the data from the questionnaires and data on lab results, contacts, GPS coordinates and follow-up and outcomes which are merged in. In the variable labels (S) indicates that the variable is unchanged from the original source and (D) indicates that it is a 'derived' variable, often using more than one source variable. For both types information on where the data come from and how they are processed is found in the 'Recoding and Derivation' section
12911
394
Nesstar 200801
Malawi Epidemiology and Interventions Research Unit
unique identifier of person linkable to other studies
unique identifier of person linkable to other studies
12911
0
unique identifier of person linkable to other studies
variable: ident (table[s]: many of the tables link together on ident)
ident available from 1974 to 2018
whether person is a case or control (D)
whether person is a case or controlwhether person is a case or control
12911
0
whether person is a case or control
0
Control
3820
1
Case
9091
**TBX (CASES)
use ${newstata}\tbold_tbpart2, clear
rename * *_2
rename ident_2 ident
save ${tempfiles}\tbold_tbpart2, replace
use ${newstata}\tbold_tbpart1, clear /*data prior to 2000*/
merge m:1 ident using ${tempfiles}\tbold_tbpart2
gen intdiff=abs(intdate_2-intdate)
bys ident: egen mindiff=min(intdiff)
gen keep=1 if mindiff==intdiff & _m==3
desc *_2, varlist
foreach var in `r(varlist)' {
cap replace `var'=. if keep~=1
cap replace `var'="" if keep~=1
}
gen case=1
rename occhead occheadold
save ${tempfiles}\tbold_tbpart12, replace
use ${newstata}\tb_tbxto2007, clear /*data from 2000 to 2007*/
gen case=1
save ${tempfiles}\tb_tbxto2007, replace
use ${newstata}\tb_tbx, clear /*data from 2007 onwards*/
gen case=1
save ${tempfiles}\tb_tbx, replace
**TBO (CONTROLS)
use ${newstata}\tbold_control, clear /*data prior to 2000*/
gen case=0
rename occhead occheadold
save ${tempfiles}\tbold_control, replace
use ${newstata}\tb_tboto2007, clear /*data from 2000 to 2007*/
gen case=0
save ${tempfiles}\tb_tboto2007, replace
use ${newstata}\tb_tbo, clear /*data from 2007 onwards*/
gen case=0
save ${tempfiles}\tb_tbo, replace
use ${tempfiles}\tbold_tbpart12, clear
append using ${tempfiles}\tb_tbxto2007
rename smeacult smeacult_old
append using ${tempfiles}\tb_tbx
duplicates drop ident intdate, force
preserve
use ${newstata}\tbcpu, clear
duplicates drop ident intdate, force
keep ident tbtype tbcpu mic_res outcome intdate starteps fineps pos_cult
rename (mic_res outcome) (mic_resH outcome_cpu)
save ${tempfiles}\tbcpu_edit, replace
restore
merge 1:1 ident intdate using ${tempfiles}\tbcpu_edit, keep(match) nogen
append using ${tempfiles}\tbold_control
append using ${tempfiles}\tb_tboto2007
append using ${tempfiles}\tb_tbo
bys ident intdate (mohregno): keep if _n==_N
*add in crshse from residency episodes
preserve
use ident startdate stopdate crshse using ${gendata}\crs_residency_episodes_clean_nopoly, clear
save ${tempfiles}\reseps, replace
restore
drop _m
joinby ident using ${tempfiles}\reseps, unmatched(master)
gen crs=1 if intdate>=startdate & intdate
case available from 1974 to 2018
Type of control
Type of control
1950
10961
Type of control
1
Random
896
2
Spouse
36
3
Sick
322
4
ART Clinic
152
5
TSD
245
6
LIS
299
Sysmiss
10961
typind available from 2007 to 2014
If eligible for TB household study: has the patient consented?
If eligible for TB household study: has the patient consented?
12911
0
If eligible for TB household study: has the patient consented?
0
No
12297
1
Yes
614
8
Unknown
0
9
Missing
0
variable: hhcons (table[s]: tb_tbx)
hhcons available from 1974 to 2018
In Spouse study (D)
In Spouse study
12911
0
In Spouse study
0
No
12634
1
Yes
277
8
Unknown
0
9
Missing
0
In EU immunology study (D)
In EU immunology study
12911
0
In EU immunology study
0
No
11861
1
Yes
1050
8
Unknown
0
9
Missing
0
In Gates immunology study (D)
In Gates immunology study
12911
0
In Gates immunology study
0
No
12549
1
Yes
362
8
Unknown
0
9
Missing
0
unique identifier of person not linkable to other studies
unique identifier of person not linkable to other studies
6058
0
unique identifier of person not linkable to other studies
unique identifier of palm vein registration study
unique identifier of palm vein registration study
967
0
unique identifier of palm vein registration study
date of interview
date of interview
12911
1974-06-15
2018-07-24
date of interview
annual follow-up
annual follow-up
1136
11775
annual follow-up
0
No
531
1
Yes
605
8
Unknown
0
9
Missing
0
Sysmiss
11775
version of form
version of form
6858
6053
version of form
Version of outcome form
Version of outcome form
3955
8956
unique identifier of informant linkable to other studies
unique identifier of informant linkable to other studies
455
0
type of informant (D)
what is the type of informant ?
8845
4066
1
Self
7736
2
Parent
613
3
Child/niece/nephew/grandchild
54
4
Sibling/cousin
163
5
Spouse
123
6
In-law
35
7
Grandparent/Aunt/Uncle
116
8
Non-relative
5
Sysmiss
4066
Date of birth (D)
Date of birth
12910
Sex
Sex
12910
1
0
Male
6502
1
Female
6408
8
Unknown
0
9
Missing
0
Sysmiss
1
Sex ( whether female or male)
Impossible to ask marital history and pregnancy questions
If it was impossible to ask these questions [marital history and pregnancy], tick here
1
12910
0
No
0
1
Yes
1
8
Unknown
0
9
Missing
1760
Sysmiss
11150
Marital status (D)
Marital status
6768
6143
0
Never married
541
1
Married
4519
2
Divorced/separated
753
3
Widowed
588
4
previously married
367
8
Unknown
0
9
Missing
46
Sysmiss
6097
Ever been to school (D)
Ever been to school?
7202
5709
0
Never
539
1
Current
433
2
Ever
6230
8
Unknown
0
9
Missing
10
Sysmiss
5699
Highest schooling type (D)
Highest schooling type
6659
6252
0
None
0
1
Primary
4873
2
Secondary
1681
3
Tertiary
105
4
Higher
0
8
Unknown
0
9
Missing
3
Sysmiss
6249
Highest schooling standard (D)
Highest schooling standard
6206
6705
98
Unknown
99
Missing
Do you stay away from your usual household to attend school?
Do you stay away from your usual household to attend school?
113
12798
0
No
101
1
Yes
12
8
Unknown
0
9
Missing
10
Sysmiss
12788
If yes [to staying away for school], how many years so far?
If yes [to staying away for school], how many years so far?
10
12901
98
Unknown
99
Missing
Employment code
Employment code
5401
7510
0
Not applicable
98
11
Full-time educaton
323
12
Unable to work
5
13
Retired
14
14
Looking for work
13
19
Other
8
20
Housework
491
30
Employer no sub-category
1
31
Runs own business
1
33
????
0
41
In cash economy
810
42
Subsistence economy
2942
49
Own account don't know payment
5
51
Salary (monthly)
526
52
Wage (weekly)
46
53
Casual or piecework
109
54
Unpaid worker
6
59
Employee don't know payment
1
99
No information
2
998
Unknown
0
999
Missing
55
Sysmiss
7455
Main occupation (D)
Main occupation
7098
5813
0
Not working
1139
11
Teachers, nurses, clergy, writers
0
12
Teachers
116
13
Health professionals
30
14
Clergy
11
19
Other professionals
50
22
Managing small family business
0
23
Management in large organisations
31
24
Small family business
293
25
Commercial farmer
9
26
Traditional authority
3
30
Small trader/store keeper
0
31
Desk, shop or official outdoor jobs
0
32
Small trader/store
283
33
Office worker
51
34
Barman/girl, waiter
22
35
Sales assistant
32
36
Army/police
14
37
Clinical assistants
27
39
Other non-manual
17
41
Modern skills
0
42
Traditional craft
0
43
Crafts and related skills
264
44
Driver/assistant driver
82
45
African Doctor/herbalist
20
49
Other skilled manual
76
51
Agriculture
0
52
Other manual work
0
53
Subsistence farmer
4093
54
Herdsman
5
55
Fisherman
143
56
Labourer
96
57
Security guard/watchman
112
58
House boy/girl
18
59
Other unskilled manual
61
98
Unknown
0
99
Missing
57
Sysmiss
5756
variable: occ (table[s]: tb_tbx, tbold_part1/2, tb_tbo, tb_tboto2007, tbold_control)
Categorised occupation variable (D)
Categorised occupation variable
7098
5813
0
Not working
1139
1
student
0
2
unskilled manual (irr wage)
142
3
farmer
4098
4
fisherman
143
5
skilled manual (irr wage)
305
6
non-manual (irr wage)
28
7
small trader/business
283
8
unskilled manual (reg wage)
145
9
skilled manual (reg wage)
137
10
non-manual (reg wage)
43
11
professional
635
Sysmiss
5813
Categorised occ/emp variable (D)
Categorised occ/emp variable
7098
5813
1
Low
1281
2
Medium
4574
3
High
1243
Sysmiss
5813
variable: occgp [categorised occupation] (table[s]: derived variable)
describe industry (if not in agriculture/ forestry):
describe industry (if not in agriculture/ forestry):
809
12102
0
278
11
Agriculture & forestry
371
12
Fishing
25
13
Mining
0
19
Primary producers not classified
0
21
Food processing & sales
4
22
Drink processing & sales
6
31
Building & road construction
18
32
Mining & industrial manufacturing
1
33
Workshop & domestic production
13
37
Not classified
0
39
Manufacturing construction and repair not classified
0
40
0
41
2
42
0
43
Electricity
0
44
Telephone
2
45
Transport
4
49
Transport and utilities not classified
0
51
Petty, retail & wholesale
30
52
Retail
2
53
Wholesale
0
54
Financial
0
59
Trade not classified
1
61
Health
6
62
Personal & domestic
7
63
Government & security
21
64
Education & pastoral
14
65
Information & entertainment
2
69
Public service not classified
1
70
No sub-category available
0
90
Unclassifiable no sub-category available
0
99
Unclassifiable no information
1
998
Unknown
0
999
Missing
2
Sysmiss
12100
Did you formally train in this occupation?
Did you formally train in this occupation?
488
12423
0
No
434
1
Yes
54
8
Unknown
0
9
Missing
46
Sysmiss
12377
How many people do you employ in your main occupation?
How many people do you employ in your main occupation?
457
12454
98
Unknown
99
Missing
Do you have a formal qualification for the work you do in your main occupation?
Do you have a formal qualification for the work you do in your main occupation?
3431
9480
0
No
3156
1
Yes
275
8
Unknown
0
9
Missing
645
Sysmiss
8835
Employment code [of household head]
Employment code [of household head]
4440
8471
0
Not applicable
10
11
Full-time educaton
4
12
Unable to work
12
13
Retired
31
14
Looking for work
1
19
Other
3
20
Housework
11
30
Employer no sub-category
4
31
Runs own business
2
33
????
0
41
In cash economy
633
42
Subsistence economy
2919
49
Own account don't know payment
6
51
Salary (monthly)
690
52
Wage (weekly)
33
53
Casual or piecework
71
54
Unpaid worker
7
59
Employee don't know payment
1
99
No information
2
998
Unknown
0
999
Missing
92
Sysmiss
8379
Main occuption of household head (D)
Main occuption of household head
6174
6737
0
Not working
75
11
Teachers, nurses, clergy, writers
0
12
Teachers
162
13
Health professionals
50
14
Clergy
19
19
Other professionals
43
22
Managing small family business
0
23
Management in large organisations
62
24
Small family business
128
25
Commercial farmer
12
26
Traditional authority
4
30
Small trader/store keeper
0
31
Desk, shop or official outdoor jobs
1
32
Small trader/store
302
33
Office worker
53
34
Barman/girl, waiter
26
35
Sales assistant
19
36
Army/police
48
37
Clinical assistants
52
39
Other non-manual
29
41
Modern skills
0
42
Traditional craft
2
43
Crafts and related skills
256
44
Driver/assistant driver
98
45
African Doctor/herbalist
17
49
Other skilled manual
100
51
Agriculture
2
52
Other manual work
2
53
Subsistence farmer
4118
54
Herdsman
3
55
Fisherman
170
56
Labourer
82
57
Security guard/watchman
160
58
House boy/girl
12
59
Other unskilled manual
67
98
Unknown
0
99
Missing
97
Sysmiss
6640
variable: occhead [household head occupation] (table[s]: tb_tbx, tb_tbxto2007, tbold_part1/2, tb_tbo, tb_tboto2007, tbold_control)
Categorised occupation variable of household head (D)
Categorised occupation variable of household head
6174
6737
0
Not working
75
1
student
0
2
unskilled manual (irr wage)
155
3
farmer
4121
4
fisherman
170
5
skilled manual (irr wage)
334
6
non-manual (irr wage)
36
7
small trader/business
302
8
unskilled manual (reg wage)
168
9
skilled manual (reg wage)
141
10
non-manual (reg wage)
39
11
professional
633
Sysmiss
6737
Categorised occ/emp variable of household head (D)
Categorised occ/emp variable of household head
6174
6737
1
Low
230
2
Medium
4661
3
High
1283
Sysmiss
6737
variable: occgphead [categorised occupation of household head] (table[s]: derived variable)
Does household head have a formal qualification for main occupation?
Does household head have a formal qualification for main occupation?
2003
10908
0
No
1814
1
Yes
189
8
Unknown
0
9
Missing
395
Sysmiss
10513
describe industry (if not in agriculture/ forestry) [of household head]
describe industry (if not in agriculture/ forestry) [of household head]
2060
10851
0
26
11
Agriculture & forestry
1361
12
Fishing
78
13
Mining
0
19
Primary producers not classified
2
21
Food processing & sales
32
22
Drink processing & sales
12
31
Building & road construction
52
32
Mining & industrial manufacturing
2
33
Workshop & domestic production
43
37
Not classified
0
39
Manufacturing construction and repair not classified
1
40
0
41
14
42
0
43
Electricity
5
44
Telephone
1
45
Transport
27
49
Transport and utilities not classified
3
51
Petty, retail & wholesale
119
52
Retail
6
53
Wholesale
1
54
Financial
1
59
Trade not classified
10
61
Health
37
62
Personal & domestic
15
63
Government & security
112
64
Education & pastoral
75
65
Information & entertainment
7
69
Public service not classified
3
70
No sub-category available
0
90
Unclassifiable no sub-category available
12
99
Unclassifiable no information
3
998
Unknown
0
999
Missing
26
Sysmiss
10825
Whether household head is formally trained in occupation (D)
Whether household head is formally trained in occupation
1679
11232
0
No
1443
1
Yes
236
8
Unknown
0
9
Missing
241
Sysmiss
10991
How many people does he/she employ in your main occupation? [household head]
How many people does he/she employ in your main occupation? [household head]
1516
11395
98
Unknown
99
Missing
whether mother is still alive
4582
8329
1
Alive
2617
2
Dead
1965
8
Unknown
0
9
Missing
63
Sysmiss
8266
year of mother's death (D)
1855
11056
9998
Unknown
9999
Missing
whether year of mother's death is an estimate (D)
Is the year of mother's death is an estimate ?
1855
11056
0
No
1830
1
Yes
25
8
Unknown
0
9
Missing
0
Sysmiss
11056
whether father is still alive
4555
8356
1
Alive
1711
2
Dead
2844
8
Unknown
0
9
Missing
90
Sysmiss
8266
year of father's death (D)
2679
10232
9998
Unknown
9999
Missing
whether year of father's death is an estimate (D)
Is the year of fatherr's death is an estimate ?
2844
10067
0
No
2807
1
Yes
37
8
Unknown
0
9
Missing
0
Sysmiss
10067
Ever treated for TB previously (D)
Ever treated for TB previously?
12529
382
0
No
11452
1
Yes
1077
8
Unknown
0
9
Missing
213
Sysmiss
169
Year previously treated for TB (D)
If (pretrttb) is yes, Year previously treated for TB
1002
11909
Whether year of past TB treatment is estimated (D)
Is the year of past TB treatment is estimated
1002
11909
0
No
988
1
Yes
14
8
Unknown
0
9
Missing
0
Sysmiss
11909
Where were you treated? [in the past for TB]
Where were you treated? [in the past for TB]?
1015
0
Type of TB (from tbcpu combined file) (D)
Type of TB (from tbcpu combined file)
9091
3820
1
Pulmonary only
7236
2
Lymph node only
419
3
Extra pulmonary only
784
4
Pulmonary & lymph node
103
5
Pulmonary & extra pulmonary
153
6
Lymph node & extra pulmonary
32
7
All three
2
8
Other
362
9
Missing
0
Sysmiss
3820
variable: tbtype (table[s]: tbcpu [derived table])
Whether TB is confirmed, probably or unknown (from tbcpu combined file) (D)
Is TB confirmed, probably or unknown (from tbcpu combined file)
8729
4182
1
Confirmed
3043
2
Probable
2095
3
Unlikely
3591
Sysmiss
4182
variable: tbcpu (table[s]: tbcpu [derived table])
Highest microscopy result (from tbcpu combined file) (D)
Highest microscopy result (from tbcpu combined file)
4222
8689
0
Negative
0
1
Positive
4222
Sysmiss
8689
variable: mic_res [microscopy result] (table[s]: tbcpu [derived table])
at least one positive culture during episode (from tbcpu combined file) (D)
at least one positive culture during episode (from tbcpu combined file)
9091
3820
0
No
5341
1
Yes
3750
8
Unknown
0
9
Missing
0
Sysmiss
3820
variable: pos_cult [culture positive] (table[s]: tbcpu [derived table])
Outcome (from tbcpu combined file) (D)
Outcome (from tbcpu combined file)
8926
3985
1
Treatment completed
5561
2
Died
2190
3
Transfered out
361
4
Failure
19
5
Lost/defaulted
749
8
Unknown
46
9
Missing
32
Sysmiss
3953
variable: outcome_cpu (table[s]: tbcpu [derived table])
Start of TB episode (from tbcpu combined file) (D)
Start of TB episode (from tbcpu combined file)
9091
variable: starteps (table[s]: tbcpu [derived table])
End of TB episode (from tbcpu combined file) (D)
End of TB episode (from tbcpu combined file)
9091
variable: fineps (table[s]: tbcpu [derived table])
Start date of treatment (D)
Start date of treatment
8484
Whether treatstartdate is estimated (D)
Whether treatstartdate is estimated
2620
10291
1
Full date known
0
2
Day unknown
2597
3
Month unknown
0
4
Day and month unknown
23
8
Not known at all
0
9
Missing
0
Sysmiss
10291
Illness onset date (D)
Illness onset date
8257
if illness onset date is an estimate (D)
if illness onset date is an estimate
8257
4654
1
Full date known
0
2
Day unknown
7520
3
Month unknown
0
4
Day and month unknown
736
5
1
8
Not known at all
0
9
Missing
0
Sysmiss
4654
Certainty of illness timing (D)
Certainty of illness timing
2847
10064
0
Unsure/unlikely
243
1
Certain
2291
2
Probable
313
8
Unknown
0
9
Missing
36
Sysmiss
10028
Have you been coughing?
Have you been coughing?
6723
6188
0
No
2798
1
Yes
3925
8
Unknown
0
9
Missing
9
Sysmiss
6179
Coughing onset date (D)
If (cough) is yes, Coughing onset date
8694
1959-06-15
2018-06-15
if coughing onset date is an estimate (D)
if coughing onset date is an estimate
8295
4616
1
Full date known
0
2
Day unknown
4737
3
Month unknown
0
4
Day and month unknown
3401
5
157
8
Not known at all
0
9
Missing
0
Sysmiss
4616
Have you had swollen glands?
Have you had swollen glands?
3683
9228
0
No
3404
1
Yes
278
8
Unknown
1
9
Missing
288
Sysmiss
8940
Date of onset of swollen glands (D)
Date of onset of swollen glands
278
whether onset date of swollen glands is an estimate (D)
whether onset date of swollen glands is an estimate
278
12633
1
Full date known
0
2
Day unknown
268
3
Month unknown
0
4
Day and month unknown
10
8
Not known at all
0
9
Missing
0
Sysmiss
12633
Date first seeing health practitioner for illness (D)
Date first seeing health practitioner for illness
5817
Whether firsthpdate is estimated (D)
Whether firsthpdate is estimated
5577
7334
1
Full date known
2190
2
Day unknown
3293
3
Month unknown
0
4
Day and month unknown
94
8
Not known at all
0
9
Missing
0
Sysmiss
7334
Which type of health practitioner did you go to first?
Which type of health practitioner did you go to first?
5754
7157
1
Traditional healer (ng'anga)
328
2
Health centre
2034
3
Private clinic
749
4
Hospital
2528
5
KPS
115
8
Unknown
0
9
Missing
267
Sysmiss
6890
if first traditional healer: When first go to a health centre/clinic/hospital?
if first traditional healer: When first go to a health centre/clinic/hospital?
325
Whether hcdate is estimated
Whether hcdate is estimated
228
12683
1
Full date known
0
2
Day unknown
226
3
Month unknown
0
4
Day and month unknown
2
8
Not known at all
0
9
Missing
0
Sysmiss
12683
Who first suggested you might have TB?
Who first suggested you might have TB?
5810
7101
1
Self
1265
2
Family
957
3
Friends
137
4
Neighbours
53
5
Traditional healer
21
6
Health centre
2138
7
KPS staff
1095
8
Don't know/can't recall
70
9
Other
74
98
Unknown
0
99
Missing
13
Sysmiss
7088
How were you referred to hospital?
How were you referred to hospital?
5716
7195
1
Direct
1369
2
Via KPS at H/C etc.
2381
3
Via H/C not KPS
1412
4
Private clinic not KPS
125
5
Via traditional healer
17
6
Via KPS not at H/C
66
7
Via KPS doctor
180
8
Transfer in
166
98
Unknown
0
99
Missing
89
Sysmiss
7106
Have you at any point been bedridden with this illness?
Have you at any point been bedridden with this illness?
3957
8954
0
No
3281
1
Yes
676
8
Unknown
0
9
Missing
14
Sysmiss
8940
Site of TB [1]
Site of TB
9090
3821
0
Other
332
1
Lungs
6972
2
Pleura
495
3
Intrathoracic Lymph
35
4
Other Lymph Node
398
5
Skin (lupus vulgaris)
10
6
Meningitis
50
7
Miliary
104
8
Abdominal
136
9
Bone and joint
194
10
Clinical trial
65
11
Child contact
1
12
Reactive mantoux only
0
98
unknown
298
99
Missing
0
Sysmiss
3821
Site of TB [2]
Site of TB
306
12605
0
Other
69
1
Lungs
3
2
Pleura
93
3
Intrathoracic Lymph
10
4
Other Lymph Node
42
5
Skin (lupus vulgaris)
0
6
Meningitis
2
7
Miliary
35
8
Abdominal
14
9
Bone and joint
7
10
Clinical trial
16
11
Child contact
7
12
Reactive mantoux only
7
98
unknown
1
99
Missing
0
Sysmiss
12605
Site of TB [3]
Site of TB
6
12905
0
Other
2
1
Lungs
0
2
Pleura
0
3
Intrathoracic Lymph
2
4
Other Lymph Node
0
5
Skin (lupus vulgaris)
0
6
Meningitis
0
7
Miliary
0
8
Abdominal
1
9
Bone and joint
1
10
Clinical trial
0
11
Child contact
0
12
Reactive mantoux only
0
98
unknown
0
99
Missing
0
Sysmiss
12905
Smear positivity
Smear positivity
2758
10153
1
Smear postive by KPS
1292
2
Smear positive by KDH
203
3
Culture positive by KPS
154
4
Unknown cult, smear neg
461
5
Other
648
8
Unknown
0
9
Missing
0
Sysmiss
10153
Smear positivity (D)
Smear positivity
3948
8963
1
Smear
2143
2
Culture
278
3
Other
1296
8
Unknown
231
9
Missing
136
Sysmiss
8827
variable: smeacult (table[s]: tb_tbx, tb_tbxto2007)
Microscopy result at diagnosis (D)
Microscopy result at diagnosis
5726
7185
0
Negative
1947
1
Positive
3779
8
Unknown
0
9
Missing
0
Sysmiss
7185
Microscopy result 2 months after diagnosis (D)
Microscopy result 2 months after diagnosis
2051
10860
0
Negative
1704
1
Positive
347
Sysmiss
10860
Microscopy result within 2 months of treatment completion (D)
Microscopy result within 2 months of treatment completion
2387
10524
0
Negative
2354
1
Positive
33
Sysmiss
10524
Culture result at diagnosis (D)
Culture result at diagnosis
5402
7509
0
Negative
2496
1
Positive
2906
Sysmiss
7509
Culture result 2 months after diagnosis (D)
Culture result 2 months after diagnosis
1075
11836
0
Negative
1037
1
Positive
38
Sysmiss
11836
Culture result within 2 months of treatment completion (D)
Culture result within 2 months of treatment completion
1890
11021
0
Negative
1868
1
Positive
22
Sysmiss
11021
Whether patient was resistant to streptomycin at treatment start (D)
Whether patient was resistant to streptomycin at treatment start
1046
11865
0
No
958
1
Yes
88
8
Unknown
0
9
Missing
0
Sysmiss
11865
Whether patient was resistant to isoniazid at treatment start (D)
Whether patient was resistant to isoniazid at treatment start
2774
10137
0
No
2556
1
Yes
218
8
Unknown
0
9
Missing
0
Sysmiss
10137
Whether patient was resistant to rifampicin at treatment start (D)
Whether patient was resistant to rifampicin at treatment start
2777
10134
0
No
2749
1
Yes
28
8
Unknown
0
9
Missing
0
Sysmiss
10134
Whether patient was resistant to ethambutol at treatment start (D)
Whether patient was resistant to ethambutol at treatment start
1141
11770
0
No
1130
1
Yes
11
8
Unknown
0
9
Missing
0
Sysmiss
11770
Whether patient was resistant to pyrazinamide at treatment start (D)
Whether patient was resistant to pyrazinamide at treatment start
447
12464
0
No
434
1
Yes
13
8
Unknown
0
9
Missing
0
Sysmiss
12464
Whether patient was resistant to ciprofloxacin at treatment start (D)
Whether patient was resistant to ciprofloxacin at treatment start
69
12842
0
No
69
1
Yes
0
8
Unknown
0
9
Missing
0
Sysmiss
12842
Date of biopsy (D)
Date of biopsy
202
Tissue biopsied (D)
Tissue biopsied
202
12709
1
Breast lump
0
2
Lymph node
192
3
Salivary gland
1
4
Skin
9
5
???
0
8
Unknown
0
9
Missing
0
Sysmiss
12709
Disease identified through biopsy (D)
Disease identified through biopsy
188
12723
1
Actrophy
0
2
Adoema
0
3
Adenocarcinoma
0
4
Benign epidermoid cyst
0
5
Benign fibroadenoma
0
6
Eosb reactive
0
7
Fibrosis
0
8
Hodgkin's lymphoma
0
10
Kaposi sarcoma
3
11
Metastatic carcinoma
0
12
Non hodgkin lymphoma
0
13
Pyogenic granulomas
0
14
Plexiform neurofibroma
0
15
Reactive hyperplasia
3
16
Subcutaneous tissue
0
17
TB
182
18
???
0
88
Unknown
0
99
Missing
0
9
Inflammation
1
Sysmiss
12722
Certainty of biopsy diagnosis (D)
Certainty of biopsy diagnosis
201
12710
0
uncertain
0
1
confirmed beyond reasonable doubt
164
2
suggestive but not diagnostic / pathognomonic
16
3
pathological and possibly leprosy
2
4
pathological bur non-specific
8
5
normal tissue
1
6
pathological and indicative of some other disease
7
7
other/ unforeseen circumstances
3
8
unknown
0
9
missing
0
Sysmiss
12710
Was Xpert MTB/RIF done?
Was Xpert MTB/RIF done?
908
12003
0
No
747
1
Yes
161
8
Unknown
0
9
Missing
44
Sysmiss
11959
What was the indication for doing Xpert MTB/RIF?
What was the indication for doing Xpert MTB/RIF?
155
12756
1
34
2
TB suspect-Hospitalized
38
3
TB suspect-New
78
4
Other
5
8
Unknown
0
9
Missing
6
Sysmiss
12750
What was the result of Xpert MTB?
What was the result of Xpert MTB?
158
12753
0
MTB neg
32
1
MTB pos
126
8
Unknown
0
9
Missing
3
Sysmiss
12750
What was the result of Xpert RIF?
What was the result of Xpert RIF?
121
12790
0
RIF not detected
105
1
RIF detected
16
8
Unknown
0
9
Missing
40
Sysmiss
12750
Was chest x-ray done?
Was chest x-ray done?
2594
10317
0
No
1489
1
Yes
1105
8
Unknown
0
9
Missing
162
Sysmiss
10155
Was it diagnostic of TB?
Was it diagnostic of TB?
1074
11837
0
No
114
1
Yes
960
8
Unknown
0
9
Missing
32
Sysmiss
11805
If lymphnode TB only, is diagnosis confirmed by histology?
If lymphnode TB only, is diagnosis confirmed by histology?
163
12748
0
No
143
1
Yes
20
8
Unknown
0
9
Missing
0
Sysmiss
12748
Hb result
Hb result
4331
8580
5
6
6
26
7
63
8
136
10
806
11
1150
12
663
13
305
14
89
98
Unknown
0
99
Missing
1087
9
285
Sysmiss
8295
ICT result
ICT result
10
12901
0
Negative
7
1
Positive
3
2
Doubtful
0
3
Refused to answer
0
4
Indeterminate
0
7
Not applicable
0
8
Unknown
0
9
Missing
1995
Sysmiss
10906
Current TB treatment Centre
Current TB treatment Centre
435
0
Date registered at current TB treatment centre
Date registered at current TB treatment centre
435
Treatment centre registered (at initially)
Treatment centre registered (at initially)
435
0
Anti-tuberculous treatment
Anti-tuberculous treatment
3783
9128
1
Short course ( 6 months) (catl)
2894
2
Standard course
367
3
Extrapulmonary
8
4
Retreament (Cat ll)
394
5
TB Meningitis
52
6
MDR-TB
8
7
Other
60
8
Unknown
0
9
Missing
19
Sysmiss
9109
Place treatment started
Place treatment started
2590
10321
1
Hospital
1466
2
Home
1124
8
Unknown
0
9
Missing
19
Sysmiss
10302
Whether intensive phase drug regimen is estimated (D)
Whether intensive phase drug regimen is estimated
6866
6045
0
No
1704
1
Yes
5162
8
Unknown
0
9
Missing
0
Sysmiss
6045
Whether continuation phase drug regimen is estimated (D)
Whether continuation phase drug regimen is estimated
6841
6070
0
No
1320
1
Yes
5521
8
Unknown
0
9
Missing
0
Sysmiss
6070
drug regimen of intensive phase (D)
drug regimen of intensive phase
6866
0
drug regimen of continuation phase (D)
drug regimen of continuation phase
6841
0
length of intensive phase estimated (D)
length of intensive phase estimated
6624
6287
length of continuation phase estimated (D)
length of continuation phase estimated
6624
6287
Was treatment changed during intensive phase?
Was treatment changed during intensive phase?
8643
4268
0
No
7744
1
Yes
163
7
736
8
Unknown
0
9
Missing
84
Sysmiss
4184
Treatment change in intensive phase (D)
Treatment change in intensive phase
16
0
If yes, why? [treatment change in intensive phase]
If yes, why? [treatment change in intensive phase]
19
12892
1
Out of stock
0
2
Stevens-Johnson syndrome
1
3
Other drug reaction
4
4
Drug resistance
1
5
Other (specify)
13
8
Unknown
0
9
Missing
0
Sysmiss
12892
Was treatment changed during continuation phase?
Was treatment changed during continuation phase?
5733
7178
0
No
4361
1
Yes
23
7
899
8
Unknown
0
9
Missing
450
Sysmiss
7178
Treatment change in continuation phase (D)
Treatment change in continuation phase
20
0
If yes, why? [treatment change in continuation phase]
If yes, why? [treatment change in continuation phase]
21
12890
1
Out of stock
1
2
Stevens-Johnson syndrome
0
3
Other drug reaction
0
4
Drug resistance
4
5
Other (specify)
16
8
Unknown
0
9
Missing
2
Sysmiss
12888
unique identifier of head of household linkable to other studies
unique identifier of head of household linkable to other studies
3765
0
current house
current house
5843
0
Current village
Current village
9122
0
current ghhid (D)
current ghhid
1952
0
CRS member at time of interview (D)
CRS member at time of interview
657
12254
CRSHSE id at time of interview (D)
CRSHSE id at time of interview
657
0
GPS based on village or household (D)
GPS based on village or household
10219
2692
1
Household
2877
2
Village
7342
Sysmiss
2692
current GPS coord (south degrees) (D)
current GPS coord (south degrees)
10219
2692
current GPS coord (south minute) (D)
current GPS coord (south minute)
10219
2692
current GPS coord (east degrees) (D)
current GPS coord (east degrees) (
10219
2692
current GPS coord (east minutes) (D)
current GPS coord (east minutes)
10219
2692
Date of joining/becoming head of current household (D)
Date of joining/becoming head of current household
8955
Whether date of joining current household is an estimate (D)
Whether date of joining current household is an estimate
8955
3956
1
Full date known
0
2
Day unknown
3370
3
Month unknown
0
4
Day and month unknown
5401
5
184
8
Not known at all
0
9
Missing
0
Sysmiss
3956
Reason for joining
Reason for joining
4775
8136
1
Marriage
2919
2
Divorce/separation
449
3
Widowhood
345
4
Visiting
11
5
School/training (start or end)
45
6
Work/employment (start or end)
107
7
Sickness (own)
427
8
Nursing (someone else)
6
9
Death/bereavement
141
10
Returning family member (no more specific cause known)
65
11
Quarrel (family or neighbourhood)
0
12
Attending ceremony (funeral, wedding, etc.)
1
13
Environmental/foreign/outside reason (e.g. refugee, house collapse)
6
14
Joining relative's household (no more specific reason known)
138
15
Retirement
1
16
Improved living conditions
89
17
Born in the same family
6
18
Other
19
98
Unknown
0
99
Missing
374
Sysmiss
7762
Position in household
Position in household
5456
7455
0
Prisoner
0
1
Head
2565
2
Member
2701
3
Visitor
119
4
Itinerant
0
5
Employed worker or servant
11
6
Renter
5
7
Institutional member
6
8
Non member relative
49
9
Patient
0
10
Relative of employed worker or renter
0
98
Unknown
0
99
Missing
0
Sysmiss
7455
Previous village (D)
Previous village
5422
0
Have you lived in another household during the last five years?
Have you lived in another household during the last five years?
6677
6234
0
No
4861
1
Yes
1816
8
Unknown
0
9
Missing
55
Sysmiss
6179
Give the most recent: Previous household Village1
Give the most recent: Previous household Village1
3249
0
Date started living in previous village 1 (D)
Date started living in previous village 1
3196
Whether date started living in previous village 1 is an estimate (D)
Whether date started living in previous village 1 is an estimate
3196
9715
1
Full date known
0
2
Day unknown
678
3
Month unknown
0
4
Day and month unknown
2506
5
12
8
Not known at all
0
9
Missing
0
Sysmiss
9715
Date stopped living in previous village 1 (D)
Date stopped living in previous village 1
3254
Whether date stopped living in previous village 1 is an estimate (D)
Whether date stopped living in previous village 1 is an estimate
3254
9657
1
Full date known
0
2
Day unknown
2137
3
Month unknown
0
4
Day and month unknown
1117
8
Not known at all
0
9
Missing
0
Sysmiss
9657
why did you leave? [previous village 1]
why did you leave? [previous village 1]
1869
11042
1
Marriage
241
2
Divorce/Separation
169
3
Widowhood
228
4
Visiting
3
5
School/training (start or end)
45
6
Work/employment (start or end)
46
7
Illness/sickness (own)
463
8
Others
651
98
Unknown
23
99
Missing
278
Sysmiss
10764
Give the most recent: Previous household Village2
Give the most recent: Previous household Village2
520
0
Date started living in previous village 1 (D)
Date started living in previous village 1
518
Whether date started living in previous village 1 is an estimate (D)
Whether date started living in previous village 1 is an estimate
518
12393
1
Full date known
0
2
Day unknown
240
3
Month unknown
0
4
Day and month unknown
277
5
1
8
Not known at all
0
9
Missing
0
Sysmiss
12393
Date stopped living in previous village 2 (D)
Date stopped living in previous village 2
520
Whether date stopped living in previous village 2 is an estimate (D)
Whether date stopped living in previous village 2 is an estimate
520
12391
1
Full date known
0
2
Day unknown
364
3
Month unknown
0
4
Day and month unknown
156
8
Not known at all
0
9
Missing
0
Sysmiss
12391
why did you leave? [previous village 2]
why did you leave? [previous village 2]
440
12471
1
Marriage
49
2
Divorce/Separation
30
3
Widowhood
72
4
Visiting
1
5
School/training (start or end)
11
6
Work/employment (start or end)
17
7
Illness/sickness (own)
71
8
Others
185
98
Unknown
4
99
Missing
80
Sysmiss
12391
Give the most recent: Previous household Village3
Give the most recent: Previous household Village3
127
0
Date started living in previous village 3 (D)
Date started living in previous village 3
127
Whether date started living in previous village 3 is an estimate (D)
Whether date started living in previous village 3 is an estimate
127
12784
1
Full date known
0
2
Day unknown
71
3
Month unknown
0
4
Day and month unknown
56
8
Not known at all
0
9
Missing
0
Sysmiss
12784
Date stopped living in previous village 3 (D)
Date stopped living in previous village 3
127
Whether date stopped living in previous village 3 is an estimate (D)
Whether date stopped living in previous village 3 is an estimate
127
12784
1
Full date known
0
2
Day unknown
90
3
Month unknown
0
4
Day and month unknown
37
8
Not known at all
0
9
Missing
0
Sysmiss
12784
why did you leave? [previous village 3]
why did you leave? [previous village 3]
106
12805
1
Marriage
12
2
Divorce/Separation
5
3
Widowhood
26
4
Visiting
0
5
School/training (start or end)
8
6
Work/employment (start or end)
4
7
Illness/sickness (own)
15
8
Others
36
98
Unknown
0
99
Missing
21
Sysmiss
12784
Give the most recent: Previous household Village4
Give the most recent: Previous household Village4
22
0
Date started living in previous village 4 (D)
Date started living in previous village 4
22
Whether date started living in previous village 4 is an estimate (D)
Whether date started living in previous village 4 is an estimate
22
12889
1
Full date known
0
2
Day unknown
14
3
Month unknown
0
4
Day and month unknown
8
8
Not known at all
0
9
Missing
0
Sysmiss
12889
Date stopped living in previous village 4 (D)
Date stopped living in previous village 4
22
Whether date stopped living in previous village 4 is an estimate (D)
Whether date stopped living in previous village 4 is an estimate
22
12889
1
Full date known
0
2
Day unknown
16
3
Month unknown
0
4
Day and month unknown
6
8
Not known at all
0
9
Missing
0
Sysmiss
12889
why did you leave? [previous village 4]
why did you leave? [previous village 4]
22
12889
1
Marriage
0
2
Divorce/Separation
2
3
Widowhood
4
4
Visiting
0
5
School/training (start or end)
0
6
Work/employment (start or end)
0
7
Illness/sickness (own)
3
8
Others
7
98
Unknown
1
99
Missing
5
Sysmiss
12889
living in (current household) when you became unwell with this illness?
living in (current household) when you became unwell with this illness?
3971
8940
0
No
630
1
Yes
3310
8
Unknown
0
9
Missing
31
Sysmiss
8940
ghhid of household1
ghhid of household1
171
0
Start date of living in house where became ill (if not current house) (D)
Start date of living in house where became ill (if not current house)
684
Whether illhsefrdate1 is an estimate (D)
Whether illhsefrdate1 is an estimate
1734
11177
1
Full date known
0
2
Day unknown
1369
3
Month unknown
0
4
Day and month unknown
358
5
7
8
Not known at all
0
9
Missing
0
Sysmiss
11177
Stop date of living in house where became ill (if not current house) (D)
Stop date of living in house where became ill (if not current house)
696
Whether illhsetodate1 is an estimate (D)
Whether illhsetodate1 is an estimate
660
12251
1
Full date known
0
2
Day unknown
580
3
Month unknown
0
4
Day and month unknown
80
8
Not known at all
0
9
Missing
0
Sysmiss
12251
If no: Which village living in when you became unwell?
If no: Which village living in when you became unwell?
427
0
Why did you leave? [household where became ill, if not current house]
Why did you leave? [household where became ill, if not current house]
630
12281
1
Marriage
9
2
Divorce/Separation
24
3
Widowhood
9
4
Visiting
1
5
School/training (start or end)
6
6
Work/employment (start or end)
8
7
Illness/sickness (own)
520
8
Others
32
98
Unknown
0
99
Missing
21
Sysmiss
12281
Lived in another household for two weeks or more since you started coughing?
Lived in another household for two weeks or more since you started coughing?
3971
8940
0
No
3530
1
Yes
370
7
1
8
Unknown
0
9
Missing
70
Sysmiss
8940
gghid of household2
gghid of household2
188
0
in this household2 were you sleeping in the same room with anyone?
in this household2 were you sleeping in the same room with anyone?
188
12723
0
No
64
1
Yes
117
8
Unknown
0
9
Missing
7
Sysmiss
12723
Start date of living in house2 where became ill (if not current house) (D)
Start date of living in house2 where became ill (if not current house) (D)
188
1943-06-15
1
1997-06-15
1
2000-06-15
1
2001-06-15
1
2002-06-15
1
2002-12-15
1
2003-03-15
2
2003-06-20
1
2005-05-15
1
2005-06-15
3
2005-09-15
1
2005-10-15
1
2006-06-15
1
2006-09-10
1
2006-09-15
1
2006-11-15
2
2006-12-15
1
2007-01-15
1
2007-03-15
1
2007-04-15
1
2007-04-21
1
2007-05-09
1
2007-05-15
2
2007-06-20
1
2007-07-15
1
2007-08-04
1
2007-08-15
1
2007-09-15
5
2007-10-29
1
2007-10-30
1
2007-11-11
1
2007-11-15
1
2007-12-15
2
2007-12-20
1
2008-01-04
1
2008-01-28
1
2008-02-15
1
2008-03-15
1
2008-04-10
1
2008-06-15
2
2008-09-15
1
2008-11-01
1
2008-11-24
1
2009-02-15
1
2009-03-03
1
2009-04-15
1
2009-05-15
2
2009-07-15
1
2009-08-25
1
2009-09-15
1
2009-12-15
3
2010-01-15
3
2010-02-03
1
2010-03-15
1
2010-05-17
1
2010-06-09
1
2010-06-15
2
2010-08-05
1
2010-10-15
1
2010-11-15
1
2011-01-15
1
2011-02-15
1
2011-03-15
2
2011-06-15
4
2011-07-15
2
2011-08-10
1
2011-08-15
2
2011-08-20
1
2011-09-05
1
2011-11-15
2
2011-11-17
1
2011-12-15
1
2011-12-20
1
2012-02-15
2
2012-03-15
1
2012-06-07
1
2012-07-11
1
2012-08-06
1
2012-09-15
1
2012-10-15
2
2012-11-15
1
2012-12-03
1
2012-12-15
1
2013-01-15
1
2013-01-26
1
2013-02-15
2
2013-03-02
1
2013-03-15
1
2013-04-15
1
2013-05-03
1
2013-05-15
1
2013-08-15
1
2013-09-15
2
2013-10-12
1
2013-10-15
1
2014-03-02
1
2014-03-15
3
2014-04-15
2
2014-05-16
1
2014-05-17
1
2014-06-15
6
2014-06-28
1
2014-09-15
3
2014-10-15
1
2014-11-10
1
2014-11-15
1
2015-01-15
3
2015-02-15
1
2015-03-15
1
2015-03-31
1
2015-04-15
2
2015-05-15
4
2015-06-04
1
2015-06-09
1
2015-06-15
1
2015-07-15
1
2015-10-15
1
2015-11-15
1
2015-12-11
1
2015-12-24
1
2016-03-15
1
2016-04-15
1
2016-06-14
2
2016-06-15
2
2016-07-13
1
2016-07-15
1
2016-09-10
1
2016-11-15
1
2016-12-30
1
2017-01-07
1
2017-02-15
2
2017-02-17
1
2017-04-15
2
2017-06-04
1
2017-07-15
2
2017-08-15
1
2017-12-15
2
2018-05-05
1
Whether illhsefrdate2 is an estimate (D)
Whether illhsefrdate2 is an estimate (D)
134
12777
1
Full date known
0
2
Day unknown
118
3
Month unknown
0
4
Day and month unknown
16
8
Not known at all
0
9
Missing
0
Sysmiss
12777
When stopped living at household2 since started coughing
When stopped living at household2 since started coughing
187
if illtodate2 is an estimate
if illtodate2 is an estimate
97
12814
1
Full date known
0
2
Day unknown
85
3
Month unknown
0
4
Day and month unknown
12
8
Not known at all
0
9
Missing
0
Sysmiss
12814
village2 since started coughing
village2 since started coughing
179
0
gghid of household3
gghid of household3
6
0
in this household3 were you sleeping in the same room with anyone?
in this household3 were you sleeping in the same room with anyone?
8
12903
0
No
1
1
Yes
6
8
Unknown
0
9
Missing
1
Sysmiss
12903
When started living at household3 since started coughing
When started living at household3 since started coughing
5
if illfromdate3 is an estimate
if illfromdate3 is an estimate
3
12908
1
Full date known
0
2
Day unknown
3
3
Month unknown
0
4
Day and month unknown
0
8
Not known at all
0
9
Missing
0
Sysmiss
12908
When stopped living at household3 since started coughing
When stopped living at household3 since started coughing
4
if illtodate3 is an estimate
if illtodate3 is an estimate
3
12908
1
Full date known
0
2
Day unknown
3
3
Month unknown
0
4
Day and month unknown
0
8
Not known at all
0
9
Missing
0
Sysmiss
12908
village3 since started coughing
village3 since started coughing
4
0
Been to an ART clinic as a guardian to someone or as a patient?
Been to an ART clinic as a guardian to someone or as a patient?
952
11959
0
No
464
1
Yes
483
8
Unknown
0
9
Missing
5
Sysmiss
11959
If yes Clinic1 [ART]
If yes Clinic1 [ART]
482
0
First year1 [attending ART clinic1]
First year1 [attending ART clinic1]
483
12428
9998
Unknown
9999
Missing
Last year1 [attending ART clinic1]
Last year1 [attending ART clinic1]
483
12428
9998
Unknown
9999
Missing
If yes Clinic2 [ART]
If yes Clinic2 [ART]
81
0
First year2 [attending ART clinic2]
First year2 [attending ART clinic2]
85
12826
9998
Unknown
9999
Missing
Last year2 [attending ART clinic2]
Last year2 [attending ART clinic2]
81
12830
9998
Unknown
9999
Missing
Has anyone in your household or close family EVER been treated for TB?
Has anyone in your household or close family EVER been treated for TB?
9871
3040
0
No
7030
1
Yes
2584
8
Unknown
0
9
Missing
257
Sysmiss
3040
Do you know anyone else who has been treated for TB, WITHIN THE LAST 5 YEARS?
Do you know anyone else who has been treated for TB, WITHIN THE LAST 5 YEARS?
9871
3040
0
No
8230
1
Yes
1281
8
Unknown
0
9
Missing
360
Sysmiss
3040
ident of contact [wide] (D)
ident of contact [wide]
1673
0
rename idcase ident
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
ident of contact [wide] (D)
ident of contact [wide]
295
0
rename idcase ident
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
ident of contact [wide] (D)
ident of contact [wide]
49
0
rename idcase ident
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
ident of contact [wide] (D)
ident of contact [wide]
5
0
rename idcase ident
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
ident of contact [wide] (D)
ident of contact [wide]
2
0
rename idcase ident
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Family contact? [wide] (D)
Did you had Family contact? [wide]
1673
11238
0
No
1
Yes
8
Unknown
9
Missing
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Family contact? [wide] (D)
Did you had Family contact? [wide]
295
12616
0
No
1
Yes
8
Unknown
9
Missing
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Family contact? [wide] (D)
Did you had Family contact? [wide]
49
12862
0
No
1
Yes
8
Unknown
9
Missing
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Family contact? [wide] (D)
Did you had Family contact? [wide]
5
12906
0
No
1
Yes
8
Unknown
9
Missing
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Family contact? [wide] (D)
Did you had Family contact? [wide]
2
12909
0
No
1
Yes
8
Unknown
9
Missing
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
1673
0
replace contvil=curvil if contvil=="" & curvil~=""
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
295
0
replace contvil=curvil if contvil=="" & curvil~=""
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
49
0
replace contvil=curvil if contvil=="" & curvil~=""
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
5
0
replace contvil=curvil if contvil=="" & curvil~=""
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
2
0
replace contvil=curvil if contvil=="" & curvil~=""
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
710
0
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
149
0
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
28
0
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
3
0
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
1
0
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
1541
replace trtyear=1905 if trtest==2
replace trtyear=1915 if trtest==3
replace trtyear=1925 if trtest==4
replace trtyear=1935 if trtest==5
replace trtyear=1945 if trtest==6
replace trtyear=1955 if trtest==7
replace trtyear=1965 if trtest==8
replace trtyear=1975 if trtest==9
replace trtyear=1985 if trtest==10
replace trtyear=1995 if trtest==11
recode trtyear 9999=.
gen trtdate=mdy(trtmm,15,trtyear) if trtmm~=. & trtyear~=.
replace trtdate=mdy(6,15,trtyear) if trtmm==. & trtyear~=.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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Whether trtdate is an estimate [wide] (D)
Whether treatment date is an estimate [wide]
1541
gen trtdatex=2 if trtyear~=.
replace trtdatex=4 if trtmm==. & trtyear~=.
replace trtdatex=5 if trtest~=. & trtyear~=.
la val trtdatex* datex
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
278
replace trtyear=1905 if trtest==2
replace trtyear=1915 if trtest==3
replace trtyear=1925 if trtest==4
replace trtyear=1935 if trtest==5
replace trtyear=1945 if trtest==6
replace trtyear=1955 if trtest==7
replace trtyear=1965 if trtest==8
replace trtyear=1975 if trtest==9
replace trtyear=1985 if trtest==10
replace trtyear=1995 if trtest==11
recode trtyear 9999=.
gen trtdate=mdy(trtmm,15,trtyear) if trtmm~=. & trtyear~=.
replace trtdate=mdy(6,15,trtyear) if trtmm==. & trtyear~=.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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Whether trtdate is an estimate [wide] (D)
Whether treatment date is an estimate [wide]
278
gen trtdatex=2 if trtyear~=.
replace trtdatex=4 if trtmm==. & trtyear~=.
replace trtdatex=5 if trtest~=. & trtyear~=.
la val trtdatex* datex
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
49
replace trtyear=1905 if trtest==2
replace trtyear=1915 if trtest==3
replace trtyear=1925 if trtest==4
replace trtyear=1935 if trtest==5
replace trtyear=1945 if trtest==6
replace trtyear=1955 if trtest==7
replace trtyear=1965 if trtest==8
replace trtyear=1975 if trtest==9
replace trtyear=1985 if trtest==10
replace trtyear=1995 if trtest==11
recode trtyear 9999=.
gen trtdate=mdy(trtmm,15,trtyear) if trtmm~=. & trtyear~=.
replace trtdate=mdy(6,15,trtyear) if trtmm==. & trtyear~=.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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Whether trtdate is an estimate [wide] (D)
Whether treatment date is an estimate [wide]
49
gen trtdatex=2 if trtyear~=.
replace trtdatex=4 if trtmm==. & trtyear~=.
replace trtdatex=5 if trtest~=. & trtyear~=.
la val trtdatex* datex
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
5
replace trtyear=1905 if trtest==2
replace trtyear=1915 if trtest==3
replace trtyear=1925 if trtest==4
replace trtyear=1935 if trtest==5
replace trtyear=1945 if trtest==6
replace trtyear=1955 if trtest==7
replace trtyear=1965 if trtest==8
replace trtyear=1975 if trtest==9
replace trtyear=1985 if trtest==10
replace trtyear=1995 if trtest==11
recode trtyear 9999=.
gen trtdate=mdy(trtmm,15,trtyear) if trtmm~=. & trtyear~=.
replace trtdate=mdy(6,15,trtyear) if trtmm==. & trtyear~=.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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Whether trtdate is an estimate [wide] (D)
Whether treatment date is an estimate [wide]
5
gen trtdatex=2 if trtyear~=.
replace trtdatex=4 if trtmm==. & trtyear~=.
replace trtdatex=5 if trtest~=. & trtyear~=.
la val trtdatex* datex
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
2
replace trtyear=1905 if trtest==2
replace trtyear=1915 if trtest==3
replace trtyear=1925 if trtest==4
replace trtyear=1935 if trtest==5
replace trtyear=1945 if trtest==6
replace trtyear=1955 if trtest==7
replace trtyear=1965 if trtest==8
replace trtyear=1975 if trtest==9
replace trtyear=1985 if trtest==10
replace trtyear=1995 if trtest==11
recode trtyear 9999=.
gen trtdate=mdy(trtmm,15,trtyear) if trtmm~=. & trtyear~=.
replace trtdate=mdy(6,15,trtyear) if trtmm==. & trtyear~=.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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Whether trtdate is an estimate [wide] (D)
Whether treatment date is an estimate [wide]
2
gen trtdatex=2 if trtyear~=.
replace trtdatex=4 if trtmm==. & trtyear~=.
replace trtdatex=5 if trtest~=. & trtyear~=.
la val trtdatex* datex
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Place of treatment [wide] (D)
Place of treatment [wide]
1641
0
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Place of treatment [wide] (D)
Place of treatment [wide]
287
0
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Place of treatment [wide] (D)
Place of treatment [wide]
49
0
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Place of treatment [wide] (D)
Place of treatment [wide]
5
0
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Place of treatment [wide] (D)
2
0
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Are you sure it was TB? [wide] (D)
Are you sure it was TB? [wide]
81
12830
0
Unsure/unlikely
0
1
Certain
43
2
Probable
1
8
Unknown
0
9
Missing
37
Sysmiss
12830
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Are you sure it was TB? [wide] (D)
Are you sure it was TB? [wide]
18
12893
0
Unsure/unlikely
0
1
Certain
12
2
Probable
0
8
Unknown
0
9
Missing
6
Sysmiss
12893
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Are you sure it was TB? [wide] (D)
Are you sure it was TB? [wide]
2
12909
0
Unsure/unlikely
0
1
Certain
1
2
Probable
0
8
Unknown
0
9
Missing
1
Sysmiss
12909
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Are you sure it was TB? [wide] (D)
Are you sure it was TB? [wide]
0
12911
0
Unsure/unlikely
0
1
Certain
0
2
Probable
0
8
Unknown
0
9
Missing
0
Sysmiss
12911
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Are you sure it was TB? [wide] (D)
Are you sure it was TB? [wide]
0
12911
0
Unsure/unlikely
0
1
Certain
0
2
Probable
0
8
Unknown
0
9
Missing
0
Sysmiss
12911
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you visit them on the TB ward? Did you act as guardian? [wide] (D)
Did you visit them on the TB ward? Did you act as guardian?
963
11948
1
Guardian
204
2
Neither
352
3
Visit
380
8
Unknown
0
9
Missing
27
Sysmiss
11948
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you visit them on the TB ward? Did you act as guardian? [wide] (D)
Did you visit them on the TB ward? Did you act as guardian?
146
12765
1
Guardian
30
2
Neither
47
3
Visit
61
8
Unknown
0
9
Missing
8
Sysmiss
12765
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you visit them on the TB ward? Did you act as guardian? [wide] (D)
Did you visit them on the TB ward? Did you act as guardian?
21
12890
1
Guardian
0
2
Neither
8
3
Visit
13
8
Unknown
0
9
Missing
0
Sysmiss
12890
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you visit them on the TB ward? Did you act as guardian? [wide] (D)
Did you visit them on the TB ward? Did you act as guardian?
2
12909
1
Guardian
0
2
Neither
2
3
Visit
0
8
Unknown
0
9
Missing
0
Sysmiss
12909
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you visit them on the TB ward? Did you act as guardian? [wide] (D)
Did you visit them on the TB ward? Did you act as guardian?
1
12910
1
Guardian
0
2
Neither
0
3
Visit
1
8
Unknown
0
9
Missing
0
Sysmiss
12910
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
What relationship is this person to you?
1673
11238
0
No informant
0
1
Relative
141
2
Neighbour
91
3
Visitor to h/hold
2
4
Friend
20
5
Colleague at work
17
6
Someone visited
2
7
Other
13
8
Self
0
9
Parent/step-parent
346
10
Spouse
168
11
Sibling
458
12
Child
98
13
Uncle/aunt
99
14
G/mother/father/step
47
15
Mother/father-inlaw
6
16
Sister/brother-inlaw
30
17
Cousin
35
18
Nephew/niece
16
19
Wifemate
2
20
Grandson/daughter
2
21
Uncle/aunt in-law
1
22
Son/daughter in-law
2
23
Distant cousin/relation
1
98
Unknown
0
99
Missing
76
Sysmiss
11238
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
What relationship is this person to you?
295
12616
0
No informant
0
1
Relative
32
2
Neighbour
12
3
Visitor to h/hold
1
4
Friend
5
5
Colleague at work
4
6
Someone visited
0
7
Other
4
8
Self
0
9
Parent/step-parent
62
10
Spouse
18
11
Sibling
82
12
Child
20
13
Uncle/aunt
23
14
G/mother/father/step
6
15
Mother/father-inlaw
0
16
Sister/brother-inlaw
7
17
Cousin
6
18
Nephew/niece
4
19
Wifemate
1
20
Grandson/daughter
0
21
Uncle/aunt in-law
0
22
Son/daughter in-law
2
23
Distant cousin/relation
0
98
Unknown
0
99
Missing
6
Sysmiss
12616
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
What relationship is this person to you?
49
12862
0
No informant
0
1
Relative
2
2
Neighbour
3
3
Visitor to h/hold
0
4
Friend
1
5
Colleague at work
0
6
Someone visited
0
7
Other
0
8
Self
0
9
Parent/step-parent
12
10
Spouse
2
11
Sibling
18
12
Child
2
13
Uncle/aunt
3
14
G/mother/father/step
3
15
Mother/father-inlaw
0
16
Sister/brother-inlaw
0
17
Cousin
1
18
Nephew/niece
1
19
Wifemate
0
20
Grandson/daughter
0
21
Uncle/aunt in-law
0
22
Son/daughter in-law
0
23
Distant cousin/relation
0
98
Unknown
0
99
Missing
1
Sysmiss
12862
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
What relationship is this person to you?
5
12906
0
No informant
0
1
Relative
0
2
Neighbour
0
3
Visitor to h/hold
0
4
Friend
0
5
Colleague at work
0
6
Someone visited
0
7
Other
0
8
Self
0
9
Parent/step-parent
0
10
Spouse
0
11
Sibling
3
12
Child
1
13
Uncle/aunt
1
14
G/mother/father/step
0
15
Mother/father-inlaw
0
16
Sister/brother-inlaw
0
17
Cousin
0
18
Nephew/niece
0
19
Wifemate
0
20
Grandson/daughter
0
21
Uncle/aunt in-law
0
22
Son/daughter in-law
0
23
Distant cousin/relation
0
98
Unknown
0
99
Missing
0
Sysmiss
12906
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
What relationship is this person to you?
2
12909
0
No informant
0
1
Relative
0
2
Neighbour
0
3
Visitor to h/hold
0
4
Friend
0
5
Colleague at work
0
6
Someone visited
0
7
Other
0
8
Self
0
9
Parent/step-parent
0
10
Spouse
0
11
Sibling
1
12
Child
0
13
Uncle/aunt
0
14
G/mother/father/step
1
15
Mother/father-inlaw
0
16
Sister/brother-inlaw
0
17
Cousin
0
18
Nephew/niece
0
19
Wifemate
0
20
Grandson/daughter
0
21
Uncle/aunt in-law
0
22
Son/daughter in-law
0
23
Distant cousin/relation
0
98
Unknown
0
99
Missing
0
Sysmiss
12909
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you have contact with them while they were ill? [wide] (D)
Did you have contact with them while they were ill?
963
11948
0
No
191
1
Yes
753
8
Unknown
0
9
Missing
19
Sysmiss
11948
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you have contact with them while they were ill? [wide] (D)
Did you have contact with them while they were ill?
146
12765
0
No
33
1
Yes
112
8
Unknown
0
9
Missing
1
Sysmiss
12765
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you have contact with them while they were ill? [wide] (D)
Did you have contact with them while they were ill?
21
12890
0
No
5
1
Yes
16
8
Unknown
0
9
Missing
0
Sysmiss
12890
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you have contact with them while they were ill? [wide] (D)
Did you have contact with them while they were ill?
2
12909
0
No
1
1
Yes
1
8
Unknown
0
9
Missing
0
Sysmiss
12909
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you have contact with them while they were ill? [wide] (D)
Did you have contact with them while they were ill?
1
12910
0
No
0
1
Yes
1
8
Unknown
0
9
Missing
0
Sysmiss
12910
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
When you saw them, when they had TB Did this person have a cough?
1463
11448
0
No
87
1
Yes
1332
8
Unknown
41
9
Missing
3
Sysmiss
11448
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
When you saw them, when they had TB Did this person have a cough?
261
12650
0
No
14
1
Yes
236
8
Unknown
11
9
Missing
0
Sysmiss
12650
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
When you saw them, when they had TB Did this person have a cough?
44
12867
0
No
6
1
Yes
36
8
Unknown
2
9
Missing
0
Sysmiss
12867
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
When you saw them, when they had TB Did this person have a cough?
4
12907
0
No
1
1
Yes
2
8
Unknown
1
9
Missing
0
Sysmiss
12907
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
When you saw them, when they had TB Did this person have a cough?
2
12909
0
No
0
1
Yes
2
8
Unknown
0
9
Missing
0
Sysmiss
12909
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you nurse this person while they were ill? [wide] (D)
Did you nurse this person while they were ill?
1463
11448
0
No
1015
1
Yes
445
8
Unknown
0
9
Missing
3
Sysmiss
11448
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you nurse this person while they were ill? [wide] (D)
Did you nurse this person while they were ill?
261
12650
0
No
189
1
Yes
72
8
Unknown
0
9
Missing
0
Sysmiss
12650
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you nurse this person while they were ill? [wide] (D)
Did you nurse this person while they were ill?
44
12867
0
No
37
1
Yes
7
8
Unknown
0
9
Missing
0
Sysmiss
12867
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you nurse this person while they were ill? [wide] (D)
Did you nurse this person while they were ill?
4
12907
0
No
4
1
Yes
0
8
Unknown
0
9
Missing
0
Sysmiss
12907
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you nurse this person while they were ill? [wide] (D)
Did you nurse this person while they were ill?
2
12909
0
No
2
1
Yes
0
8
Unknown
0
9
Missing
0
Sysmiss
12909
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you live in the same household as them while they were ill? [wide] (D)
Did you live in the same household as them while they were ill?
1463
11448
0
No
723
1
Yes
735
8
Unknown
0
9
Missing
5
Sysmiss
11448
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you live in the same household as them while they were ill? [wide] (D)
Did you live in the same household as them while they were ill?
261
12650
0
No
144
1
Yes
117
8
Unknown
0
9
Missing
0
Sysmiss
12650
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you live in the same household as them while they were ill? [wide] (D)
Did you live in the same household as them while they were ill?
44
12867
0
No
24
1
Yes
20
8
Unknown
0
9
Missing
0
Sysmiss
12867
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you live in the same household as them while they were ill? [wide] (D)
Did you live in the same household as them while they were ill?
4
12907
0
No
2
1
Yes
2
8
Unknown
0
9
Missing
0
Sysmiss
12907
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you live in the same household as them while they were ill? [wide] (D)
Did you live in the same household as them while they were ill?
2
12909
0
No
0
1
Yes
2
8
Unknown
0
9
Missing
0
Sysmiss
12909
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you sleep in same room as this person while they were ill? [wide] (D)
Did you sleep in same room as this person while they were ill?
737
12174
0
No
344
1
Yes
379
8
Unknown
0
9
Missing
14
Sysmiss
12174
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you sleep in same room as this person while they were ill? [wide] (D)
Did you sleep in same room as this person while they were ill?
117
12794
0
No
73
1
Yes
43
8
Unknown
0
9
Missing
1
Sysmiss
12794
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you sleep in same room as this person while they were ill? [wide] (D)
Did you sleep in same room as this person while they were ill?
20
12891
0
No
14
1
Yes
6
8
Unknown
0
9
Missing
0
Sysmiss
12891
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you sleep in same room as this person while they were ill? [wide] (D)
Did you sleep in same room as this person while they were ill?
2
12909
0
No
2
1
Yes
0
8
Unknown
0
9
Missing
0
Sysmiss
12909
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Did you sleep in same room as this person while they were ill? [wide] (D)
Did you sleep in same room as this person while they were ill?
2
12909
0
No
2
1
Yes
0
8
Unknown
0
9
Missing
0
Sysmiss
12909
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Was your contact with this person indoors? [wide] (D)
Was your contact with this person indoors?
1428
11483
0
Never indoors
419
1
Sometimes indoors
901
8
Unknown
0
9
Missing
108
Sysmiss
11483
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Was your contact with this person indoors? [wide] (D)
Was your contact with this person indoors?
254
12657
0
Never indoors
92
1
Sometimes indoors
148
8
Unknown
0
9
Missing
14
Sysmiss
12657
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Was your contact with this person indoors? [wide] (D)
Was your contact with this person indoors?
44
12867
0
Never indoors
14
1
Sometimes indoors
29
8
Unknown
0
9
Missing
1
Sysmiss
12867
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Was your contact with this person indoors? [wide] (D)
Was your contact with this person indoors?
4
12907
0
Never indoors
1
1
Sometimes indoors
2
8
Unknown
0
9
Missing
1
Sysmiss
12907
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Was your contact with this person indoors? [wide] (D)
Was your contact with this person indoors?
2
12909
0
Never indoors
0
1
Sometimes indoors
2
8
Unknown
0
9
Missing
0
Sysmiss
12909
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Was your contact with this person prolonged? [wide] (D)
Was your contact with this person indoors?
1428
11483
0
Never prolonged
520
1
Prolonged (hours)
784
8
Unknown
0
9
Missing
124
Sysmiss
11483
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Was your contact with this person prolonged? [wide] (D)
Was your contact with this person indoors?
254
12657
0
Never prolonged
99
1
Prolonged (hours)
137
8
Unknown
0
9
Missing
18
Sysmiss
12657
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Was your contact with this person prolonged? [wide] (D)
Was your contact with this person indoors?
44
12867
0
Never prolonged
16
1
Prolonged (hours)
27
8
Unknown
0
9
Missing
1
Sysmiss
12867
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Was your contact with this person prolonged? [wide] (D)
Was your contact with this person indoors?
4
12907
0
Never prolonged
1
1
Prolonged (hours)
2
8
Unknown
0
9
Missing
1
Sysmiss
12907
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Was your contact with this person prolonged? [wide] (D)
Was your contact with this person indoors?
2
12909
0
Never prolonged
0
1
Prolonged (hours)
2
8
Unknown
0
9
Missing
0
Sysmiss
12909
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
On how many days did you see this person while they were ill? [wide] (D)
On how many days did you see this person while they were ill?
1463
11448
1
0 days
66
2
1 day
106
3
2-5 days
303
4
6-10 days
104
5
11-20 days
122
6
>20 days
645
8
Unknown
0
9
Missing
117
Sysmiss
11448
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
On how many days did you see this person while they were ill? [wide] (D)
On how many days did you see this person while they were ill?
261
12650
1
0 days
21
2
1 day
26
3
2-5 days
53
4
6-10 days
9
5
11-20 days
25
6
>20 days
109
8
Unknown
0
9
Missing
18
Sysmiss
12650
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
On how many days did you see this person while they were ill? [wide] (D)
On how many days did you see this person while they were ill?
44
12867
1
0 days
6
2
1 day
2
3
2-5 days
11
4
6-10 days
3
5
11-20 days
3
6
>20 days
18
8
Unknown
0
9
Missing
1
Sysmiss
12867
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
On how many days did you see this person while they were ill? [wide] (D)
On how many days did you see this person while they were ill?
4
12907
1
0 days
0
2
1 day
1
3
2-5 days
0
4
6-10 days
0
5
11-20 days
1
6
>20 days
1
8
Unknown
0
9
Missing
1
Sysmiss
12907
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
On how many days did you see this person while they were ill? [wide] (D)
On how many days did you see this person while they were ill?
2
12909
1
0 days
0
2
1 day
0
3
2-5 days
1
4
6-10 days
0
5
11-20 days
0
6
>20 days
1
8
Unknown
0
9
Missing
0
Sysmiss
12909
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
merge m:1 ident intdate using ${tempfiles}\tbcontacts_wide, keep(master match) nogen]]>
Have you ever drunk alcohol
Have you ever drunk alcohol?
2192
10719
0
No
1361
1
Yes
826
8
Unknown
0
9
Missing
5
Sysmiss
10719
If yes: For how many years have/did you drunk alcohol?
If (drinkalcoh)yes : For how many years have/did you drunk alcohol?
826
12085
98
Unknown
99
Missing
Do you still drink?
Do you still drink?
826
12085
0
No
386
1
Yes
436
8
Unknown
0
9
Missing
4
Sysmiss
12085
Year stopped drinking alcohol (D)
Year stopped drinking alcohol
377
12534
Whether year of stopping drinking is estimated (D)
Whether year of stopping drinking is estimated
377
12534
0
No
376
1
Yes
1
8
Unknown
0
9
Missing
0
Sysmiss
12534
How frequently do/did you drink alcohol?
How frequently do/did you drink alcohol?
826
12085
1
Every day
131
2
More than once a week
245
3
Once a week
120
4
Less than once a week
313
8
Unknown
0
9
Missing
17
Sysmiss
12085
Have you ever smoked tobacco? (this does not include snuff or chewing tobacco)
Have you ever smoked tobacco? (this does not include snuff or chewing tobacco)
8493
4418
0
No
6603
1
Yes
1824
8
Unknown
0
9
Missing
66
Sysmiss
4418
If yes, what did (or do) you smoke?
If (smoketobac) yes, what did (or do) you smoke?
1824
11087
1
Cigarettes
1423
2
Home-rolled
347
3
Pipe
12
8
Unknown
0
9
Missing
42
Sysmiss
11087
How many did/do you smoke each day?
How many did/do you smoke each day?
1774
11137
1
<5 day
605
2
5-10 day
608
3
11-20 day
400
4
>20 day
141
8
unknown
0
9
Missing
20
Sysmiss
11137
For how many years have/did you smoke(d)?
For how many years have/did you smoke(d)?
1824
11087
98
Unknown
99
Missing
Do you still smoke?
Do you still smoke?
1824
11087
0
No
1300
1
Yes
505
8
Unknown
0
9
Missing
19
Sysmiss
11087
Year stopped smoking (D)
If (smokestill) is No, Year stopped smoking
1280
11631
Whether year of stopping smoking is estimated (D)
Is the year of stopping smoking is estimated
1280
11631
0
No
1275
1
Yes
5
8
Unknown
0
9
Missing
0
Sysmiss
11631
Before you became ill, how often did you do the cooking?
Before you became ill, how often did you do the cooking?
1760
11151
1
Every day
742
2
At least once a week but not every day
175
3
Sometimes but < once per week
311
4
Never
522
8
Unknown
0
9
Missing
10
Sysmiss
11151
Before becoming ill, was child carried by mother while they were cooking?
Before becoming ill, was child carried by mother while they were cooking?
1
12910
1
Every day
0
2
At least once a week but not every day
0
3
Sometimes but < once per week
1
4
Never
0
8
Unknown
0
9
Missing
0
Sysmiss
12910
Before becaming ill, did cooking smoke make you cough or irritate your eyes?
Before becaming ill, did cooking smoke make you cough or irritate your eyes?
963
11948
0
No
318
1
Irritated eyes
402
2
Made them cough
150
3
Other
7
8
Unknown
0
9
Missing
86
Sysmiss
11948
How often does/did the smoke irritate you?
How often does/did the smoke irritate you?
643
12268
1
Every day
47
2
At least once a week but not every day
104
3
Sometimes but < once per week
443
4
Never
26
8
Unknown
0
9
Missing
23
Sysmiss
12268
What sort of cooking fire did you usually use in the dry season?
What sort of cooking fire did you usually use in the dry season?
989
11922
1
Open fire (e.g. 3-stonetype)
917
2
Kinda fire
33
3
Paraffin stove
4
4
Gas stove
2
5
Electric stove
13
6
Others
7
8
Unknown
0
9
Missing
13
Sysmiss
11922
Where is the fire usually in the dry season?
Where is the fire usually in the dry season?
989
11922
1
Outside
437
2
In a separate hut
490
3
In a hut where you eat, live or sleep
48
8
Unknown
0
9
Missing
14
Sysmiss
11922
What sort of cooking fire did you usually use in the wet season?
What sort of cooking fire did you usually use in the wet season?
989
11922
1
Open fire (e.g. 3-stonetype)
891
2
Kinda fire
36
3
Paraffin stove
5
4
Gas stove
2
5
Electric stove
13
6
Others
7
8
Unknown
0
9
Missing
35
Sysmiss
11922
Where is the fire usually in the wet season?
Where is the fire usually in the wet season?
989
11922
1
Outside
166
2
In a separate hut
643
3
In a hut where you eat, live or sleep
152
8
Unknown
0
9
Missing
28
Sysmiss
11922
Do you burn anything to keep insects away?
Do you burn anything to keep insects away?
1761
11150
0
No
1276
1
Yes
481
8
Unknown
0
9
Missing
4
Sysmiss
11150
What do you burn? [to keep insects away]
What do you burn? [to keep insects away]
481
12430
1
Coil
421
2
Plants
36
3
Dung
2
4
Other
15
8
Unknown
0
9
Missing
7
Sysmiss
12430
Where do you burn it? [to keep insects away]
Where do you burn it? [to keep insects away]
481
12430
1
Outside
1
2
In a separate hut
462
3
In a hut where you eat, live or sleep
3
8
Unknown
0
9
Missing
15
Sysmiss
12430
Do you smoke fish?
Do you smoke fish?
1761
11150
0
Never
1301
1
Sometimes
334
2
Frequently
13
3
Commercial business
84
8
unknown
0
9
Missing
29
Sysmiss
11150
Have you ever been pregnant?
Have you ever been pregnant?
1996
10915
0
No
174
1
Yes
1667
8
Unknown
0
9
Missing
155
Sysmiss
10915
Currently pregnant (D)
Currently pregnant
1682
11229
0
No
1510
1
Yes
132
8
Unknown
3
9
Missing
37
Sysmiss
11229
Months pregnant (D)
Months pregnant
112
12799
98
Unknown
99
Missing
Do you think your current illness started before of after the pregnancy?
Do you think your current illness started before of after the pregnancy?
11
12900
1
Before
1
2
After
5
3
About the same time
4
8
Unknown
1
9
Missing
0
Sysmiss
12900
Have you ever given birth (incl children who have died and stillbirths)?
Have you ever given birth (incl children who have died and stillbirths)?
1667
11244
0
No
29
1
Yes
1634
8
Unknown
0
9
Missing
4
Sysmiss
11244
Total number of births
Total number of births
1634
11277
98
Unknown
99
Missing
Date of most recent birth (D)
Date of most recent birth
1622
if recbirdate is an estimate (D)
If recbirdate is an estimate
1622
11289
1
Full date known
0
2
Day unknown
1058
3
Month unknown
0
4
Day and month unknown
544
5
20
8
Not known at all
0
9
Missing
0
Sysmiss
11289
Outcome of most recent birth
Outcome of most recent birth
871
12040
1
Alive
705
2
Livebirth but died
129
3
Stillbirth
19
8
Unknown
0
9
Missing
18
Sysmiss
12040
Since last birth have you had miscarriage or abortion?
Since last birth have you had miscarriage or abortion?
1634
11277
0
No
1511
1
Yes
103
8
Unknown
0
9
Missing
20
Sysmiss
11277
Most recent date (of miscarriage or abortion since last birth) (D)
Most recent date (of miscarriage or abortion since last birth)
98
if dmisabdate is an estimate (D)
If dmisabdate is an estimate
98
12813
1
Full date known
0
2
Day unknown
50
3
Month unknown
0
4
Day and month unknown
47
5
1
8
Not known at all
0
9
Missing
0
Sysmiss
12813
Gestation (of miscarriage or abortion since last birth)
Gestation (of miscarriage or abortion since last birth)
104
12807
98
Unknown
99
Missing
Have you ever had any miscarriage or abortion?
Have you ever had any miscarriage or abortion?
904
12007
0
No
724
1
Yes
121
8
Unknown
0
9
Missing
59
Sysmiss
12007
Most recent date (of miscarriage or abortion ever) (D)
Most recent date (of miscarriage or abortion ever)
113
if emisabdate is an estimate (D)
if emisabdate is an estimate
113
12798
1
Full date known
0
2
Day unknown
33
3
Month unknown
0
4
Day and month unknown
79
5
1
8
Not known at all
0
9
Missing
0
Sysmiss
12798
Gestation (of miscarriage or abortion ever)
121
12790
98
Unknown
99
Missing
Have you been taking any medicines other than for TB in the last year?
Have you been taking any medicines other than for TB in the last year?
3101
9810
0
No
1261
1
Yes
1312
8
Unknown
0
9
Missing
528
Sysmiss
9810
Taking medicines (other that for TB) from the grocery/market (D)
Taking medicines (other that for TB) from the grocery/market
2573
10338
0
No
2325
1
Yes
248
8
Unknown
0
9
Missing
0
Sysmiss
10338
Taking medicines (other that for TB) from the health centre (D)
Taking medicines (other that for TB) from the health centre
2573
10338
0
No
1489
1
Yes
1084
8
Unknown
0
9
Missing
0
Sysmiss
10338
Taking medicines (other that for TB) from the traditional healer (D)
Taking medicines (other that for TB) from the traditional healer
2573
10338
0
No
2180
1
Yes
393
8
Unknown
0
9
Missing
0
Sysmiss
10338
Taking medicines (other that for TB): self treatment with herbs (D)
Taking medicines (other that for TB): self treatment with herbs
2573
10338
0
No
2548
1
Yes
25
8
Unknown
0
9
Missing
0
Sysmiss
10338
Have you ever been diagnosed with diabetes (sugar disease)
Have you ever been diagnosed with diabetes (sugar disease)
3101
9810
0
No
2573
1
Yes
9
8
Unknown
0
9
Missing
519
Sysmiss
9810
Have you ever been diagnosed with any other serious disease?
Have you ever been diagnosed with any other serious disease?
3101
9810
0
No
2146
1
Yes
405
8
Unknown
0
9
Missing
550
Sysmiss
9810
Since you became ill but before admission to hospital was anyone nursing you?
Since you became ill but before admission to hospital was anyone nursing you?
3971
8940
0
No
3190
1
Yes
729
8
Unknown
0
9
Missing
52
Sysmiss
8940
unique identifier of person1 who nursed them linkable to other studies
unique identifier of person1 who nursed them linkable to other studies
729
0
unique identifier of person2 who nursed them linkable to other studies
unique identifier of person2 who nursed them linkable to other studies
168
0
unique identifier of person3 who nursed them linkable to other studies
unique identifier of person3 who nursed them linkable to other studies
27
0
Living as married with anyone while ill but before hospital admission
Living as married with anyone while ill but before hospital admission
3814
9097
0
No
1592
1
Yes
2103
8
Unknown
0
9
Missing
119
Sysmiss
9097
unique identifier of spouse1 them linkable to other studies
unique identifier of spouse1 them linkable to other studies
2102
0
Is spouse1 attending as the guardian?
Is spouse1 attending as the guardian?
1430
11481
0
No
638
1
Yes
762
8
Unknown
0
9
Missing
30
Sysmiss
11481
unique identifier of spouse2 them linkable to other studies
unique identifier of spouse2 them linkable to other studies
119
0
Is spouse2 attending as the guardian?
Is spouse2 attending as the guardian?
101
12810
0
No
39
1
Yes
57
8
Unknown
0
9
Missing
5
Sysmiss
12810
unique identifier of spouse3 them linkable to other studies
unique identifier of spouse3 them linkable to other studies
16
0
Is spouse3 attending as the guardian?
Is spouse3 attending as the guardian?
14
12897
0
No
5
1
Yes
8
8
Unknown
0
9
Missing
1
Sysmiss
12897
In the year before illness, num adults shared a sleeping dwelling with?
In the year before illness, num adults shared a sleeping dwelling with?
1761
11150
8
Unknown
9
Missing
In the year before illness, num children shared a sleeping dwelling with?
In the year before illness, num children shared a sleeping dwelling with?
1761
11150
8
Unknown
9
Missing
When became ill, num adults shared a sleeping dwelling with?
When became ill, num adults shared a sleeping dwelling with?
1761
11150
8
Unknown
9
Missing
When became ill, num children shared a sleeping dwelling with?
When became ill, num children shared a sleeping dwelling with?
1761
11150
8
Unknown
9
Missing
Haemoptysis
Haemoptysis
181
12730
0
No
157
1
Yes
22
8
Unknown
0
9
Missing
2
Sysmiss
12730
Examination for glands
Examination for glands
2761
10150
0
Incomplete
7
1
Complete
2679
2
Not done
20
3
Unable
1
4
Refused
12
8
Unknown
0
9
Missing
42
Sysmiss
10150
Findings: TB suspect pulmonary?
Findings: TB suspect pulmonary?
2761
10150
0
No
0
1
Yes
292
8
Unknown
0
9
Missing
2469
Sysmiss
10150
Findings: TB suspect glandular?
Findings: TB suspect glandular?
2761
10150
0
No
0
1
Yes
8
8
Unknown
0
9
Missing
2753
Sysmiss
10150
Findings: TB suspect both pulmonary and glandular?
Findings: TB suspect both pulmonary and glandular?
2761
10150
0
No
0
1
Yes
10
8
Unknown
0
9
Missing
2751
Sysmiss
10150
Findings: TB suspect other?
Findings: TB suspect other?
2761
10150
0
No
0
1
Yes
15
8
Unknown
0
9
Missing
2746
Sysmiss
10150
To be reviewed by Medical Officer/Clinical Officer?
To be reviewed by Medical Officer/Clinical Officer?
2761
10150
0
No
2339
1
Yes
268
7
34
8
Unknown
0
9
Missing
120
Sysmiss
10150
Referred to hospital for admission?
Referred to hospital for admission?
2761
10150
0
No
2468
1
Yes
8
7
144
8
Unknown
0
9
Missing
141
Sysmiss
10150
Examined for leprosy
Examined for leprosy
811
12100
0
Incomplete
48
1
Complete
724
2
Not done
4
3
Unable
0
4
Refused
11
8
Unknown
0
9
Missing
24
Sysmiss
12100
Leprosy suspect
Leprosy suspect
811
12100
0
No
0
1
Yes
0
8
Unknown
0
9
Missing
811
Sysmiss
12100
Skin disease
Skin disease
811
12100
0
No
0
1
Yes
136
8
Unknown
0
9
Missing
675
Sysmiss
12100
Skin disease 1
Skin disease 1
136
12775
1
Malnutrition
1
2
Scabies
2
3
Ext t versicolor
49
4
Mild t versicolor
15
5
Extensive impetigo
1
6
Von Recklinghausen's
0
7
Signs of past polio
2
8
Mutism
0
9
T corporis/circinat
7
10
Sev rheumatoid arth
0
12
Morphoea (probably)
0
13
Ichthyosis
0
15
Psoriasis
0
19
Lupus vulgaris
0
20
Secondary syphilis
0
21
Chicken pox
0
22
Herpes zoster (shingles)
3
23
Herpes simplex (extr
0
24
Herpes simplex (geni
0
25
Verruca vulgaris
0
26
Plane warts
2
27
Genital warts
0
28
Molluscum contagiosu
0
30
Acne vulgaris
1
31
Acne conglobata
0
32
Folliculitis/papulop
1
33
Keratosis follicular
0
34
Allergic cont derma
1
35
Irritant cont derma
1
36
Seborrhoeic dermatit
4
37
Atopic eczema
0
38
Nummular discoid ecz
0
39
Lichen simplex chron
1
40
Pityriasis alba
0
41
Unspec chronic derm
1
42
Pellagra
0
43
Photoallergic dermat
0
44
Phototoxic dermatiti
0
45
Dyshydrosis (pomphol
0
46
Eczematide
0
47
Acute urticaria, whe
0
48
Chronic urticaria
0
49
Papular urticaria
3
50
Pruritus without ski
0
51
Prurigo
0
52
Candidosis (paronych
2
53
Tinea pedis
3
54
Tinea inguinalis
2
55
Tinea capitis
0
56
Chronic discoid lupu
0
57
Pityriasis rosea
0
58
Cutaneous larva migr
0
59
Benign skin tumour
20
60
Kaposi's sarcoma
1
62
Malignant melanoma
0
63
Basal cell carcinoma
0
64
Squamous cell carcin
0
65
Lichen planus
1
66
Drug reaction/sj syn
0
67
Fixed drug eruption
1
68
Vitiligo
1
69
Gonorrhoea
0
70
Chancroid
0
71
Lymphogranuloma vene
0
72
Dermatitis herpetifo
0
73
Pemphigus
0
74
Pemphigoid
0
75
Porphyria cutanea ta
0
76
Stomatitis
0
77
Erythroderma
0
78
Scleroderma+morphea
0
79
Scrophuloderma
0
80
Erythema nodosum
0
81
Erythema induratum
0
82
Papulonecrotic tuber
0
83
Haemangioma
0
84
Granuloma annulare
0
85
Deep fungal infectio
0
86
Tropical ulcer
0
87
Buruli ulcer (m.ulce
0
88
Cellulitis
0
89
Erythema multiforme
0
90
Measles
0
91
Primary syphilis
0
92
Gen lymphadenopathy
0
93
Glandular tb/loc lym
0
94
Undiag urethral dis
0
95
Cysticercosis
0
96
Acne keloidalis nuch
0
97
Saocoidosis
0
98
Tinea unguum (fungal
0
99
Lichen nitidus
0
100
Lichen sclerosus et
0
101
Infective dermatitis
0
102
Pit rubra pilaris
0
103
Keratoderma
0
104
Pseudofolliculitis b
0
105
Lichen striatus
0
106
Pityriasis lichenoid
0
107
Bell's palsy
0
108
Metastatic carcinoma
0
109
Non specific ulcer
0
110
Leukaemia
0
111
Hodgkin's lymphoma
0
112
Non hodgkin's lympho
0
113
Alopecia areata
0
114
Cutaneous t cell lym
0
115
Pyogenic granuloma
0
116
B-cell lymphoma
0
117
Erythrasima
0
118
Millaria rubra/cysts
5
119
Lice(pedic.pubis/cap
0
120
Unspecified carcinom
0
121
Haemorrhoids
0
122
Elephantiasis
3
123
Hydrocoele
1
124
Hydradenitis suppuri
0
998
Unknown
1
999
Missing
0
Sysmiss
12775
Skin disease 2
Skin disease 2
9
12902
1
Malnutrition
0
2
Scabies
1
3
Ext t versicolor
2
4
Mild t versicolor
0
5
Extensive impetigo
0
6
Von Recklinghausen's
0
7
Signs of past polio
0
8
Mutism
0
9
T corporis/circinat
1
10
Sev rheumatoid arth
0
12
Morphoea (probably)
0
13
Ichthyosis
0
15
Psoriasis
1
19
Lupus vulgaris
0
20
Secondary syphilis
0
21
Chicken pox
0
22
Herpes zoster (shingles)
0
23
Herpes simplex (extr
0
24
Herpes simplex (geni
0
25
Verruca vulgaris
0
26
Plane warts
1
27
Genital warts
0
28
Molluscum contagiosu
0
30
Acne vulgaris
0
31
Acne conglobata
0
32
Folliculitis/papulop
0
33
Keratosis follicular
0
34
Allergic cont derma
0
35
Irritant cont derma
0
36
Seborrhoeic dermatit
0
37
Atopic eczema
0
38
Nummular discoid ecz
0
39
Lichen simplex chron
0
40
Pityriasis alba
0
41
Unspec chronic derm
0
42
Pellagra
0
43
Photoallergic dermat
0
44
Phototoxic dermatiti
0
45
Dyshydrosis (pomphol
0
46
Eczematide
0
47
Acute urticaria, whe
0
48
Chronic urticaria
0
49
Papular urticaria
0
50
Pruritus without ski
0
51
Prurigo
0
52
Candidosis (paronych
0
53
Tinea pedis
0
54
Tinea inguinalis
1
55
Tinea capitis
0
56
Chronic discoid lupu
0
57
Pityriasis rosea
0
58
Cutaneous larva migr
0
59
Benign skin tumour
2
60
Kaposi's sarcoma
0
62
Malignant melanoma
0
63
Basal cell carcinoma
0
64
Squamous cell carcin
0
65
Lichen planus
0
66
Drug reaction/sj syn
0
67
Fixed drug eruption
0
68
Vitiligo
0
69
Gonorrhoea
0
70
Chancroid
0
71
Lymphogranuloma vene
0
72
Dermatitis herpetifo
0
73
Pemphigus
0
74
Pemphigoid
0
75
Porphyria cutanea ta
0
76
Stomatitis
0
77
Erythroderma
0
78
Scleroderma+morphea
0
79
Scrophuloderma
0
80
Erythema nodosum
0
81
Erythema induratum
0
82
Papulonecrotic tuber
0
83
Haemangioma
0
84
Granuloma annulare
0
85
Deep fungal infectio
0
86
Tropical ulcer
0
87
Buruli ulcer (m.ulce
0
88
Cellulitis
0
89
Erythema multiforme
0
90
Measles
0
91
Primary syphilis
0
92
Gen lymphadenopathy
0
93
Glandular tb/loc lym
0
94
Undiag urethral dis
0
95
Cysticercosis
0
96
Acne keloidalis nuch
0
97
Saocoidosis
0
98
Tinea unguum (fungal
0
99
Lichen nitidus
0
100
Lichen sclerosus et
0
101
Infective dermatitis
0
102
Pit rubra pilaris
0
103
Keratoderma
0
104
Pseudofolliculitis b
0
105
Lichen striatus
0
106
Pityriasis lichenoid
0
107
Bell's palsy
0
108
Metastatic carcinoma
0
109
Non specific ulcer
0
110
Leukaemia
0
111
Hodgkin's lymphoma
0
112
Non hodgkin's lympho
0
113
Alopecia areata
0
114
Cutaneous t cell lym
0
115
Pyogenic granuloma
0
116
B-cell lymphoma
0
117
Erythrasima
0
118
Millaria rubra/cysts
0
119
Lice(pedic.pubis/cap
0
120
Unspecified carcinom
0
121
Haemorrhoids
0
122
Elephantiasis
0
123
Hydrocoele
0
124
Hydradenitis suppuri
0
998
Unknown
0
999
Missing
0
Sysmiss
12902
Skin disease 3
Skin disease 3
1
12910
1
Malnutrition
0
2
Scabies
0
3
Ext t versicolor
0
4
Mild t versicolor
0
5
Extensive impetigo
0
6
Von Recklinghausen's
0
7
Signs of past polio
0
8
Mutism
0
9
T corporis/circinat
0
10
Sev rheumatoid arth
0
12
Morphoea (probably)
0
13
Ichthyosis
0
15
Psoriasis
0
19
Lupus vulgaris
0
20
Secondary syphilis
0
21
Chicken pox
0
22
Herpes zoster (shingles)
0
23
Herpes simplex (extr
0
24
Herpes simplex (geni
0
25
Verruca vulgaris
0
26
Plane warts
0
27
Genital warts
0
28
Molluscum contagiosu
0
30
Acne vulgaris
0
31
Acne conglobata
0
32
Folliculitis/papulop
0
33
Keratosis follicular
0
34
Allergic cont derma
0
35
Irritant cont derma
0
36
Seborrhoeic dermatit
1
37
Atopic eczema
0
38
Nummular discoid ecz
0
39
Lichen simplex chron
0
40
Pityriasis alba
0
41
Unspec chronic derm
0
42
Pellagra
0
43
Photoallergic dermat
0
44
Phototoxic dermatiti
0
45
Dyshydrosis (pomphol
0
46
Eczematide
0
47
Acute urticaria, whe
0
48
Chronic urticaria
0
49
Papular urticaria
0
50
Pruritus without ski
0
51
Prurigo
0
52
Candidosis (paronych
0
53
Tinea pedis
0
54
Tinea inguinalis
0
55
Tinea capitis
0
56
Chronic discoid lupu
0
57
Pityriasis rosea
0
58
Cutaneous larva migr
0
59
Benign skin tumour
0
60
Kaposi's sarcoma
0
62
Malignant melanoma
0
63
Basal cell carcinoma
0
64
Squamous cell carcin
0
65
Lichen planus
0
66
Drug reaction/sj syn
0
67
Fixed drug eruption
0
68
Vitiligo
0
69
Gonorrhoea
0
70
Chancroid
0
71
Lymphogranuloma vene
0
72
Dermatitis herpetifo
0
73
Pemphigus
0
74
Pemphigoid
0
75
Porphyria cutanea ta
0
76
Stomatitis
0
77
Erythroderma
0
78
Scleroderma+morphea
0
79
Scrophuloderma
0
80
Erythema nodosum
0
81
Erythema induratum
0
82
Papulonecrotic tuber
0
83
Haemangioma
0
84
Granuloma annulare
0
85
Deep fungal infectio
0
86
Tropical ulcer
0
87
Buruli ulcer (m.ulce
0
88
Cellulitis
0
89
Erythema multiforme
0
90
Measles
0
91
Primary syphilis
0
92
Gen lymphadenopathy
0
93
Glandular tb/loc lym
0
94
Undiag urethral dis
0
95
Cysticercosis
0
96
Acne keloidalis nuch
0
97
Saocoidosis
0
98
Tinea unguum (fungal
0
99
Lichen nitidus
0
100
Lichen sclerosus et
0
101
Infective dermatitis
0
102
Pit rubra pilaris
0
103
Keratoderma
0
104
Pseudofolliculitis b
0
105
Lichen striatus
0
106
Pityriasis lichenoid
0
107
Bell's palsy
0
108
Metastatic carcinoma
0
109
Non specific ulcer
0
110
Leukaemia
0
111
Hodgkin's lymphoma
0
112
Non hodgkin's lympho
0
113
Alopecia areata
0
114
Cutaneous t cell lym
0
115
Pyogenic granuloma
0
116
B-cell lymphoma
0
117
Erythrasima
0
118
Millaria rubra/cysts
0
119
Lice(pedic.pubis/cap
0
120
Unspecified carcinom
0
121
Haemorrhoids
0
122
Elephantiasis
0
123
Hydrocoele
0
124
Hydradenitis suppuri
0
998
Unknown
0
999
Missing
0
Sysmiss
12910
examination date
examination date
805
Weight at diagnosis
Weight at diagnosis
6232
6679
998
Unknown
999
Missing
Height
Height
5551
7360
mid-upper arm circumference
mid-upper arm circumference
811
12100
998
Unknown
999
Missing
Presence of BCG scar 1
Presence of BCG scar 1
5456
7455
0
None
1
Yes
2
Doubtful
3
Not examined
4
Blind review
8
Unknown
9
Missing
Size of BCG scar 1
Size of BCG scar 1
3937
8974
98
Unknown
99
Missing
Presence of BCG scar 2
Presence of BCG scar 2
3937
8974
0
None
1
Yes
2
Doubtful
3
Not examined
4
Blind review
8
Unknown
9
Missing
Size of BCG scar 2
Size of BCG scar 2
756
12155
98
Unknown
99
Missing
Presence of BCG scar 3
Presence of BCG scar 3
756
12155
0
None
1
Yes
2
Doubtful
3
Not examined
4
Blind review
8
Unknown
9
Missing
Size of BCG scar 3
Size of BCG scar 3
33
12878
98
Unknown
99
Missing
Nearest negative HIV test date closest to TB interview (D)
Nearest negative HIV test date closest to TB interview
4845
=-31 & `neg_date'~=.
replace hivstatus=0 if datehiv-`neg_date'<=(365.25*3) & datehiv-`neg_date'>=-31 & `neg_date'~=.
}]]>
First positive HIV test date (D)
First positive HIV test date
4636
Last date known not on ART (D)
Last date known not on ART
197
First date on ART (D)
First date on ART
2561
Last date known on ART (D)
Last date known on ART
2561
ART stop date (D)
ART stop date
1155
HIV status at interview date (D)
HIV status at interview date
8952
3959
0
Negative
4735
1
Positive
4217
Sysmiss
3959
gen datehiv=intdate
replace datehiv=starteps if starteps~=.
merge m:1 ident using ${hivdata}\hivart_kps_known_all, keep(master match) keepusing(firsthivposdate lastneverart_date firstart_date lastonart_date lastartstop_date neg_date*) nogen
gen hivstatus=.
gen nearesthivnegdate=.
lookfor neg_date
foreach neg_date in `r(varlist)' {
replace nearesthivnegdate=`neg_date' if datehiv-`neg_date'<=(365.25*3) & datehiv-`neg_date'>=-31 & `neg_date'~=.
replace hivstatus=0 if datehiv-`neg_date'<=(365.25*3) & datehiv-`neg_date'>=-31 & `neg_date'~=.
}
replace hivstatus=1 if datehiv>=firsthivposdate-365.25
la val hivstatus np]]>
ART status at interview date (D)
ART status at interview date
1304
11607
0
Not on ART
18
1
On ART
1286
Sysmiss
11607
gen artstatus=0 if datehiv-lastneverart_date<=(365.25*2) & datehiv-lastneverart_date>=-31 & hivstatus==1
replace artstatus=1 if firstart_date<=datehiv & datehiv-lastonart_date<=(365.25*2) & hivstatus==1
la def art 0 "Not on ART" 1 "On ART", modify
la val artstatus art]]>
Months on ART at interview date (D)
Months on ART at interview date
1286
11625
Outcome
Outcome
8962
3949
1
Treatment completed
5440
2
Died
2159
3
Transfered out
360
4
Failure
149
5
Lost/defaulted
777
8
Unknown
45
9
Missing
32
Sysmiss
3949
Date of outcome
Date of outcome
8885
if outcomdate is estimated
if outcomdate is estimated
3230
9681
1
Full date known
0
2
Day unknown
3175
3
Month unknown
0
4
Day and month unknown
55
8
Not known at all
0
9
Missing
0
Sysmiss
9681
Treatment card seen?
Treatment card seen?
869
12042
0
No
77
1
Yes
792
8
Unknown
0
9
Missing
0
Sysmiss
12042
Date of death (If later than date of outcome)
Date of death (If later than date of outcome)
375
if deathlater is estimated
if deathlater is estimated
168
12743
1
Full date known
0
2
Day unknown
126
3
Month unknown
0
4
Day and month unknown
42
8
Not known at all
0
9
Missing
0
Sysmiss
12743
Last date person observed (D)
Last date person observed
12911
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
merge m:1 ident using ${tempfiles}\fu_dates, keep(master match) nogen]]>
Last known outcome of person (D)
Last known outcome of person
12911
0
1
Alive
8620
2
Dead
3436
3
Left
855
4
Missed
0
8
Unknown
0
9
Missing
0
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
merge m:1 ident using ${tempfiles}\fu_dates, keep(master match) nogen]]>
Transfer to where
Transfer to where
492
0
Date outcome form filled
Date outcome form filled
6052
No info - pt died or transferred
No info - pt died or transferred
4084
8827
0
No
3806
1
Yes
278
8
Unknown
0
9
Missing
0
Sysmiss
8827