Derivation
variable: electric (table[s]: css_seh, gp_gphhold)
variable: elec (table[s]: caps_blhse)
variable: felect (table[s]: caps_blhse)
variable: electric_mode (table[s]: NCD_combined_data_all_final [derived table])
<SEH data is converted to be binary before data are appended together:>
rename (electric water) (electric2 water1)
gen electric=1 if electric2==1 /*Escom*/| electric2==2 /*solar*/
<CAPS data asks about electricity in relation to cooking and fuel, this is converted to one binary variable:>
gen electric=0
replace electric=1 if felect==1 | elec==1