/*ADLs 2001*/

/*ADL*/
/*If respondent doesn't do (=7) AND gets help (=1), then is recoded 1 in all the items*/
/*If respondent doesn't do (=7) AND doesn't get help (=0), then is recoded missing (=.) in all the items*/
/*If respondent can't do (=6), then is recoded as 1*/
/*If respondent doesn't know or refuses to answer, then is recoded as missing (=.)*/
/*If respondent says no, then is recoded as 0*/

/*BATHE*/
gen bath_01=0
replace bath_01=1 if h16_1==1
replace bath_01=1 if h16_1==6
replace bath_01=1 if h16_1==7 & h16_3==1
replace bath_01=1 if h16_1==7 & h16_4==1
replace bath_01=. if h16_1==7 & (h16_3==2 & h16_4==2)
replace bath_01=. if h16_1==8 | h16_1==9


/*EAT*/
gen eat_01=0
replace eat_01=1 if h17_1==1
replace eat_01=1 if h17_1==6
replace eat_01=1 if h17_1==7 & h17_3==1
replace eat_01=1 if h17_1==7 & h17_4==1
replace eat_01=. if h17_1==7 & (h17_3==2 & h17_4==2)
replace eat_01=. if h17_1==8 | h17_1==9

/*TRANSFER IN/OUT OF BED*/
gen bed_01=0
replace bed_01=1 if h18_1==1
replace bed_01=1 if h18_1==6
replace bed_01=1 if h18_1==7 & h18_3==1
replace bed_01=1 if h18_1==7 & h18_4==1
replace bed_01=. if h18_1==7 & (h18_3==2 & h16_4==2)
replace bed_01=. if h18_1==8 | h18_1==9

/*TOILET*/
gen toil_01=0
replace toil_01=1 if h19_1==1
replace toil_01=1 if h19_1==6
replace toil_01=1 if h19_1==7 & h19_3==1
replace toil_01=1 if h19_1==7 & h19_4==1
replace toil_01=. if h19_1==7 & (h19_3==2 & h19_4==2)
replace toil_01=. if h19_1==8 | h19_1==9

/*DRESS*/
gen dress_01=0
replace dress_01=1 if h13==1
replace dress_01=1 if h13==6
replace dress_01=1 if h13==7 & h14==1
replace dress_01=. if h13==7 & (h14==2 | h14==8 | h14==9)
replace dress_01=. if h13==8 | h13==9 | h13==.

tab bath_01, miss
tab eat_01, miss
tab bed_01, miss
tab toil_01, miss
tab dress_01, miss

/*ADL score from 0 to 5, including dressing*/
/*If at least one is missing and the non-missing are all 0, then score=.*/
gen adlsc_01=bath_01+eat_01+bed_01+toil_01+dress_01
tab adlsc_01, miss

/*ADL dummy*/
/*1=At least one ADL disability, 0=No ADL issues*/
/*Using the adlsc_01, if at least one is missing and at least one of the non-missing is equal to 1, then adl_01=1*/
gen adl_01=.
replace adl_01=0 if adlsc_01==0
replace adl_01=1 if adlsc_01>=1 & adlsc_01<=5
replace adl_01=1 if adlsc_01==. & (bath_01==1 | eat_01==1 | bed_01==1 | toil_01==1 | dress_01==1)
replace adl_01=0 if adlsc_01==. & bath_01==. & eat_01==. & bed_01==. & toil_01==. & dress_01==0
tab adl_01, miss

/*ADLs 2003*/

/*ADL*/
/*If respondent doesn't do (=7) AND gets help (=1), then is recoded 1 in all the items*/
/*If respondent doesn't do (=7) AND doesn't get help (=0), then is recoded missing (=.) in all the items*/
/*If respondent can't do (=6), then is recoded as 1*/
/*If respondent doesn't know or refuses to answer, then is recoded as missing (=.)*/
/*If respondent says no, then is recoded as 0*/

/*BATHE*/
gen bath_03=0
replace bath_03=1 if h16a_03==1
replace bath_03=1 if h16a_03==6
replace bath_03=1 if h16a_03==7 & h16e_03==1
replace bath_03=1 if h16a_03==7 & h16f_03==1
replace bath_03=. if h16a_03==7 & (h16e_03==2 & h16f_03==2)
replace bath_03=. if h16a_03==8 | h16a_03==9

/*EAT*/
gen eat_03=0
replace eat_03=1 if h17a_03==1
replace eat_03=1 if h17a_03==6
replace eat_03=1 if h17a_03==7 & h17e_03==1
replace eat_03=1 if h17a_03==7 & h17f_03==1
replace eat_03=. if h17a_03==7 & (h17e_03==2 & h17f_03==2)
replace eat_03=. if h17a_03==8 | h17a_03==9

/*TRANSFER IN/OUT OF BED*/
gen bed_03=0
replace bed_03=1 if h18a_03==1
replace bed_03=1 if h18a_03==6
replace bed_03=1 if h18a_03==7 & h18e_03==1
replace bed_03=1 if h18a_03==7 & h18f_03==1
replace bed_03=. if h18a_03==7 & (h18e_03==2 & h16f_03==2)
replace bed_03=. if h18a_03==8 | h18a_03==9

/*TOILET*/
gen toil_03=0
replace toil_03=1 if h19a_03==1
replace toil_03=1 if h19a_03==6
replace toil_03=1 if h19a_03==7 & h19e_03==1
replace toil_03=1 if h19a_03==7 & h19f_03==1
replace toil_03=. if h19a_03==7 & (h19e_03==2 & h19f_03==2)
replace toil_03=. if h19a_03==8 | h19a_03==9

/*DRESS*/
gen dress_03=0
replace dress_03=1 if h13_03==1
replace dress_03=1 if h13_03==6
replace dress_03=1 if h13_03==7 & h14_03==1
replace dress_03=. if h13_03==7 & (h14_03==2 | h14_03==8 | h14_03==9)
replace dress_03=. if h13_03==8 | h13_03==9 | h13_03==.

tab bath_03, miss
tab eat_03, miss
tab bed_03, miss
tab toil_03, miss
tab dress_03, miss

/*ADL score from 0 to 5, including dressing*/
/*If at least one is missing, then score=.*/
gen adlsc_03=bath_03+eat_03+bed_03+toil_03+dress_03
tab adlsc_03, miss

/*ADL dummy*/
/*1=At least one ADL disability, 0=No ADL issues*/
/*Using the adlsc_03, if at least one is missing and at least one of the non-missing is equal to 1, then adl_03=1*/
gen adl_03=.
replace adl_03=0 if adlsc_03==0
replace adl_03=1 if adlsc_03>=1 & adlsc_03<=5
replace adl_03=1 if adlsc_03==. & (bath_03==1 | eat_03==1 | bed_03==1 | toil_03==1 | dress_03==1)
replace adl_03=0 if adlsc_03==. & bath_03==. & eat_03==. & bed_03==. & toil_03==. & dress_03==0
tab adl_03, miss

/*ADLs 2012*/

/*ADL*/
/*If respondent doesn't do (=7) AND gets help (=1), then is recoded 1 in all the items*/
/*If respondent doesn't do (=7) AND doesn't get help (=2), then is recoded missing (=.) in all the items*/
/*If respondent can't do (=6), then is recoded as 1*/
/*If respondent doesn't know or refuses to answer, then is recoded as missing (=.)*/
/*If respondent says no, then is recoded as 0*/

/*BATHE*/
gen bath_12=0
replace bath_12=1 if h16a_12==1
replace bath_12=1 if h16a_12==6
replace bath_12=1 if h16a_12==7 & h16d_12==1
replace bath_12=. if h16a_12==7 & h16d_12==2
replace bath_12=. if h16a_12==8 | h16a_12==9

/*EAT*/
gen eat_12=0
replace eat_12=1 if h17a_12==1
replace eat_12=1 if h17a_12==6
replace eat_12=1 if h17a_12==7 & h17d_12==1
replace eat_12=. if h17a_12==7 & h17d_12==2
replace eat_12=. if h17a_12==8 | h17a_12==9

/*TRANSFER IN/OUT OF BED*/
/*Those who need special equipment to help/support them in this activity, where also assigned a value of 1*/
gen bed_12=0
replace bed_12=1 if h18a_12==1
replace bed_12=1 if h18a_12==6
replace bed_12=1 if h18b_12==1
replace bed_12=1 if h18a_12==7 & (h18b_12==1 | h18d_12==1)
replace bed_12=. if h18a_12==7 & (h18b_12==2 | h18d_12==2)
replace bed_12=. if h18a_12==8 | h18a_12==9

/*TOILET*/
gen toil_12=0
replace toil_12=1 if h19a_12==1
replace toil_12=1 if h19a_12==6
replace toil_12=1 if h19a_12==7 & h19d_12==1
replace toil_12=. if h19a_12==7 & h19d_12==2
replace toil_12=. if h19a_12==8 | h19a_12==9

/*DRESS*/
gen dress_12=0
replace dress_12=1 if h13_12==1
replace dress_12=1 if h13_12==6
replace dress_12=1 if h13_12==7 & h14_12==1
replace dress_12=. if h13_12==7 & (h14_12==2 | h14_12==8 | h14_12==9)
replace dress_12=. if h13_12==8 | h13_12==9 | h13_12==.

tab bath_12, miss
tab eat_12, miss
tab bed_12, miss
tab toil_12, miss
tab dress_12, miss

/*ADL score from 0 to 5, including dressing*/
/*If at least one is missing, then score=.*/
gen adlsc_12=bath_12+eat_12+bed_12+toil_12+dress_12
tab adlsc_12, miss

/*ADL dummy*/
/*1=At least one ADL disability, 0=No ADL issues*/
/*Using the adlsc_12, if at least one is missing and at least one of the non-missing is equal to 1, then adl_12=1*/
gen adl_12=.
replace adl_12=0 if adlsc_12==0
replace adl_12=1 if adlsc_12>=1 & adlsc_12<=5
replace adl_12=1 if adlsc_12==. & (bath_12==1 | eat_12==1 | bed_12==1 | toil_12==1 | dress_12==1)
replace adl_12=0 if adlsc_12==. & bath_12==. & eat_12==. & bed_12==. & toil_12==. & dress_12==0
tab adl_12, miss