** 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 * Child faeces direct observations **--------------------------------------------------------------------------------------------------------------- * README **--------------------------------------------------------------------------------------------------------------- * This Stata do-file estimates the mixed-effects logistic regression models reported in Tables S1 and S2 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 "CBA_Malawi_sanitation_data.csv" * Run the analysis using the CBA_Malawi_sanitation_analysis.do file * The script will run the regression models and export the results to an output file **--------------------------------------------------------------------------------------------------------------- * Child faeces disposal - CLTS and CLTS+ vs control (Table S1) **--------------------------------------------------------------------------------------------------------------- * Unadjusted melogit sec_out_safe_disposal_child_faec ib2.g1_name_of_ta##i.baseline_endline comm_hhmed || village:, eform vce(robust) estat icc * Adjusted melogit sec_out_safe_disposal_child_faec ib2.g1_name_of_ta##i.baseline_endline c.n_hh_members c.disability_overall i.quintile i.water_source_onsite_onplot comm_hhmed || village:, eform vce(robust) estat icc **--------------------------------------------------------------------------------------------------------------- * Child faeces disposal - CLTS+ vs CLTS (Table S2) **--------------------------------------------------------------------------------------------------------------- drop if g1_name_of_ta == 2 * Unadjusted melogit sec_out_safe_disposal_child_faec ib3.g1_name_of_ta##i.baseline_endline comm_hhmed || village:, eform vce(robust) * Adjusted melogit sec_out_safe_disposal_child_faec ib3.g1_name_of_ta##i.baseline_endline c.n_hh_members c.disability_overall i.quintile i.water_source_onsite_onplot comm_hhmed || village:, eform vce(robust)