Skip to content

brycewang-stanford/Auto-Empirical-Research-Skills / skills/18-jusi-aalto-stata-accounting-research

stata-accounting-research

Unverified

STATA code pattern library for empirical archival accounting research. Provides tested syntax from 126 peer-reviewed JAR (Journal of Accounting Research) replication files (2017-2025). Use when the user asks procedural questions like "How do I implement [method]?" or "Show me code for [technique]" — including: entropy balancing, propensity score matching (PSM), difference-in-differences (DiD), regression discontinuity (RDD), instrumental variables (IV), event studies (CAR/BHAR), survival analysis, Fama-MacBeth regressions, bootstrap, quantile regression, reghdfe/xtreg/areg, clustering standard errors, fixed effects, esttab/outreg2 table formatting, winsorization, leads/lags. Users can specify their variables (e.g., treatment, outcomes, controls) and receive adapted syntax. NOTE: This skill provides code patterns from published papers, not research design advice.

FileKindSize
README-original.mdmarkdown2.9 KB
SKILL.mdskill md4.8 KB
references/JAR_55_bbcl.doother59.1 KB
references/JAR_55_chaplinksy-hanley-moon.doother46.3 KB
references/JAR_55_clm.doother95.1 KB
references/JAR_55_elw.doother58.0 KB
references/JAR_55_hlsw.doother104.1 KB
references/JAR_55_kks.doother365.5 KB
references/JAR_55_lzz.doother25.5 KB
references/JAR_55_madsen.doother307.5 KB
references/JAR_55_mr.doother41.5 KB
references/JAR_56_al.doother75.3 KB
references/JAR_56_bch.doother13.5 KB
references/JAR_56_blv.doother24.6 KB
references/JAR_56_csmw.doother27.6 KB
references/JAR_56_en.doother21.2 KB
references/JAR_56_granja.doother107.9 KB
references/JAR_56_htw.doother18.6 KB
references/JAR_56_kmt.doother5.6 KB
references/JAR_56_ksvw.doother8.0 KB
references/JAR_56_llz.doother3.1 KB
references/JAR_56_ls.doother147.5 KB
references/JAR_56_lv2018.doother123.7 KB
references/JAR_57_bht.doother24.4 KB
references/JAR_57_bl.doother22.6 KB
references/JAR_57_bw.doother263.2 KB
references/JAR_57_cct.doother347.1 KB
references/JAR_57_cgw.doother195.8 KB
references/JAR_57_hcp.doother38.0 KB
references/JAR_57_honigsberg.doother99.5 KB
references/JAR_57_lehmann.doother112.8 KB
references/JAR_57_lm.doother85.5 KB
references/JAR_58_bsz.doother36.9 KB
references/JAR_58_ckm.doother52.3 KB
references/JAR_58_eyring.doother58.1 KB
references/JAR_58_gj.doother187.5 KB
references/JAR_58_gsz.doother121.6 KB
references/JAR_58_htyz.doother30.9 KB
references/JAR_58_jansen.doother99.5 KB
references/JAR_58_joshi.doother43.0 KB
references/JAR_58_kvy.doother19.5 KB
references/JAR_58_msz.doother35.0 KB
references/JAR_58_rauter.doother433.2 KB
references/JAR_58_wy.doother64.5 KB
references/JAR_58_zz.doother125.5 KB
references/JAR_59_breuer.doother826.9 KB
references/JAR_59_ctv.doother383.7 KB
references/JAR_59_dess.doother78.4 KB
references/JAR_59_hmo.doother351.6 KB
references/JAR_60_abkp.doother129.9 KB
references/JAR_60_alv.doother35.4 KB
references/JAR_60_at.doother38.5 KB
references/JAR_60_barrios.doother119.6 KB
references/JAR_60_bbin.doother72.9 KB
references/JAR_60_bdem.doother11.6 KB
references/JAR_60_bl.doother43.5 KB
references/JAR_60_bmsw.doother7.7 KB
references/JAR_60_cc.doother20.1 KB
references/JAR_60_cpss.doother15.4 KB
references/JAR_60_cstv.doother175.3 KB
references/JAR_60_dg.doother19.9 KB
references/JAR_60_duguay.doother8.0 KB
references/JAR_60_fhl.doother71.3 KB
references/JAR_60_gls.doother37.0 KB
references/JAR_60_hmryz.doother28.6 KB
references/JAR_60_hst.doother18.3 KB
references/JAR_60_kt.doother10.4 KB
references/JAR_60_mliu.doother28.3 KB
references/JAR_60_nrwx.doother14.6 KB
references/JAR_60_ptwy.doother26.6 KB
references/JAR_60_skim.doother14.7 KB
references/JAR_61_bcdr.doother524.9 KB
references/JAR_61_bkr.doother51.6 KB
references/JAR_61_bls.doother79.2 KB
references/JAR_61_bo.doother29.7 KB
references/JAR_61_ccm.doother48.7 KB
references/JAR_61_cdss.doother3.9 KB
references/JAR_61_cfhll.doother47.1 KB
references/JAR_61_cfmp.doother12.7 KB
references/JAR_61_ckor.doother77.5 KB
references/JAR_61_cllw.doother11.2 KB
references/JAR_61_clm.doother11.0 KB
references/JAR_61_deller.doother368.9 KB
references/JAR_61_dlrtw.doother30.6 KB
references/JAR_61_dlz.doother13.6 KB
references/JAR_61_drs.doother15.8 KB
references/JAR_61_ds.doother197.5 KB
references/JAR_61_glt.doother1.9 KB
references/JAR_61_gyz.doother7.5 KB
references/JAR_61_ll.doother89.3 KB
references/JAR_61_lszz.doother15.9 KB
references/JAR_61_os.doother128.9 KB
references/JAR_61_zureich.doother22.2 KB
references/JAR_62_1_bdsy_banerjee_etal.doother6.6 KB
references/JAR_62_1_bhs_bouwens_etal.doother59.7 KB
references/JAR_62_1_gsz_gu_sun_zhou.doother46.6 KB
references/JAR_62_2_dgzz_defranco_etal.doother1.8 KB
references/JAR_62_2_gmp_grewal_etal.doother37.2 KB
references/JAR_62_2_xyz_xin_etal.doother25.3 KB
references/JAR_62_3_bht_bloomfield_etal.doother16.0 KB
references/JAR_62_3_ccz_cheynel_etal.doother23.3 KB
references/JAR_62_3_kim.doother2.6 KB
references/JAR_62_3_rr_raghunandan_ruchti.doother15.5 KB
references/JAR_62_4_bd_breuer_dehaan.doother15.3 KB
references/JAR_62_4_cc_cadman_carrizosa.doother20.1 KB
references/JAR_62_4_kmsv_kohler_etal.doother91.5 KB
references/JAR_62_4_mps_marra_etal.doother68.0 KB
references/JAR_62_4_raghunandan.doother50.0 KB
references/JAR_62_4_stv_sran_etal.doother41.1 KB
references/JAR_62_4_xu.doother49.4 KB
references/JAR_62_5_aov_abraham_etal.doother418.9 KB
references/JAR_62_5_gibbons.doother80.1 KB
references/JAR_62_5_jiang.doother114.3 KB
references/JAR_62_5_kstz_krueger_etal.doother26.7 KB
references/JAR_62_5_llz_li_lou_zhang.doother6.2 KB
references/JAR_62_5_lrst_lins_etal.doother66.2 KB
references/JAR_62_5_lswy_lin_etal.doother85.2 KB
references/JAR_62_5_lw_li_wang.doother16.6 KB
references/JAR_63_1_blmv_bastiaansen_etal.doother18.5 KB
references/JAR_63_1_cvw_chen_etal.doother61.2 KB
references/JAR_63_1_fgr_frankel_etal.doother30.3 KB
references/JAR_63_1_hrsx_huang_etal.doother35.5 KB
references/JAR_63_1_jia.doother12.0 KB
references/JAR_63_2_bcrw_bakke_etal.doother271.3 KB
references/JAR_63_2_dlr_desimone_etal.doother83.5 KB
references/JAR_63_2_mqtz_mao_etal.doother94.2 KB
references/JAR_63_2_npstv_nessa_etal.doother7.0 KB
references/JAR_63_3_breuer.doother51.4 KB
references/REFERENCES.mdmarkdown30.7 KB

references/JAR_57_bht.do

View on GitHub
clear
clear mata
clear matrix
set mem 25000m
set more off 
set maxvar 30000
set matsize 11000
 
cd "D:\TP"
use final  

encode ticker, gen(f)
encode headqctry, gen (headqctry1)
egen firm_year = group(ticker year)
gen y=string(year)
replace nanalyst = log(nanalyst)
replace brsize = log(brsize)
replace nticker = log(nticker)
replace gdpp = gdpp/10000
gen y=string(year)
gen ctrypairyr=headqctry+analyst_loc+y
replace headqctry=headqctry+y
gen analyst_locyr=analyst_loc+y
encode ctrypair, gen(pair)
opt_accu6 = 1 - ratio6
opt_accu3 = 1 - ratio3

* Merge WGI data
sort analyst_loc year
merge m:1 analyst_loc year using wgi_rank.dta, update replace
drop _merge 

merge m:1 analyst_loc year using pc.dta, update replace		/***** Principal components ****/
drop _merge 

sort headqctry year
merge m:1 headqctry year using wgi_headqctry.dta, update replace
drop _merge 

merge m:1 headqctry year using headqctry_traits.dta, update replace
drop _merge 

merge m:1 headqctry year using pc_firm.dta, update replace
drop _merge 

local controlFirm logmv mb revt_growth intangible nanalyst turnoverpre12 retstd12		
local controlAnalyst deltatp2tp return_rev optimism_eps firmex genex nticker brsize acwi12
local dep tp2p tp2p_rank2 opt_accu6 delta6radj 
local ctrytrait legalenf ex_ante_dealing 
local control gdpp commonlaw `controlFirm' `controlAnalyst' i.year 

gen idctry=analyst_loc
sort idctry year

merge m:1 idctry using govern.dta, update replace

drop _merge 
sort headqctry year
merge m:1 headqctry year using PCREV_firm.dta, update replace
drop _merge
 
sort ticker amaskcd anndats 
merge m:1 ticker amaskcd anndats using prc_revdate.dta, update replace 
drop _merge 

save JAR2.dta, replace


*Target Price Optimism and Analyst-Country Traits
clear
clear mata
clear matrix
set mem 25000m
set more off 
set maxvar 30000
set matsize 11000

cd "D:\TP"
use JAR2, clear
*use jarrev, clear

sort ticker
by ticker: keep if _n==1		/**I/B/E/S ticker in the final sample: 17,353 ticker**/
drop if ticker==""
*keep ticker 
*save SampleTicker, replace

sort analyst_loc year
merge m:1 analyst_loc year using PCREV.dta, update replace
drop _merge 

merge m:1 analyst_loc using Jacksonroe.dta, update replace /*****JacksonRoeJFE09 - Public and Private Enforcement of Securities Laws Resource-Based Evidence*********/
drop _merge 

merge m:1 analyst_loc using secreg.dta, update replace /*****LLS (JFE2006): What Works in Securities Laws.xls*********/
drop _merge 
gen staff1=staff/100

local controlFirm logmv mb revt_growth intangible nanalyst turnoverpre12 retstd12		
local controlAnalyst deltatp2tp return_rev optimism_eps firmex genex nticker brsize acwi12
local dep tp2p tp2p_rank2 opt_accu6 delta6radj 
local ctrytrait ctryinfrp1 legsys judicial ruleoflaw corruption 
local control gdpp commonlaw `controlFirm' `controlAnalyst' i.year 

*** Firm fixed effects
xtset f 
***Benchmark reg****
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3'  `control', fe vce(cluster headqctry)		
	}
		
*	Main Tables 5
	foreach trait in `ctrytrait'        {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control', fe vce(cluster headqctry)
		}
	}
	
*	Covered by both local and Foreign analysts;	
	foreach trait in  `ctrytrait' {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control' if localfgn == 2, fe vce(cluster headqctry)
		}
	}
	
*	analyst_loc_freq >=2	
	foreach trait in `ctrytrait'       {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control' if analyst_loc_freq >=2, fe vce(cluster headqctry)
		}
	}
	
*	Non US firms;	
	foreach trait in  `ctrytrait' {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control' if headqctry != "NA", fe vce(cluster headqctry)
		}
	}
	
	esttab using "C:\Users\hptan\Dropbox\JARcheck1.csv", b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Fixed effect)

	
	*	Foreign analysts;	
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' ctryinfrp1rev ctryinfrp1rev_firm ctryinfrp2rev ctryinfrp2rev_firm 	`control' if local == 0, fe vce(cluster headqctry)
	}
	
*	Full sample: Both analyst counctry and firm country traits	
	foreach trait in  `ctrytrait' {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `trait'_f	`control', 			fe vce(cluster headqctry)
		}
	}	
	
*	Foreign analysts: Both analyst counctry and firm country traits	
	foreach trait in  `ctrytrait' {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `trait'_f	`control' if local == 0, fe vce(cluster headqctry)
		}
	}
	esttab using "C:\Users\hptan\Dropbox\JARcheck1.csv", b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Fixed effect)

	
*	What Works in Securities Laws.xls LA PORTA
*	Robustness: Resource-based enforcement of securities laws   JacksonRoeJFE09 - Public and Private Enforcement of Securities Laws Resource-Based Evidence
	foreach depvar3 in  `dep' {	
		foreach trait in  judimp ex_ante_dealing legalenf pub_enfdjankov staff1 publ_enf  {	
		eststo: xi: xtreg `depvar3' `trait' `control', fe vce(cluster headqctry)
		}
	}
	
*	Control for both firm and analsyt fixed effects
	foreach depvar3 in `dep'  {	
	foreach trait in  `ctrytrait' {
		eststo: xi: reghdfe `depvar3' `trait' `control' i.year, 	absorb(f amaskcd)  cluster(headqctry)
		}
	}
	
	esttab using "C:\Users\hptan\Dropbox\OtherCtryTraits1.csv", b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Fixed effect)


xtset f 
****Table Country pair-firm-year level	
	collapse `dep' `ctrytrait' gdpp commonlaw `controlFirm' `controlAnalyst', by(f year headqctry analyst_loc )
	
	foreach trait in `ctrytrait'       {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control', fe vce(cluster headqctry)
		}
	}

esttab using "C:\Users\hptan\Dropbox\JARcheck1.csv", b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Fixed effect)
	

	
**Return predicative power
clear
clear matrix
set mem 25000m
set more off 
cd "D:\TP"
*cd "K:\TP_Alan 2016\P"

*use Jar2
use Jarr1
sum return3 return5 return30 return92 return182	

local traits2 firmex firmex_dum purebroker leadunderwriter research local purelocal expalocal civillaw judicial rule corruption priv_enf publ_enf ///
	it_enf investor_pr expropriat accntstd cifar earnmgmt concent r2 gdpp developed idv media ///
	antidir_new	ex_ante_dealing	anti_dealing disclose ushold usholdgdp ///
	mb def investments cwc internalcf  ///
	bribes comp_fbank enforcement foregnownership integrity judimp judindp legsys privatecredit propprot ///
	def_dum financing_brs_dum earnmgmt_firm earnmgmt_firm1
	
local controlFirm logmv mb revt_growth intangible nanalyst turnoverpre12 retstd12 	
local controlAnalyst return_rev optimism_eps firmex genex nticker brsize acwi12
local ret return3 return5 return30 return92 return182	 		

keep analyst_loc headqctry ctryinfrp1_firm ctryinfrp2_firm ctryinfrp1 ctryinfrp2 headqctry return30 deltatp2tp tpret_sic tpretadj_sic tp2p `ret'  `controlFirm' `controlAnalyst' `traits2'  secabb year mth ticker `pcs'

encode ticker, gen(f)
gen commonlaw = 1 - civillaw
replace nanalyst = log(nanalyst)
replace brsize = log(brsize)
replace nticker = log(nticker)
replace gdpp = gdpp/10000

drop ctryinfrp1 ctryinfrp2 

* Merge WGI data
sort analyst_loc year
merge m:1 analyst_loc year using wgi_rank.dta, update replace
drop _merge 

merge m:1 analyst_loc year using pc.dta, update replace		/***** Principal components ****/
drop _merge 

gen inter_ctry=ctryinfrp1*tp2p	
	
gen y=string(year)
replace headqctry=headqctry+y
gen ctrypair=headqctry + analyst_loc

sum `ret' tp2p tpret_sic deltatp2tp

foreach dep in `ret'  {	
	replace `dep'=`dep'*100
}
	
xtset f 
local ret return3 return30  	
local controlFirm logmv mb revt_growth intangible nanalyst turnoverpre12 retstd12 	
local controlAnalyst  return_rev optimism_eps firmex genex nticker brsize acwi12

foreach dep in `ret'  {	
	foreach traits in tp2p tpret_sic deltatp2tp  {	
	foreach ctrytrait in ctryinfrp1 legsys corruption judicial ruleoflaw       {	
		replace inter_ctry=`ctrytrait'*`traits'	
		eststo:	xi: xtreg `dep' `traits'  inter_ctry `ctrytrait' 		`controlFirm' `controlAnalyst' i.year i.mth, fe vce(cluster headqctry)
		}
	}
}

esttab using MarketRetrev1.csv, b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Markettest)
clear
clear mata
clear matrix
set mem 25000m
set more off 
set maxvar 30000
set matsize 11000
 
cd "D:\TP"
use final  

encode ticker, gen(f)
encode headqctry, gen (headqctry1)
egen firm_year = group(ticker year)
gen y=string(year)
replace nanalyst = log(nanalyst)
replace brsize = log(brsize)
replace nticker = log(nticker)
replace gdpp = gdpp/10000
gen y=string(year)
gen ctrypairyr=headqctry+analyst_loc+y
replace headqctry=headqctry+y
gen analyst_locyr=analyst_loc+y
encode ctrypair, gen(pair)
opt_accu6 = 1 - ratio6
opt_accu3 = 1 - ratio3

* Merge WGI data
sort analyst_loc year
merge m:1 analyst_loc year using wgi_rank.dta, update replace
drop _merge 

merge m:1 analyst_loc year using pc.dta, update replace		/***** Principal components ****/
drop _merge 

sort headqctry year
merge m:1 headqctry year using wgi_headqctry.dta, update replace
drop _merge 

merge m:1 headqctry year using headqctry_traits.dta, update replace
drop _merge 

merge m:1 headqctry year using pc_firm.dta, update replace
drop _merge 

local controlFirm logmv mb revt_growth intangible nanalyst turnoverpre12 retstd12		
local controlAnalyst deltatp2tp return_rev optimism_eps firmex genex nticker brsize acwi12
local dep tp2p tp2p_rank2 opt_accu6 delta6radj 
local ctrytrait legalenf ex_ante_dealing 
local control gdpp commonlaw `controlFirm' `controlAnalyst' i.year 

gen idctry=analyst_loc
sort idctry year

merge m:1 idctry using govern.dta, update replace

drop _merge 
sort headqctry year
merge m:1 headqctry year using PCREV_firm.dta, update replace
drop _merge
 
sort ticker amaskcd anndats 
merge m:1 ticker amaskcd anndats using prc_revdate.dta, update replace 
drop _merge 

save JAR2.dta, replace


*Target Price Optimism and Analyst-Country Traits
clear
clear mata
clear matrix
set mem 25000m
set more off 
set maxvar 30000
set matsize 11000

cd "D:\TP"
use JAR2, clear
*use jarrev, clear

sort ticker
by ticker: keep if _n==1		/**I/B/E/S ticker in the final sample: 17,353 ticker**/
drop if ticker==""
*keep ticker 
*save SampleTicker, replace

sort analyst_loc year
merge m:1 analyst_loc year using PCREV.dta, update replace
drop _merge 

merge m:1 analyst_loc using Jacksonroe.dta, update replace /*****JacksonRoeJFE09 - Public and Private Enforcement of Securities Laws Resource-Based Evidence*********/
drop _merge 

merge m:1 analyst_loc using secreg.dta, update replace /*****LLS (JFE2006): What Works in Securities Laws.xls*********/
drop _merge 
gen staff1=staff/100

local controlFirm logmv mb revt_growth intangible nanalyst turnoverpre12 retstd12		
local controlAnalyst deltatp2tp return_rev optimism_eps firmex genex nticker brsize acwi12
local dep tp2p tp2p_rank2 opt_accu6 delta6radj 
local ctrytrait ctryinfrp1 legsys judicial ruleoflaw corruption 
local control gdpp commonlaw `controlFirm' `controlAnalyst' i.year 

*** Firm fixed effects
xtset f 
***Benchmark reg****
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3'  `control', fe vce(cluster headqctry)		
	}
		
*	Main Tables 5
	foreach trait in `ctrytrait'        {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control', fe vce(cluster headqctry)
		}
	}
	
*	Covered by both local and Foreign analysts;	
	foreach trait in  `ctrytrait' {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control' if localfgn == 2, fe vce(cluster headqctry)
		}
	}
	
*	analyst_loc_freq >=2	
	foreach trait in `ctrytrait'       {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control' if analyst_loc_freq >=2, fe vce(cluster headqctry)
		}
	}
	
*	Non US firms;	
	foreach trait in  `ctrytrait' {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control' if headqctry != "NA", fe vce(cluster headqctry)
		}
	}
	
	esttab using "C:\Users\hptan\Dropbox\JARcheck1.csv", b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Fixed effect)

	
	*	Foreign analysts;	
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' ctryinfrp1rev ctryinfrp1rev_firm ctryinfrp2rev ctryinfrp2rev_firm 	`control' if local == 0, fe vce(cluster headqctry)
	}
	
*	Full sample: Both analyst counctry and firm country traits	
	foreach trait in  `ctrytrait' {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `trait'_f	`control', 			fe vce(cluster headqctry)
		}
	}	
	
*	Foreign analysts: Both analyst counctry and firm country traits	
	foreach trait in  `ctrytrait' {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `trait'_f	`control' if local == 0, fe vce(cluster headqctry)
		}
	}
	esttab using "C:\Users\hptan\Dropbox\JARcheck1.csv", b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Fixed effect)

	
*	What Works in Securities Laws.xls LA PORTA
*	Robustness: Resource-based enforcement of securities laws   JacksonRoeJFE09 - Public and Private Enforcement of Securities Laws Resource-Based Evidence
	foreach depvar3 in  `dep' {	
		foreach trait in  judimp ex_ante_dealing legalenf pub_enfdjankov staff1 publ_enf  {	
		eststo: xi: xtreg `depvar3' `trait' `control', fe vce(cluster headqctry)
		}
	}
	
*	Control for both firm and analsyt fixed effects
	foreach depvar3 in `dep'  {	
	foreach trait in  `ctrytrait' {
		eststo: xi: reghdfe `depvar3' `trait' `control' i.year, 	absorb(f amaskcd)  cluster(headqctry)
		}
	}
	
	esttab using "C:\Users\hptan\Dropbox\OtherCtryTraits1.csv", b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Fixed effect)


xtset f 
****Table Country pair-firm-year level	
	collapse `dep' `ctrytrait' gdpp commonlaw `controlFirm' `controlAnalyst', by(f year headqctry analyst_loc )
	
	foreach trait in `ctrytrait'       {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control', fe vce(cluster headqctry)
		}
	}

esttab using "C:\Users\hptan\Dropbox\JARcheck1.csv", b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Fixed effect)
	

	
**Return predicative power
clear
clear matrix
set mem 25000m
set more off 
cd "D:\TP"
*cd "K:\TP_Alan 2016\P"

*use Jar2
use Jarr1
sum return3 return5 return30 return92 return182	

local traits2 firmex firmex_dum purebroker leadunderwriter research local purelocal expalocal civillaw judicial rule corruption priv_enf publ_enf ///
	it_enf investor_pr expropriat accntstd cifar earnmgmt concent r2 gdpp developed idv media ///
	antidir_new	ex_ante_dealing	anti_dealing disclose ushold usholdgdp ///
	mb def investments cwc internalcf  ///
	bribes comp_fbank enforcement foregnownership integrity judimp judindp legsys privatecredit propprot ///
	def_dum financing_brs_dum earnmgmt_firm earnmgmt_firm1
	
local controlFirm logmv mb revt_growth intangible nanalyst turnoverpre12 retstd12 	
local controlAnalyst return_rev optimism_eps firmex genex nticker brsize acwi12
local ret return3 return5 return30 return92 return182	 		

keep analyst_loc headqctry ctryinfrp1_firm ctryinfrp2_firm ctryinfrp1 ctryinfrp2 headqctry return30 deltatp2tp tpret_sic tpretadj_sic tp2p `ret'  `controlFirm' `controlAnalyst' `traits2'  secabb year mth ticker `pcs'

encode ticker, gen(f)
gen commonlaw = 1 - civillaw
replace nanalyst = log(nanalyst)
replace brsize = log(brsize)
replace nticker = log(nticker)
replace gdpp = gdpp/10000

drop ctryinfrp1 ctryinfrp2 

* Merge WGI data
sort analyst_loc year
merge m:1 analyst_loc year using wgi_rank.dta, update replace
drop _merge 

merge m:1 analyst_loc year using pc.dta, update replace		/***** Principal components ****/
drop _merge 

gen inter_ctry=ctryinfrp1*tp2p	
	
gen y=string(year)
replace headqctry=headqctry+y
gen ctrypair=headqctry + analyst_loc

sum `ret' tp2p tpret_sic deltatp2tp

foreach dep in `ret'  {	
	replace `dep'=`dep'*100
}
	
xtset f 
local ret return3 return30  	
local controlFirm logmv mb revt_growth intangible nanalyst turnoverpre12 retstd12 	
local controlAnalyst  return_rev optimism_eps firmex genex nticker brsize acwi12

foreach dep in `ret'  {	
	foreach traits in tp2p tpret_sic deltatp2tp  {	
	foreach ctrytrait in ctryinfrp1 legsys corruption judicial ruleoflaw       {	
		replace inter_ctry=`ctrytrait'*`traits'	
		eststo:	xi: xtreg `dep' `traits'  inter_ctry `ctrytrait' 		`controlFirm' `controlAnalyst' i.year i.mth, fe vce(cluster headqctry)
		}
	}
}

esttab using MarketRetrev1.csv, b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Markettest)
clear
clear mata
clear matrix
set mem 25000m
set more off 
set maxvar 30000
set matsize 11000
 
cd "D:\TP"
use final  

encode ticker, gen(f)
encode headqctry, gen (headqctry1)
egen firm_year = group(ticker year)
gen y=string(year)
replace nanalyst = log(nanalyst)
replace brsize = log(brsize)
replace nticker = log(nticker)
replace gdpp = gdpp/10000
gen y=string(year)
gen ctrypairyr=headqctry+analyst_loc+y
replace headqctry=headqctry+y
gen analyst_locyr=analyst_loc+y
encode ctrypair, gen(pair)
opt_accu6 = 1 - ratio6
opt_accu3 = 1 - ratio3

* Merge WGI data
sort analyst_loc year
merge m:1 analyst_loc year using wgi_rank.dta, update replace
drop _merge 

merge m:1 analyst_loc year using pc.dta, update replace		/***** Principal components ****/
drop _merge 

sort headqctry year
merge m:1 headqctry year using wgi_headqctry.dta, update replace
drop _merge 

merge m:1 headqctry year using headqctry_traits.dta, update replace
drop _merge 

merge m:1 headqctry year using pc_firm.dta, update replace
drop _merge 

local controlFirm logmv mb revt_growth intangible nanalyst turnoverpre12 retstd12		
local controlAnalyst deltatp2tp return_rev optimism_eps firmex genex nticker brsize acwi12
local dep tp2p tp2p_rank2 opt_accu6 delta6radj 
local ctrytrait legalenf ex_ante_dealing 
local control gdpp commonlaw `controlFirm' `controlAnalyst' i.year 

gen idctry=analyst_loc
sort idctry year

merge m:1 idctry using govern.dta, update replace

drop _merge 
sort headqctry year
merge m:1 headqctry year using PCREV_firm.dta, update replace
drop _merge
 
sort ticker amaskcd anndats 
merge m:1 ticker amaskcd anndats using prc_revdate.dta, update replace 
drop _merge 

save JAR2.dta, replace


*Target Price Optimism and Analyst-Country Traits
clear
clear mata
clear matrix
set mem 25000m
set more off 
set maxvar 30000
set matsize 11000

cd "D:\TP"
use JAR2, clear
*use jarrev, clear

sort ticker
by ticker: keep if _n==1		/**I/B/E/S ticker in the final sample: 17,353 ticker**/
drop if ticker==""
*keep ticker 
*save SampleTicker, replace

sort analyst_loc year
merge m:1 analyst_loc year using PCREV.dta, update replace
drop _merge 

merge m:1 analyst_loc using Jacksonroe.dta, update replace /*****JacksonRoeJFE09 - Public and Private Enforcement of Securities Laws Resource-Based Evidence*********/
drop _merge 

merge m:1 analyst_loc using secreg.dta, update replace /*****LLS (JFE2006): What Works in Securities Laws.xls*********/
drop _merge 
gen staff1=staff/100

local controlFirm logmv mb revt_growth intangible nanalyst turnoverpre12 retstd12		
local controlAnalyst deltatp2tp return_rev optimism_eps firmex genex nticker brsize acwi12
local dep tp2p tp2p_rank2 opt_accu6 delta6radj 
local ctrytrait ctryinfrp1 legsys judicial ruleoflaw corruption 
local control gdpp commonlaw `controlFirm' `controlAnalyst' i.year 

*** Firm fixed effects
xtset f 
***Benchmark reg****
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3'  `control', fe vce(cluster headqctry)		
	}
		
*	Main Tables 5
	foreach trait in `ctrytrait'        {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control', fe vce(cluster headqctry)
		}
	}
	
*	Covered by both local and Foreign analysts;	
	foreach trait in  `ctrytrait' {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control' if localfgn == 2, fe vce(cluster headqctry)
		}
	}
	
*	analyst_loc_freq >=2	
	foreach trait in `ctrytrait'       {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control' if analyst_loc_freq >=2, fe vce(cluster headqctry)
		}
	}
	
*	Non US firms;	
	foreach trait in  `ctrytrait' {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control' if headqctry != "NA", fe vce(cluster headqctry)
		}
	}
	
	esttab using "C:\Users\hptan\Dropbox\JARcheck1.csv", b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Fixed effect)

	
	*	Foreign analysts;	
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' ctryinfrp1rev ctryinfrp1rev_firm ctryinfrp2rev ctryinfrp2rev_firm 	`control' if local == 0, fe vce(cluster headqctry)
	}
	
*	Full sample: Both analyst counctry and firm country traits	
	foreach trait in  `ctrytrait' {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `trait'_f	`control', 			fe vce(cluster headqctry)
		}
	}	
	
*	Foreign analysts: Both analyst counctry and firm country traits	
	foreach trait in  `ctrytrait' {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `trait'_f	`control' if local == 0, fe vce(cluster headqctry)
		}
	}
	esttab using "C:\Users\hptan\Dropbox\JARcheck1.csv", b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Fixed effect)

	
*	What Works in Securities Laws.xls LA PORTA
*	Robustness: Resource-based enforcement of securities laws   JacksonRoeJFE09 - Public and Private Enforcement of Securities Laws Resource-Based Evidence
	foreach depvar3 in  `dep' {	
		foreach trait in  judimp ex_ante_dealing legalenf pub_enfdjankov staff1 publ_enf  {	
		eststo: xi: xtreg `depvar3' `trait' `control', fe vce(cluster headqctry)
		}
	}
	
*	Control for both firm and analsyt fixed effects
	foreach depvar3 in `dep'  {	
	foreach trait in  `ctrytrait' {
		eststo: xi: reghdfe `depvar3' `trait' `control' i.year, 	absorb(f amaskcd)  cluster(headqctry)
		}
	}
	
	esttab using "C:\Users\hptan\Dropbox\OtherCtryTraits1.csv", b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Fixed effect)


xtset f 
****Table Country pair-firm-year level	
	collapse `dep' `ctrytrait' gdpp commonlaw `controlFirm' `controlAnalyst', by(f year headqctry analyst_loc )
	
	foreach trait in `ctrytrait'       {
	foreach depvar3 in  `dep' {	
		eststo: xi: xtreg `depvar3' `trait' `control', fe vce(cluster headqctry)
		}
	}

esttab using "C:\Users\hptan\Dropbox\JARcheck1.csv", b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Fixed effect)
	

	
**Return predicative power
clear
clear matrix
set mem 25000m
set more off 
cd "D:\TP"
*cd "K:\TP_Alan 2016\P"

*use Jar2
use Jarr1
sum return3 return5 return30 return92 return182	

local traits2 firmex firmex_dum purebroker leadunderwriter research local purelocal expalocal civillaw judicial rule corruption priv_enf publ_enf ///
	it_enf investor_pr expropriat accntstd cifar earnmgmt concent r2 gdpp developed idv media ///
	antidir_new	ex_ante_dealing	anti_dealing disclose ushold usholdgdp ///
	mb def investments cwc internalcf  ///
	bribes comp_fbank enforcement foregnownership integrity judimp judindp legsys privatecredit propprot ///
	def_dum financing_brs_dum earnmgmt_firm earnmgmt_firm1
	
local controlFirm logmv mb revt_growth intangible nanalyst turnoverpre12 retstd12 	
local controlAnalyst return_rev optimism_eps firmex genex nticker brsize acwi12
local ret return3 return5 return30 return92 return182	 		

keep analyst_loc headqctry ctryinfrp1_firm ctryinfrp2_firm ctryinfrp1 ctryinfrp2 headqctry return30 deltatp2tp tpret_sic tpretadj_sic tp2p `ret'  `controlFirm' `controlAnalyst' `traits2'  secabb year mth ticker `pcs'

encode ticker, gen(f)
gen commonlaw = 1 - civillaw
replace nanalyst = log(nanalyst)
replace brsize = log(brsize)
replace nticker = log(nticker)
replace gdpp = gdpp/10000

drop ctryinfrp1 ctryinfrp2 

* Merge WGI data
sort analyst_loc year
merge m:1 analyst_loc year using wgi_rank.dta, update replace
drop _merge 

merge m:1 analyst_loc year using pc.dta, update replace		/***** Principal components ****/
drop _merge 

gen inter_ctry=ctryinfrp1*tp2p	
	
gen y=string(year)
replace headqctry=headqctry+y
gen ctrypair=headqctry + analyst_loc

sum `ret' tp2p tpret_sic deltatp2tp

foreach dep in `ret'  {	
	replace `dep'=`dep'*100
}
	
xtset f 
local ret return3 return30  	
local controlFirm logmv mb revt_growth intangible nanalyst turnoverpre12 retstd12 	
local controlAnalyst  return_rev optimism_eps firmex genex nticker brsize acwi12

foreach dep in `ret'  {	
	foreach traits in tp2p tpret_sic deltatp2tp  {	
	foreach ctrytrait in ctryinfrp1 legsys corruption judicial ruleoflaw       {	
		replace inter_ctry=`ctrytrait'*`traits'	
		eststo:	xi: xtreg `dep' `traits'  inter_ctry `ctrytrait' 		`controlFirm' `controlAnalyst' i.year i.mth, fe vce(cluster headqctry)
		}
	}
}

esttab using MarketRetrev1.csv, b(3) ar2 nogaps star(* 0.10 ** 0.05 *** 0.01)   replace title ( Markettest)

brainstormingobra/superpowersYou MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or planning anything new, in software or out of it (a talk, a business, a renovation).Stars: 323kUpdated Claude CodeCodexVerifiedInstall
brand-guidelinesanthropics/skillsApplies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
frontend-designanthropics/skillsGuidance for distinctive, intentional visual design when building new UI or reshaping an existing one. Helps with aesthetic direction, typography, and making choices that don't read as templated defaults.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
mcp-builderanthropics/skillsGuide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK).Stars: 198kUpdated Claude CodeCodexVerifiedInstall