adhd_wave_1

/*Age at 7-year follow-up*/
gen alder = floor((udfyldto - eventda)/(365.2422))
replace alder=. if alder==9

* Generating ADHD score at 7 year
gen adhd_raw_7 = 0    
gen Nc = 0 
local vars "z070_02_sdq z070_10_sdq z070_15_sdq z070_21_sdq z070_25_sdq" 
local nvars = 0 
foreach v of varlist `vars' { 
    replace adhd_raw_7 = adhd_raw_7 + cond(missing(`v'), 0, `v') 
    replace Nc = Nc + !missing(`v') 
    local ++nvars 
 }
replace adhd_raw_7 = . if Nc /`nvars' < 0.75
replace adhd_raw_7 = . if alder!=7

gen adhd_age_7 = alder if alder==7
replace adhd_age_7 = . if adhd_raw_7==.
gen adhd_instr_7 = 47 if (adhd_raw_7!=.) //sdq//
gen adhd_eval_7 = 2 if (adhd_raw_7!=.) //parent//

replace adhd_raw_7 = . if adhd_age_7==.
gen adhd_avg_7 = adhd_raw_7 / Nc if adhd_age_7!=.
gen adhd_pro_7 = round(adhd_avg_7*`nvars') if adhd_avg_7!=.
xtile adhd_pc_7 = adhd_pro_7, nq(100)
drop Nc

* Generating ADHD score at 8 year
gen adhd_raw_8 = 0    
gen Nc = 0 
local vars "z070_02_sdq z070_10_sdq z070_15_sdq z070_21_sdq z070_25_sdq" 
local nvars = 0 
foreach v of varlist `vars' { 
    replace adhd_raw_8 = adhd_raw_8 + cond(missing(`v'), 0, `v') 
    replace Nc = Nc + !missing(`v') 
    local ++nvars 
 }
replace adhd_raw_8 = . if Nc /`nvars' < 0.75
replace adhd_raw_8 = . if alder!=8

gen adhd_age_8 = alder if alder==8
replace adhd_age_8 = . if adhd_raw_8==.
gen adhd_instr_8 = 47 if (adhd_raw_8!=.) //sdq//
gen adhd_eval_8 = 2 if (adhd_raw_8!=.) //parent//

replace adhd_raw_8=. if adhd_age_8==.
gen adhd_avg_8 = adhd_raw_8 / Nc if adhd_age_8!=.
gen adhd_pro_8 = round(adhd_avg_8*`nvars') if adhd_avg_8!=.
xtile adhd_pc_8 = adhd_pro_8, nq(100)
drop Nc

* Generating wave 1
gen adhd_wave_1 = .
replace adhd_wave_1 = 1 if (adhd_raw_7!=. | adhd_raw_8!=.)

/*Age at 11-year follow-up*/
gen alder2 = floor((f_qdate - eventda)/(365.2422))
replace alder2=. if alder2==15 | alder2==16

/*Replace 'Not answered' (=99) as missing (=.) and adjust values when using F156_ variables*/
replace f156_1=. if f156_1==99
replace f156_1=0 if f156_1==1
replace f156_1=1 if f156_1==2
replace f156_1=2 if f156_1==3
 
replace f156_2=. if f156_2==99
replace f156_2=0 if f156_2==1
replace f156_2=1 if f156_2==2
replace f156_2=2 if f156_2==3

replace f156_3=. if f156_3==99
replace f156_3=0 if f156_3==1
replace f156_3=1 if f156_3==2
replace f156_3=2 if f156_3==3

replace f156_4=. if f156_4==99
replace f156_4=0 if f156_4==1
replace f156_4=1 if f156_4==2
replace f156_4=2 if f156_4==3

replace f156_5=. if f156_5==99
replace f156_5=0 if f156_5==1
replace f156_5=1 if f156_5==2
replace f156_5=2 if f156_5==3

replace f156_6=. if f156_6==99
replace f156_6=0 if f156_6==1
replace f156_6=1 if f156_6==2
replace f156_6=2 if f156_6==3

replace f156_7=. if f156_7==99
replace f156_7=2 if f156_7==1
replace f156_7=1 if f156_7==2
replace f156_7=0 if f156_7==3

replace f156_8=. if f156_8==99
replace f156_8=0 if f156_8==1
replace f156_8=1 if f156_8==2
replace f156_8=2 if f156_8==3

replace f156_9=. if f156_9==99
replace f156_9=0 if f156_9==1
replace f156_9=1 if f156_9==2
replace f156_9=2 if f156_9==3

replace f156_10=. if f156_10==99
replace f156_10=0 if f156_10==1
replace f156_10=1 if f156_10==2
replace f156_10=2 if f156_10==3

replace f156_11=. if f156_11==99
replace f156_11=2 if f156_11==1
replace f156_11=1 if f156_11==2
replace f156_11=0 if f156_11==3

replace f156_12=. if f156_12==99
replace f156_12=0 if f156_12==1
replace f156_12=1 if f156_12==2
replace f156_12=2 if f156_12==3

replace f156_13=. if f156_13==99
replace f156_13=0 if f156_13==1
replace f156_13=1 if f156_13==2
replace f156_13=2 if f156_13==3

replace f156_14=. if f156_14==99
replace f156_14=2 if f156_14==1
replace f156_14=1 if f156_14==2
replace f156_14=0 if f156_14==3

replace f156_15=. if f156_15==99
replace f156_15=0 if f156_15==1
replace f156_15=1 if f156_15==2
replace f156_15=2 if f156_15==3

replace f156_16=. if f156_16==99
replace f156_16=0 if f156_16==1
replace f156_16=1 if f156_16==2
replace f156_16=2 if f156_16==3

replace f156_17=. if f156_17==99
replace f156_17=0 if f156_17==1
replace f156_17=1 if f156_17==2
replace f156_17=2 if f156_17==3

replace f156_18=. if f156_18==99
replace f156_18=0 if f156_18==1
replace f156_18=1 if f156_18==2
replace f156_18=2 if f156_18==3

replace f156_19=. if f156_19==99
replace f156_19=0 if f156_19==1
replace f156_19=1 if f156_19==2
replace f156_19=2 if f156_19==3

replace f156_20=. if f156_20==99
replace f156_20=0 if f156_20==1
replace f156_20=1 if f156_20==2
replace f156_20=2 if f156_20==3

replace f156_21=. if f156_21==99
replace f156_21=2 if f156_21==1
replace f156_21=1 if f156_21==2
replace f156_21=0 if f156_21==3

replace f156_22=. if f156_22==99
replace f156_22=0 if f156_22==1
replace f156_22=1 if f156_22==2
replace f156_22=2 if f156_22==3

replace f156_23=. if f156_23==99
replace f156_23=0 if f156_23==1
replace f156_23=1 if f156_23==2
replace f156_23=2 if f156_23==3

replace f156_24=. if f156_24==99
replace f156_24=0 if f156_24==1
replace f156_24=1 if f156_24==2
replace f156_24=2 if f156_24==3

replace f156_25=. if f156_25==99
replace f156_25=2 if f156_25==1
replace f156_25=1 if f156_25==2
replace f156_25=0 if f156_25==3

* Generating ADHD score at 11 year
gen adhd_raw_11 = 0    
gen Nc = 0 
local vars "f156_2_sdq f156_10_sdq f156_15_sdq f156_21_sdq f156_25_sdq" 
local nvars = 0 
foreach v of varlist `vars' { 
    replace adhd_raw_11 = adhd_raw_11 + cond(missing(`v'), 0, `v') 
    replace Nc = Nc + !missing(`v') 
    local ++nvars 
 }
replace adhd_raw_11 = . if Nc /`nvars' < 0.75
replace adhd_raw_11 = . if alder2!=11

gen adhd_age_11 = alder2 if alder2==11
replace adhd_age_11 = . if adhd_raw_11==.
gen adhd_instr_11 = 47 if (adhd_raw_11!=.) //sdq//
gen adhd_eval_11 = 2 if (adhd_raw_11!=.) //parent//

replace adhd_raw_11=. if adhd_age_11==.
gen adhd_avg_11 = adhd_raw_11 / Nc if adhd_age_11!=.
gen adhd_pro_11 = round(adhd_avg_11*`nvars') if adhd_avg_11!=.
xtile adhd_pc_11 = adhd_pro_11, nq(100)
drop Nc

* Generating ADHD score at 12 year
gen adhd_raw_12 = 0    
gen Nc = 0 
local vars "f156_2_sdq f156_10_sdq f156_15_sdq f156_21_sdq f156_25_sdq" 
local nvars = 0 
foreach v of varlist `vars' { 
    replace adhd_raw_12 = adhd_raw_12 + cond(missing(`v'), 0, `v') 
    replace Nc = Nc + !missing(`v') 
    local ++nvars 
 }
replace adhd_raw_12 = . if Nc /`nvars' < 0.75
replace adhd_raw_12 = . if alder2!=12

gen adhd_age_12 = alder2 if alder2==12
replace adhd_age_12 = . if adhd_raw_12==.
gen adhd_instr_12 = 47 if (adhd_raw_12!=.) //sdq//
gen adhd_eval_12 = 2 if (adhd_raw_12!=.) //parent//

replace adhd_raw_12=. if adhd_age_12==.
gen adhd_avg_12 = adhd_raw_12 / Nc if adhd_age_12!=.
gen adhd_pro_12 = round(adhd_avg_12*`nvars') if adhd_avg_12!=.
xtile adhd_pc_12 = adhd_pro_12, nq(100)
drop Nc

* Generating ADHD score at 13 year
gen adhd_raw_13 = 0    
gen Nc = 0 
local vars "f156_2_sdq f156_10_sdq f156_15_sdq f156_21_sdq f156_25_sdq" 
local nvars = 0 
foreach v of varlist `vars' { 
    replace adhd_raw_13 = adhd_raw_13 + cond(missing(`v'), 0, `v') 
    replace Nc = Nc + !missing(`v') 
    local ++nvars 
 }
replace adhd_raw_13 = . if Nc /`nvars' < 0.75
replace adhd_raw_13 = . if alder2!=13

gen adhd_age_13 = alder2 if alder2==13
replace adhd_age_13 = . if adhd_raw_13==.
gen adhd_instr_13 = 47 if (adhd_raw_13!=.)
gen adhd_eval_13 = 2 if (adhd_raw_13!=.)

replace adhd_raw_13=. if adhd_age_13==.
gen adhd_avg_13 = adhd_raw_13 / Nc if adhd_age_13!=.
gen adhd_pro_13 = round(adhd_avg_13*`nvars') if adhd_avg_13!=.
xtile adhd_pc_13 = adhd_pro_13, nq(100)
drop Nc

* Generating ADHD score at 14 year
gen adhd_raw_14 = 0    
gen Nc = 0 
local vars "f156_2_sdq f156_10_sdq f156_15_sdq f156_21_sdq f156_25_sdq" 
local nvars = 0 
foreach v of varlist `vars' { 
    replace adhd_raw_14 = adhd_raw_14 + cond(missing(`v'), 0, `v') 
    replace Nc = Nc + !missing(`v') 
    local ++nvars 
 }
replace adhd_raw_14 = . if Nc /`nvars' < 0.75
replace adhd_raw_14 = . if alder2!=14

gen adhd_age_14 = alder2 if alder2==14
replace adhd_age_14 = . if adhd_raw_14==.
gen adhd_instr_14 = 47 if (adhd_raw_14!=.) //sdq//
gen adhd_eval_14 = 2 if (adhd_raw_14!=.) //parent//

replace adhd_raw_14=. if adhd_age_14==.
gen adhd_avg_14 = adhd_raw_14 / Nc if adhd_age_14!=.
gen adhd_pro_14 = round(adhd_avg_14*`nvars') if adhd_avg_14!=.
xtile adhd_pc_14 = adhd_pro_14, nq(100)
drop Nc

* Generating wave 2
gen adhd_wave_2 = .
replace adhd_wave_2 = 1 if (adhd_raw_11!=. | adhd_raw_12!=. | adhd_raw_13!=. | adhd_raw_14!=.)

/* Age at 18-year follow-up */
gen alder3 = floor((g_completed_date-eventda)/(365.2422))
replace alder3=. if alder3==21 | alder3==22

* Replacing 99 with . in 18-year follow-up
replace g062_01_sdq=. if g062_01_sdq==99
replace g062_02_sdq=. if g062_02_sdq==99
replace g062_03_sdq=. if g062_03_sdq==99
replace g062_04_sdq=. if g062_04_sdq==99
replace g062_05_sdq=. if g062_05_sdq==99
replace g062_06_sdq=. if g062_06_sdq==99
replace g062_07_sdq=. if g062_07_sdq==99
replace g062_08_sdq=. if g062_08_sdq==99
replace g062_09_sdq=. if g062_09_sdq==99
replace g062_10_sdq=. if g062_10_sdq==99
replace g062_11_sdq=. if g062_11_sdq==99
replace g062_12_sdq=. if g062_12_sdq==99
replace g062_13_sdq=. if g062_13_sdq==99
replace g062_14_sdq=. if g062_14_sdq==99
replace g062_15_sdq=. if g062_15_sdq==99
replace g062_16_sdq=. if g062_16_sdq==99
replace g062_17_sdq=. if g062_17_sdq==99
replace g062_18_sdq=. if g062_18_sdq==99
replace g062_19_sdq=. if g062_19_sdq==99
replace g062_20_sdq=. if g062_20_sdq==99
replace g062_21_sdq=. if g062_21_sdq==99
replace g062_22_sdq=. if g062_22_sdq==99
replace g062_23_sdq=. if g062_23_sdq==99
replace g062_24_sdq=. if g062_24_sdq==99
replace g062_25_sdq=. if g062_25_sdq==99

* Generating ADHD score at 18 year
gen adhd_raw_18 = 0    
gen Nc = 0 
local vars "g062_02_sdq g062_10_sdq g062_15_sdq g062_21_sdq g062_25_sdq" 
local nvars = 0 
foreach v of varlist `vars' { 
    replace adhd_raw_18 = adhd_raw_18 + cond(missing(`v'), 0, `v') 
    replace Nc = Nc + !missing(`v') 
    local ++nvars 
 }
replace adhd_raw_18 = . if Nc /`nvars' < 0.75
replace adhd_raw_18 = . if alder3!=18

gen adhd_age_18 = alder3 if alder3==18
replace adhd_age_18 = . if adhd_raw_18==.
gen adhd_instr_18 = 47 if (adhd_raw_18!=.) //sdq//
gen adhd_eval_18 = 5 if (adhd_raw_18!=.) //self-reported//

replace adhd_raw_18=. if adhd_age_18==.
gen adhd_avg_18 = adhd_raw_18 / Nc if adhd_age_18!=.
gen adhd_pro_18 = round(adhd_avg_18*`nvars') if adhd_avg_18!=.
xtile adhd_pc_18 = adhd_pro_18, nq(100)
drop Nc

* Generating ADHD score at 19 year
gen adhd_raw_19 = 0    
gen Nc = 0 
local vars "g062_02_sdq g062_10_sdq g062_15_sdq g062_21_sdq g062_25_sdq" 
local nvars = 0 
foreach v of varlist `vars' { 
    replace adhd_raw_19 = adhd_raw_19 + cond(missing(`v'), 0, `v') 
    replace Nc = Nc + !missing(`v') 
    local ++nvars 
 }
replace adhd_raw_19 = . if Nc /`nvars' < 0.75
replace adhd_raw_19 = . if alder3!=19

gen adhd_age_19 = alder3 if alder3==19
replace adhd_age_19 = . if adhd_raw_19==.
gen adhd_instr_19 = 47 if (adhd_raw_19!=.) //sdq//
gen adhd_eval_19 = 5 if (adhd_raw_19!=.) //self-reported//

replace adhd_raw_19=. if adhd_age_19==.
gen adhd_avg_19 = adhd_raw_19 / Nc if adhd_age_19!=.
gen adhd_pro_19 = round(adhd_avg_19*`nvars') if adhd_avg_19!=.
xtile adhd_pc_19 = adhd_pro_19, nq(100)
drop Nc

* Generating ADHD score at 20 year
gen adhd_raw_20 = 0    
gen Nc = 0 
local vars "g062_02_sdq g062_10_sdq g062_15_sdq g062_21_sdq g062_25_sdq" 
local nvars = 0 
foreach v of varlist `vars' { 
    replace adhd_raw_20 = adhd_raw_20 + cond(missing(`v'), 0, `v') 
    replace Nc = Nc + !missing(`v') 
    local ++nvars 
 }
replace adhd_raw_20 = . if Nc /`nvars' < 0.75
replace adhd_raw_20 = . if alder3!=20

gen adhd_age_20 = alder3 if alder3==20
replace adhd_age_20 = . if adhd_raw_20==.
gen adhd_instr_20 = 47 if (adhd_raw_20!=.) //sdq//
gen adhd_eval_20 = 5 if (adhd_raw_20!=.) //self-reported//

replace adhd_raw_20=. if adhd_age_20==.
gen adhd_avg_20 = adhd_raw_20 / Nc if adhd_age_20!=.
gen adhd_pro_20 = round(adhd_avg_20*`nvars') if adhd_avg_20!=.
xtile adhd_pc_20 = adhd_pro_20, nq(100)
drop Nc

* Generating wave 3
gen adhd_wave_3 = .
replace adhd_wave_3 = 1 if (adhd_raw_18!=. | adhd_raw_19!=. | adhd_raw_20!=.)