** The effect of community-based behaviour change interventions on observed handwashing and child faeces disposal in rural Malawi: a controlled before-and-after (CBA) trial

* Hand hygiene direct observations

**---------------------------------------------------------------------------------------------------------------
* README
**---------------------------------------------------------------------------------------------------------------

* This Stata do-file estimates the mixed-effects logistic regression models reported in Tables 2, S1, S2, and S3 of the paper

* 1. System requirements -- 

	* Operating system: Windows 10 or later, macOS Monterey or later, Linux (test on macOS Monterey)
	* Software: Stata/SE, version 17 or 18 (tested on 18.0 SE)
	* No stata packages required

* 2. Installation guide

	* Install Stata (version 17 or later) from https://download.stata.com/download/ 
	* Place the appropriate dataset and Stata do-file in the same working director
	* Typical install time is less than 10 minutes

* 3. Demo

	* Set working directory to the folder with the dataset and do-file
	* Run the script below
	* Main outputs include regression tables showing mixed-effects logistic regression results (including odds and risk ratios, robust SEs, random-effects estimates)
	* Run time is less than one minutes

* 4. Instructions for use

	* Import the dataset "w4e_analysis_obs_hyg_behav.csv"
	* Run the analysis using the CBA_Malawi_hygiene_analysis.do file
	* The script will run the regression models and export the results to an output file


**---------------------------------------------------------------------------------------------------------------
* HANDWASHING WITH SOAP
**---------------------------------------------------------------------------------------------------------------

**---------------------------------------------------------------------------------------------------------------
* Handwashing with soap - CLTS and CLTS+ vs control (Table S1)
**---------------------------------------------------------------------------------------------------------------

* Unadjusted
melogit sec_out_hw_behav ib2.g1_name_of_ta##i.baseline_endline comm_hhmed || village:, eform vce(robust)
estat icc


* Adjusted
melogit sec_out_hw_behav ib2.g1_name_of_ta##i.baseline_endline c.n_hh_members i.disability_overall i.quintile i.water_source_onsite_onplot comm_hhmed || village:, eform vce(robust)
estat icc


**---------------------------------------------------------------------------------------------------------------
* Handwashing with soap - CLTS+ vs CLTS (Table S2)
**---------------------------------------------------------------------------------------------------------------
	
drop if g1_name_of_ta == 2

* Unadjusted
melogit sec_out_hw_behav ib3.g1_name_of_ta##i.baseline_endline comm_hhmed || village:, eform vce(robust)


* Adjusted
melogit sec_out_hw_behav ib3.g1_name_of_ta##i.baseline_endline c.n_hh_members i.disability_overall i.quintile i.water_source_onsite_onplot comm_hhmed || village:, eform vce(robust)



**---------------------------------------------------------------------------------------------------------------
* HANDWASHING - MULTI-LEVEL OUTCOME
**---------------------------------------------------------------------------------------------------------------	

* Multi-leval hand hygiene variable

	* 1 = no action
	* 2 = hand rinsing
	* 3 = handwashing with soap

**---------------------------------------------------------------------------------------------------------------
* HWWS and hand rinsing - CLTS and CLTS+ vs control (Table 2)
**---------------------------------------------------------------------------------------------------------------	

* Unadjusted
mlogit hand_hygiene_behaviour ib2.g1_name_of_ta##i.baseline_endline comm_hhmed, cluster(village) rrr
estat icc

* Adjusted
mlogit hand_hygiene_behaviour ib2.g1_name_of_ta##i.baseline_endline c.n_hh_members i.disability_overall i.quintile i.water_source_onsite_onplot comm_hhmed, cluster(village) rrr
estat icc

**---------------------------------------------------------------------------------------------------------------
* HWWS and hand rinsing - CLTS VS CLTS+ (Table S3)
**---------------------------------------------------------------------------------------------------------------	

drop if g1_name_of_ta == 2

* Unadjusted
mlogit hand_hygiene_behaviour ib3.g1_name_of_ta##i.baseline_endline comm_hhmed, cluster(village) rrr

* Adjusted
mlogit hand_hygiene_behaviour ib3.g1_name_of_ta##i.baseline_endline c.n_hh_members i.disability_overall i.quintile i.water_source_onsite_onplot comm_hhmed, cluster(village) rrr