set more off clear all use "Combined_FU1_FU2_ready.dta", clear program produce_results_mean args question group hypothesis local lab: variable label `question' local lab=subinstr("`lab'","(","[",.) local lab=subinstr("`lab'",")","]",.) areg `question' treatment_FU1 treatment_FU2 FU2 $cond, a(Pair) cluster(Cluster) test treatment_FU1=treatment_FU2 outreg2 using "$file_treatment.xls", excel side bdec(4) bracket label ct("`group'", "`hypothesis'", "`question'", "`lab'") addstat("p-value for equality of effects", r(p)) se $opt global opt="append" end program drop produce_results_mean program produce_results_mean local i = 1 while "``i''" != "" { local ++i } local --i local arg=`i'-1 local commmand_suest="" local test_suest_FU1="" local test_suest_FU2="" local test_suest_FU1_n=0 local test_suest_FU2_n=0 *preserve local FU1_numb=0 forvalues x=1/`arg'{ qui sum ``x'' if Survey==1 local FU1=(r(N)>0) qui sum ``x'' if treatment==0 qui replace ``x''=``x''/r(sd) bysort Pair: center ``x'', casewise if `FU1'==1 { qui reg c_``x'' treatment_FU1 treatment_FU2 FU2 estimates store ``x'' local commmand_suest="`commmand_suest' ``x''" if `test_suest_FU1_n'==0 { local test_suest_FU1 "[``x''_mean]treatment_FU1" } else { local test_suest_FU1 "`test_suest_FU1'+[``x''_mean]treatment_FU1" } if `test_suest_FU2_n'==0 { local test_suest_FU2 "[``x''_mean]treatment_FU2" } else { local test_suest_FU2 "`test_suest_FU2'+[``x''_mean]treatment_FU2" } local ++FU1_numb local ++ test_suest_FU1_n local ++ test_suest_FU2_n } else { qui reg c_``x'' treatment_FU2 estimates store ``x'' local commmand_suest="`commmand_suest' ``x''" if `test_suest_FU2_n'==0 { local test_suest_FU2 "[``x''_mean]treatment_FU2" } else { local test_suest_FU2 "`test_suest_FU2'+[``x''_mean]treatment_FU2" } local ++ test_suest_FU2_n } } qui suest `commmand_suest', vce(cluster Cluster) if `FU1_numb'>0 { qui test `test_suest_FU1'=0 global FU1_p_``i''=r(p) if `test_suest_FU1'!=. { global FU1_b_``i''=(`test_suest_FU1')*(1/`arg') } else { global FU1_b_``i''=. } } qui test `test_suest_FU2'=0 global FU2_p_``i''=r(p) if `test_suest_FU2'!=. { global FU2_b_``i''=(`test_suest_FU2')*(1/`arg') } else { global FU2_b_``i''=. } drop c_* end global file_treatment="FU2_Indicators" global file_treatment_ci1="FU2_Indicators_ci1" global file_treatment_ci5="FU2_Indicators_ci5" global file_treatment_ci10="FU2_Indicators_ci10" global cond="" global opt="replace" xi i.Pair ***changing the signs replace F2_01x=F2_01x replace F2_034x_wins_ln=-F2_034x_wins_ln replace F2_05x=-F2_05x replace F2_05y=-F2_05y replace M1_05_6z_wins_ln=M1_05_6z_wins_ln replace F10_03z=F10_03z replace F1_08_12ryb=F1_08_12ryb replace F1_08_12ryg=F1_08_12ryg replace F15_04y=F15_04y replace F1_13rz=-F1_13rz replace F1_15rz=F1_15rz replace F14_03ay=F14_03ay replace F14_05z_wins_ln=F14_05z_wins_ln replace F14_06y=F14_06y replace F14_07z=F14_07z replace F14_08z=F14_08z replace F2_10x=F2_10x replace F2_10y=F2_10y replace G6_03z=G6_03z replace M6_08_s11z=M6_08_s11z replace G3_02z=-G3_02z replace M6_18_wins_ln=-M6_18_wins_ln replace M6_19_wins_ln=-M6_19_wins_ln replace M6_2_wins_ln=M6_2_wins_ln replace F13_01x=F13_01x replace M9_05z=M9_05z replace F13_02z=F13_02z replace M9_06z=M9_06z replace M7_93z_wins_ln=M7_93z_wins_ln replace M7_92z=M7_92z replace M7_91z=M7_91z replace M8_91z_wins_ln=M8_91z_wins_ln replace M8_92z=-M8_92z replace Assets_Household_pca=Assets_Household_pca replace Assets_Livestock_pca=Assets_Livestock_pca replace M9_03_wins_ln=-M9_03_wins_ln replace M9_99z=-M9_99z replace F8_03y_wins_ln=F8_03y_wins_ln replace F8_02=F8_02 replace F8_01z=F8_01z replace M6_09z_wins_ln=M6_09z_wins_ln replace M6_06_11z_wins_ln=M6_06_11z_wins_ln replace M6_10z=M6_10z replace M6_11z_wins_ln=M6_11z_wins_ln replace F6_05z=F6_05z replace F6_06_wins_ln=F6_06_wins_ln replace M6_15x=M6_15x replace M6_16_wins_ln=M6_16_wins_ln replace G2_04_5z_wins_ln=G2_04_5z_wins_ln replace F9_02_6z=F9_02_6z replace VL_cited=-VL_cited replace VL_Strong_cited =- VL_Strong_cited replace VL_Weak_cited=-VL_Weak_cited replace F3_02_3az=F3_02_3az replace M2_02_3az=M2_02_3az replace M3_06z=M3_06z replace F3_04y=F3_04y replace M2_04y=M2_04y replace M2_05y=M2_05y replace M2_06y=M2_06y replace F4_92b=F4_92b replace M3_95N=M3_95N replace M4_03_1N=-M4_03_1N replace M4_03_3_4N=-M4_03_3_4N replace M4_03_5N=-M4_03_5N replace M3_91z=M3_91z replace F3_04z=F3_04z replace M2_04z=M2_04z replace M2_05z=M2_05z replace M2_06z=M2_06z replace M3_92z_wins_ln=M3_92z_wins_ln replace F12_13z=F12_13z replace M10_02z=M10_02z replace F13_08x=F13_08x replace M10_01y=M10_01y replace F11_02x=F11_02x replace M11_08z=M11_08z replace M10_09y=M10_09y replace M10_10y=M10_10y replace M10_19z=M10_19z replace F11_01x=F11_01x replace M10_08z=M10_08z replace F11_03z=-F11_03z replace M10_06z=-M10_06z replace M6_14z=-M6_14z replace M10_11w=M10_11w replace M10_12w=M10_12w replace M10_14t=M10_14t replace M10_15w=M10_15w replace F12_01w=F12_01w replace M10_17t=M10_17t replace F11_08z=F11_08z replace M10_18z=M10_18z replace F3_06x=F3_06x replace M4_06z=M4_06z replace M11_17z=M11_17z replace M4_07z=M4_07z replace M12_07z=M12_07z replace F13_10=F13_10 replace M13_10z=M13_10z replace F13_03z=F13_03z replace M13_01z=M13_01z replace M13_09x=M13_09x replace M10_16x=M10_16x replace M11_14z=M11_14z replace M11_15z=M11_15z replace M11_16z=M11_16z replace M11_18z=M11_18z replace M11_19z=M11_19z replace G10_01z=G10_01z replace G10_02z=G10_02z replace G10_04z=G10_04z replace M11_04z=M11_04z replace M11_05z=M11_05z replace M11_03z=M11_03z replace M11_10z=M11_10z replace M11_11z=M11_11z replace M11_12z=M11_12z replace F11_09y=F11_09y replace M11_20y=M11_20y replace M11_01z=M11_01z replace M11_02z=M11_02z replace M11_09z=M11_09z replace M11_13z=M11_13z replace M13_11z=M13_11z replace G10_12a=-G10_12a replace M12_17a=-M12_17a replace M6_14x=-M6_14x replace F13_06x=F13_06x replace F13_07x=F13_07x replace M12_19z=M12_19z replace M12_20x=-M12_20x replace G10_06z=-G10_06z replace M12_14z=-M12_14z replace M12_09z=-M12_09z replace G10_06_8z=G10_06_8z replace F12_11z=F12_11z replace M12_05z=M12_05z replace F12_12z=F12_12z replace M12_06z=M12_06z replace M12_04y=M12_04y replace M6_99z=M6_99z replace F13_12y=F13_12y replace M13_13z=M13_13z replace F13_11y=F13_11y replace M13_12z=M13_12z replace F13_09x=F13_09x replace M13_07z=M13_07z replace F13_09z=-F13_09z replace M13_07y=-M13_07y replace M13_02z=M13_02z replace M4_07y=M4_07y replace F13_04z=F13_04z replace M13_03z=M13_03z replace F13_05x=F13_05x replace F12_07z=F12_07z replace M10_22z=M10_22z replace F12_08y=F12_08y replace M1_09z=M1_09z replace F2_11y=F2_11y replace F15_02y=F15_02y replace F15_01z=F15_01z replace F15_03z=F15_03z replace M10_23_4x=M10_23_4x replace F12_09z=F12_09z replace F12_10z=F12_10z replace F14_09y=F14_09y replace F3_06y=F3_06y replace M4_06y=M4_06y replace F12_05z=F12_05z replace M10_20x=M10_20x replace F12_06z=F12_06z replace M10_21y=M10_21y replace F10_01z=F10_01z replace M12_01z=M12_01z replace F12_03z=F12_03z replace M12_13z=M12_13z replace F12_02z=F12_02z replace M12_02z=M12_02z replace F12_04z=F12_04z replace M12_03z=M12_03z replace F10_07z=F10_07z replace F10_16z=F10_16z replace F10_09_10z=F10_09_10z replace F10_11_12z=F10_11_12z replace F10_13_wins_ln=F10_13_wins_ln replace F10_14y=F10_14y replace F10_15z=F10_15z replace F10_17z=F10_17z replace F10_18z=F10_18z replace W5_10z=W5_10z replace W5_11z=W5_11z replace F6_01z=F6_01z replace F6_04z=F6_04z replace F6_09_16y=F6_09_16y replace F6_10_18y=F6_10_18y replace F7_01_8w=F7_01_8w replace F7_01_8x=F7_01_8x ******** produce_results_mean F2_01x F2_034x_wins_ln F2_05x F2_05y M1_05_6z_wins_ln 1 produce_results_mean F10_03z F1_08_12ryb F1_08_12ryg F15_04y F1_13rz F1_15rz F14_03ay F14_05z_wins_ln F14_06y F14_07z F14_08z F2_10x F2_10y 2 produce_results_mean G6_03z M6_08_s11z G3_02z M6_18_wins_ln M6_19_wins_ln M6_2_wins_ln 3 produce_results_mean F13_01x M9_05z F13_02z M9_06z 5 produce_results_mean M7_93z_wins_ln M7_92z M7_91z M8_91z_wins_ln M8_92z Assets_Household_pca Assets_Livestock_pca M9_03_wins_ln M9_99z F8_03y_wins_ln F8_02 F8_01z 6 produce_results_mean M6_09z_wins_ln M6_06_11z_wins_ln M6_10z M6_11z_wins_ln F6_05z F6_06_wins_ln M6_15x M6_16_wins_ln 7 produce_results_mean G2_04_5z_wins_ln F9_02_6z 8 produce_results_mean VL_cited VL_Strong_cited VL_Weak_cited F3_02_3az M2_02_3az M3_06z 9 produce_results_mean F3_04y M2_04y M2_05y M2_06y F4_92b M3_95N M4_03_1N M4_03_3_4N M4_03_5N M3_91z F3_04z M2_04z M2_05z M2_06z 10 produce_results_mean M3_92z_wins_ln F12_13z M10_02z F13_08x M10_01y F11_02x M11_08z M10_09y M10_10y M10_19z F11_01x M10_08z F11_03z M10_06z M6_14z M10_11w M10_12w M10_14t M10_15w F12_01w M10_17t 11 produce_results_mean F11_08z M10_18z F3_06x M4_06z M11_17z M4_07z M12_07z F13_10 M13_10z F13_03z M13_01z 12 produce_results_mean M13_09x M10_16x M11_14z M11_15z M11_16z M11_18z M11_19z G10_01z G10_02z G10_04z 13 produce_results_mean M11_04z M11_05z M11_03z M11_10z M11_11z M11_12z F11_09y M11_20y M11_01z M11_02z M11_09z M11_13z M13_11z 14 produce_results_mean G10_12a M12_17a M6_14x F13_06x F13_07x M12_19z M12_20x 15 produce_results_mean G10_06z M12_14z M12_09z G10_06_8z F12_11z M12_05z F12_12z M12_06z M12_04y M6_99z 16 produce_results_mean F13_12y M13_13z F13_11y M13_12z 17 produce_results_mean F13_09x M13_07z F13_09z M13_07y 18 produce_results_mean M13_02z M4_07y F13_04z M13_03z F13_05x F12_07z M10_22z F12_08y M1_09z F2_11y F15_02y F15_01z F15_03z M10_23_4x F12_09z F12_10z F14_09y F3_06y M4_06y F12_05z M10_20x F12_06z 19 produce_results_mean M10_21y F10_01z M12_01z F12_03z M12_13z F12_02z M12_02z F12_04z M12_03z F10_07z F10_16z F10_09_10z F10_11_12z F10_13_wins_ln F10_14y F10_15z F10_17z F10_18z W5_10z W5_11z F6_01z F6_04z F6_09_16y F6_10_18y F7_01_8w F7_01_8x 20 forvalues x=1/20{ n: di "Hypothesis # " `x' " Average coeff. FU1 " %9.3f ${FU1_b_`x'} " p-value" %9.3f ${FU1_p_`x'} n: di "Hypothesis # " `x' " Average coeff. FU2 " %9.3f ${FU2_b_`x'} " p-value" %9.3f ${FU2_p_`x'} }