
 cd C:\Users\mjaremski\Desktop\LiquidityRequirements-Replication\

 import delimited "LiquidityRequirements.csv", clear
  
 **********Summary Statistics for 1906 - Table 2
 preserve

 keep if yr==1906
 keep if banks>3 & banks<20
 keep if nbspeciehold>.04
  
 local list reserves lassets capas surcap dtdep nbshareassets nbspeciehold easyno pop black urban reservecity mfirms lbanks ch 

 foreach x of local list {
	gen `x'sd=`x'
	gen `x'min=`x'
	gen `x'max=`x'
	}

  collapse (mean) reserves lassets capas surcap dtdep nbshareassets nbspeciehold easyno pop black urban reservecity mfirms lbanks ch (sd) reservessd lassetssd capassd surcapsd dtdepsd nbshareassetssd nbspecieholdsd easynosd popsd blacksd urbansd reservecitysd mfirmssd lbankssd chsd (min) reservesmin lassetsmin capasmin surcapmin dtdepmin nbshareassetsmin nbspecieholdmin easynomin popmin blackmin urbanmin reservecitymin mfirmsmin lbanksmin chmin (max) reservesmax lassetsmax capasmax surcapmax dtdepmax nbshareassetsmax nbspecieholdmax easynomax popmax blackmax urbanmax reservecitymax mfirmsmax lbanksmax chmax
  
  export delimited using "Table2.csv", replace
  restore 
  
 
 ********Reserves Panel Regressions - Tables 3 & 4
  xi: reg reserves lassets capas surcap dtdep nbshareassets nbspeciehold nbholdint easyno nbspeciehold_en nbshareassets_en nbs_en i.yr if nbspeciehold>.04 & banks>3 & banks<20, robust
estimates store x1

  xi: reg reserves lassets capas surcap dtdep nbshareassets nbspeciehold nbholdint easyno nbspeciehold_en nbshareassets_en nbs_en pop black urban reservecity mfirms lbanks ch i.yr if nbspeciehold>.04 & banks>3 & banks<20, robust
estimates store x2

  xi: reg reserves lassets capas surcap dtdep nbshareassets nbspeciehold nbholdint easyno nbspeciehold_en nbshareassets_en i.yr*nbs_en i.yr if nbspeciehold>.04 & banks>3 & banks<20, robust
estimates store x3

  xi: reg reserves lassets capas surcap dtdep nbshareassets nbspeciehold nbholdint easyno nbspeciehold_en nbshareassets_en i.yr*nbs_en pop black urban reservecity mfirms lbanks  ch i.yr if nbspeciehold>.04 & banks>3 & banks<20, robust
estimates store x4

 esttab x1 x2 x3 x4 using "Tables3&4.csv", b(3) se(3) replace margin r2 starlevels(* 0.10 ** 0.05 *** 0.01) brackets label title("Table 2&3") wrap order(lassets capas surcap dtdep nbshareassets nbspeciehold easyno nbholdint nbshareassets_en nbspeciehold_en nbs_en pop black urban reservecity mfirms lbanks ch)
  
 
 **********Robustness Table A1
 
 xi: reg reserves lassets capas surcap dtdep nbshareassets nbspeciehold nbholdint easyno nbspeciehold_en nbshareassets_en nbs_en i.yr if nbspeciehold>.04 & banks>3 & banks<20, robust
estimates store t1

  xi: reg reserves lassets capas surcap dtdep nbshareassets nbspeciehold nbholdint easyno nbspeciehold_en nbshareassets_en nbs_en pop reservecity lbanks i.yr if nbspeciehold>.04 & banks>3 & banks<20, robust
estimates store t2

  xi: reg reserves lassets capas surcap dtdep nbshareassets nbspeciehold nbholdint easyno nbspeciehold_en nbshareassets_en nbs_en black urban mfirms ch i.yr if nbspeciehold>.04 & banks>3 & banks<20, robust
estimates store t3

  xi: reg reserves lassets capas surcap dtdep nbshareassets nbspeciehold nbholdint easyno nbspeciehold_en nbshareassets_en nbs_en pop black urban reservecity mfirms lbanks ch i.yr if nbspeciehold>.04 & banks>3 & banks<20, robust
estimates store t4

 esttab t1 t2 t3 t4 using "TableA1.csv", b(3) se(3) replace margin r2 starlevels(* 0.10 ** 0.05 *** 0.01) brackets label title("Table A1") wrap order(lassets capas surcap dtdep nbshareassets nbspeciehold easyno nbholdint nbshareassets_en nbspeciehold_en nbs_en pop black urban reservecity mfirms lbanks ch)
 
 
**********Robustness Table A2
  correlate nbholdint pop black urban reservecity mfirms lbanks ch if nbspeciehold>.04 & banks>3 & banks<20
  
   
 **********Robustness Table A3

  forvalues i=10(2)36 {
	xi: reg reserves lassets capas surcap dtdep nbshareassets nbspeciehold nbholdint easyno nbspeciehold_en nbshareassets_en nbs_en pop black urban reservecity mfirms lbanks ch i.yr if nbspeciehold>.04 & banks>2 & banks<`i', robust
estimates store a`i'

	xi: reg reserves lassets capas surcap dtdep nbshareassets nbspeciehold nbholdint easyno nbspeciehold_en nbshareassets_en nbs_en pop black urban reservecity mfirms lbanks ch i.yr if nbspeciehold>.04 & banks>3 & banks<`i', robust
estimates store b`i'

	xi: reg reserves lassets capas surcap dtdep nbshareassets nbspeciehold nbholdint easyno nbspeciehold_en nbshareassets_en nbs_en pop black urban reservecity mfirms lbanks ch i.yr if nbspeciehold>.04 & banks>4 & banks<`i', robust
estimates store c`i'
	}

esttab a* b* c* using "TableA3.csv", b(3) se(3) replace margin r2 starlevels(* 0.10 ** 0.05 *** 0.01) brackets label title("Table A2") wrap order(lassets capas surcap dtdep nbshareassets nbspeciehold easyno nbholdint nbshareassets_en nbspeciehold_en nbs_en pop urban reservecity mfirms lbanks ch)
   
 

  
****************Closure Regressions - Table 5
 keep if yr==1906 | yr==1908
  
 drop if nytrust==1
 
 egen gp=group(state bank location)
 bysort gp: gen obs=_N
 
 keep if yr==1906
 
 gen closed=0
 replace closed=1 if obs==1
  
logistic closed reserves lassets capas surcap dtdep pop black urban reservecity mfirms lbanks ch easyno if nbspeciehold>.04 & banks>3 & banks<20
  mfx, dydx  
  estimates store r4

logistic closed reserves lassets capas surcap dtdep pop black urban reservecity mfirms lbanks ch easyno if nbanks>0
  mfx, dydx
  estimates store r3
      
logistic closed reserves lassets capas surcap dtdep pop black urban reservecity mfirms lbanks ch easyno if banks>1
  mfx, dydx
  estimates store r2
  
logistic closed reserves lassets capas surcap dtdep pop black urban reservecity mfirms lbanks ch easyno
  mfx, dydx
  estimates store r1
    
 esttab r1 r2 r3 r4 using "Table5.csv", b(3) se(3) replace margin pr2 starlevels(* 0.10 ** 0.05 *** 0.01) brackets label title("Table 5") wrap order(reserves lassets capas surcap dtdep pop black urban reservecity mfirms lbanks easyno ch)


 


 
