* This do file creates the summary statistics in Table 4.
clear
use Stability_JDE_data

* Risk and time
sum apuesta if survey0709!=0
sum dado if survey0709!=0
sum risk1_07  if survey0709!=0 
sum risk1_09 
sum time_07  if survey0709!=0 
sum time_09 

*Social preference - amount sent in 02 07 09
*02: in trust game as trustor (amount sent)
sum condorma if survey0709!=0
*07: distator game as dictator
sum sent_anon_07  if game0709!=0 | hhid91==9083 | hhid91==9508 
sum sent_elegidoyno_07 if game0709!=0 | hhid91==9083 | hhid91==9508
sum sent_reve_07 if game0709!=0 | hhid91==9083 | hhid91==9508
sum sent_elegidoysi_07 if game0709!=0 | hhid91==9083 | hhid91==9508
*09: sent as dictator
sum c56a_09 
sum sent_elegidoyno_09 
sum c56b_09 
sum sent_elegidoysi_09 

*trustworthiness: share in 2002
sum share if survey0709!=0
*amount received as trustee in 2002
sum condorec if survey0709!=0
*proportion amount recieved back as trustor in 2002
sum condorre_por if survey0709!=0

**Trust questions and other survey questions
*trust people in this world
sum c26a  if survey0709!=0
sum c100a_07  if survey0709!=0 
sum  c53a_09 

*trust people in this village
sum c26b if survey0709!=0
sum c100b_07 if survey0709!=0 
sum c53b_09 
sum  c15a_10 if survey0709!=0

*trust closest neighbors 
sum c26d if survey0709!=0
sum c100c_07 if survey0709!=0 
sum  c53c_09 

*villagemate take advantage
sum c26j if survey0709!=0
sum c100m_07 if survey0709!=0 
sum c53k_09 

*bad to buy something you know is stolen 
sum c26m_bin if survey0709!=0
sum c100j_bin if survey0709!=0 
sum c53h_bin 

*revenge
sum c100q_bin if survey0709!=0 
sum c53o_bin 
sum c11b_bin if survey0709!=0

*10
sum posrecip_ju1_10 if survey0709!=0
sum negrecip_ju1_10 if survey0709!=0