-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathOPTIONAL_Add Participant Base.do
90 lines (71 loc) · 4.97 KB
/
OPTIONAL_Add Participant Base.do
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
****ADDING IN ALL PARTICIPANTS WITHOUT DATA ON SEX*****
clear
use "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_sex_gender.dta"
keep if object=="llc_sex"
save "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_sex_+base.dta", replace
clear
use "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\Tables\Self-Report Tables\CORE_denominator_file1.dta"
merge 1:1 LLC_0001_stud_id using "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_sex_+base.dta"
****add object in for missing values****
replace object="llc_sex" if object==""
save "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_sex_+base.dta", replace
****ADDING IN ALL PARTICIPANTS WITHOUT DATA ON GENDER*****
clear
use "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_sex_gender.dta"
keep if object=="llc_gender"
save "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_gender_+base.dta", replace
clear
use "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\Tables\Self-Report Tables\CORE_denominator_file1.dta"
merge 1:1 LLC_0001_stud_id using "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_gender_+base.dta"
****add object in for missing values****
replace object="llc_gender" if object==""
save "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_gender_+base.dta", replace
****ADDING IN ALL PARTICIPANTS WITHOUT DATA ON ETHNICITY 3*****
clear
use "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity.dta"
keep if object=="llc_ethnic3"
save "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity3_+base.dta", replace
clear
use "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\Tables\Self-Report Tables\CORE_denominator_file1.dta"
merge 1:1 LLC_0001_stud_id using "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity3_+base.dta"
****add object in for missing values****
replace object="llc_ethnic3" if object==""
save "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity3_+base.dta", replace
****ADDING IN ALL PARTICIPANTS WITHOUT DATA ON ETHNICITY 6*****
clear
use "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity.dta"
keep if object=="llc_ethnic6"
save "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity6_+base.dta", replace
clear
use "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\Tables\Self-Report Tables\CORE_denominator_file1.dta"
merge 1:1 LLC_0001_stud_id using "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity6_+base.dta"
****add object in for missing values****
replace object="llc_ethnic6" if object==""
save "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity6_+base.dta", replace
****ADDING IN ALL PARTICIPANTS WITHOUT DATA ON ETHNICITY 7*****
clear
use "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity.dta"
keep if object=="llc_ethnic7"
save "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity7_+base.dta", replace
clear
use "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\Tables\Self-Report Tables\CORE_denominator_file1.dta"
merge 1:1 LLC_0001_stud_id using "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity7_+base.dta"
****add object in for missing values****
replace object="llc_ethnic7" if object==""
save "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity7_+base.dta", replace
****ADDING IN ALL PARTICIPANTS WITHOUT DATA ON AGE*****
clear
use "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_age.dta"
merge 1:1 LLC_0001_stud_id using "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\Tables\Self-Report Tables\CORE_denominator_file1.dta"
****add object in for missing values****
replace object="llc_age" if object==""
save "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_age_+base.dta", replace
***merging all datasets back into one dataset which has the missing participants
use "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity3_+base.dta"
append using "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity6_+base.dta"
append using "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_ethnicity7_+base.dta"
append using "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_sex_+base.dta"
append using "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_gender_+base.dta"
append using "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_harmonised_age_+base.dta"
drop _merge
save "S:\LLC_0001\Self-Reported Harmonised Variables\Datasets\llc_0001_full_harmonised_+base", replace