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_hcp.do

View on GitHub


*********************************************************************
**** CODE FOR PAPER "FRAUD ALLEGATIONS AND GOVERNMENT CONTRACTING" 
*****             BY JONAS HEESE AND GERARDO PEREZ CAVAZOS 
*************************************************************************

cap log close
clear 
clear mata
clear matrix
set mem 700m, permanently
set maxvar 32767, permanently
set matsize 11000


global  jarpaper "C:\Users\......."
use "$jarpaper\final_data", replace 

tsset gvkeyn yq_n2

**********************************************************************************************
****  REGRESSIONS 
**********************************************************************************************

**********************************************************************************************
*** generate variables
**********************************************************************************************

gen log_at = log(1+atq)
gen lev= ltq/seq
gen cogs = cogsq/l.saleq

generate sic2 = int(sic/100)
bysort sic2 fyearq: egen total_rev = sum(revtq)
bysort sic2 fyearq: gen mktshare = revtq/total_rev
bysort sic2 fyearq: egen hhi = sum(mktshare^2)
egen comp_med = median(hhi)
gen high_comp =1 if hhi<comp_med
replace high_comp=0 if high_comp==.

label variable log_at "Size"
label variable hhi "HHI"
label variable cogs "COGS"
label variable lev "Leverage"

*******************************
******* TABLE 2 
*****************************************************

sum   dollars_contract_sum    def_total_sum   pct_def_agency    cost_total_sum def_cost_total_sum pct_cost_def_agency  service_total_sum pct_cost_service  product_total_sum pct_cost_product  rd_total_sum pct_cost_rd atq hhi  cogs lev , d

***** REGRESSIONS:

*Treatment variable
gen w8q=1 if post_1==1
replace w8q=1 if post_2==1
replace w8q=1 if post_3==1
replace w8q=1 if post_4==1
replace w8q=1 if post_5==1
replace w8q=1 if post_6==1
replace w8q=1 if post_7==1
replace w8q=1 if post_8==1
replace w8q=0 if  w8q==.


***TABLE 3 
areg  pct_def_agency w8q  log_at hhi cogs lev  i.fyearq  if  (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn) cluster(gvkeyn)  
gen intable3= e(sample)
areg  pct_def_agency w8q  log_at hhi cogs lev   i.def_ag##i.fyearq i.def_ag##i.fqtr  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)    
areg  pct_def_agency w8q  log_at hhi cogs lev   i.def_ag##i.fyearq i.def_ag##i.fqtr i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)    


***TABLE 4 
areg  pct_cost_def_agency w8q  log_at hhi cogs  lev  i.fyearq   if  (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn)  cluster(gvkeyn)  
gen intable4 = e(sample)
areg pct_cost_def_agency w8q  log_at hhi cogs  lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr   if intable4==1 , absorb(gvkeyn) cluster(gvkeyn)  
areg pct_cost_def_agency w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if intable4==1  ,  absorb(gvkeyn) cluster(gvkeyn) 

*****Table 5
***panel A

** Service
areg pct_def_agency_service w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_def_agency_service w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

** Product
areg pct_def_agency_product w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_def_agency_product w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

** R&D
areg pct_def_agency_rd w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_def_agency_rd w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

***panel B
** Service
areg pct_cost_def_agency_service w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_cost_def_agency_service w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

** Product
areg pct_cost_def_agency_product w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_cost_def_agency_product w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

** R&D
areg pct_cost_def_agency_rd w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_cost_def_agency_rd w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

*****Table 7 
reghdfe  pct_cost_def_agency pre_3 pre_4 pre_5 pre_6 pre_7 pre_8 post_1 post_2 post_3 post_4 post_5 post_6 post_7 post_8  log_at hhi cogs  lev i.fqtr if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | fraudq==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn)  cluster(gvkeyn) 

*****Table 8 
*****Panel A
areg  pct_def_agency c.w8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.long_investigation  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.serious_settle  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  

*****Panel B
areg  pct_cost_def_agency c.w8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.long_investigation  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.serious_settle  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  

*****Table 9 
*****Panel A

**Alternative Treatment: compare eight quarters prior to the whistleblower allegation to the eight quarters following the DOJ's intervention decision 
gen inter8q=1 if inter_1==1
replace inter8q=1 if inter_2==1
replace inter8q=1 if inter_3==1
replace inter8q=1 if inter_4==1
replace inter8q=1 if inter_5==1
replace inter8q=1 if inter_6==1
replace inter8q=1 if inter_7==1
replace inter8q=1 if inter_8==1
replace inter8q=0 if  inter8q==.

areg  pct_def_agency inter8q  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | inter_1==1 | inter_2==1 | inter_3==1 | inter_4==1 | inter_5==1 | inter_6==1 | inter_7==1 | inter_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn) cluster(gvkeyn)  
gen intable9a = e(sample)
areg  pct_def_agency c.inter8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if   if  intable9a==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.inter8q##c.long_investigation  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9a==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.inter8q##c.serious_settle  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9a==1, absorb(gvkeyn) cluster(gvkeyn)  

*****Panel B
areg  pct_cost_def_agency c.inter8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | inter_1==1 | inter_2==1 | inter_3==1 | inter_4==1 | inter_5==1 | inter_6==1 | inter_7==1 | inter_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn) cluster(gvkeyn)
gen intable9b = e(sample)
areg  pct_cost_def_agency c.inter8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9b==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.inter8q##c.long_investigation  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9b==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.inter8q##c.serious_settle  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9b==1, absorb(gvkeyn) cluster(gvkeyn)  

***Table 10
**Panel A
areg  pct_def_agency c.w8q##c.pc  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.logsumpc  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.largest_100_Max  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.connectedboard  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  

**Panel B
areg  pct_cost_def_agency c.w8q##c.pc  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.logsumpc  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.largest_100_Max  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.connectedboard  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  













*********************************************************************
**** CODE FOR PAPER "FRAUD ALLEGATIONS AND GOVERNMENT CONTRACTING" 
*****             BY JONAS HEESE AND GERARDO PEREZ CAVAZOS 
*************************************************************************

cap log close
clear 
clear mata
clear matrix
set mem 700m, permanently
set maxvar 32767, permanently
set matsize 11000


global  jarpaper "C:\Users\......."
use "$jarpaper\final_data", replace 

tsset gvkeyn yq_n2

**********************************************************************************************
****  REGRESSIONS 
**********************************************************************************************

**********************************************************************************************
*** generate variables
**********************************************************************************************

gen log_at = log(1+atq)
gen lev= ltq/seq
gen cogs = cogsq/l.saleq

generate sic2 = int(sic/100)
bysort sic2 fyearq: egen total_rev = sum(revtq)
bysort sic2 fyearq: gen mktshare = revtq/total_rev
bysort sic2 fyearq: egen hhi = sum(mktshare^2)
egen comp_med = median(hhi)
gen high_comp =1 if hhi<comp_med
replace high_comp=0 if high_comp==.

label variable log_at "Size"
label variable hhi "HHI"
label variable cogs "COGS"
label variable lev "Leverage"

*******************************
******* TABLE 2 
*****************************************************

sum   dollars_contract_sum    def_total_sum   pct_def_agency    cost_total_sum def_cost_total_sum pct_cost_def_agency  service_total_sum pct_cost_service  product_total_sum pct_cost_product  rd_total_sum pct_cost_rd atq hhi  cogs lev , d

***** REGRESSIONS:

*Treatment variable
gen w8q=1 if post_1==1
replace w8q=1 if post_2==1
replace w8q=1 if post_3==1
replace w8q=1 if post_4==1
replace w8q=1 if post_5==1
replace w8q=1 if post_6==1
replace w8q=1 if post_7==1
replace w8q=1 if post_8==1
replace w8q=0 if  w8q==.


***TABLE 3 
areg  pct_def_agency w8q  log_at hhi cogs lev  i.fyearq  if  (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn) cluster(gvkeyn)  
gen intable3= e(sample)
areg  pct_def_agency w8q  log_at hhi cogs lev   i.def_ag##i.fyearq i.def_ag##i.fqtr  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)    
areg  pct_def_agency w8q  log_at hhi cogs lev   i.def_ag##i.fyearq i.def_ag##i.fqtr i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)    


***TABLE 4 
areg  pct_cost_def_agency w8q  log_at hhi cogs  lev  i.fyearq   if  (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn)  cluster(gvkeyn)  
gen intable4 = e(sample)
areg pct_cost_def_agency w8q  log_at hhi cogs  lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr   if intable4==1 , absorb(gvkeyn) cluster(gvkeyn)  
areg pct_cost_def_agency w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if intable4==1  ,  absorb(gvkeyn) cluster(gvkeyn) 

*****Table 5
***panel A

** Service
areg pct_def_agency_service w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_def_agency_service w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

** Product
areg pct_def_agency_product w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_def_agency_product w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

** R&D
areg pct_def_agency_rd w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_def_agency_rd w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

***panel B
** Service
areg pct_cost_def_agency_service w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_cost_def_agency_service w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

** Product
areg pct_cost_def_agency_product w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_cost_def_agency_product w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

** R&D
areg pct_cost_def_agency_rd w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_cost_def_agency_rd w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

*****Table 7 
reghdfe  pct_cost_def_agency pre_3 pre_4 pre_5 pre_6 pre_7 pre_8 post_1 post_2 post_3 post_4 post_5 post_6 post_7 post_8  log_at hhi cogs  lev i.fqtr if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | fraudq==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn)  cluster(gvkeyn) 

*****Table 8 
*****Panel A
areg  pct_def_agency c.w8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.long_investigation  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.serious_settle  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  

*****Panel B
areg  pct_cost_def_agency c.w8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.long_investigation  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.serious_settle  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  

*****Table 9 
*****Panel A

**Alternative Treatment: compare eight quarters prior to the whistleblower allegation to the eight quarters following the DOJ's intervention decision 
gen inter8q=1 if inter_1==1
replace inter8q=1 if inter_2==1
replace inter8q=1 if inter_3==1
replace inter8q=1 if inter_4==1
replace inter8q=1 if inter_5==1
replace inter8q=1 if inter_6==1
replace inter8q=1 if inter_7==1
replace inter8q=1 if inter_8==1
replace inter8q=0 if  inter8q==.

areg  pct_def_agency inter8q  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | inter_1==1 | inter_2==1 | inter_3==1 | inter_4==1 | inter_5==1 | inter_6==1 | inter_7==1 | inter_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn) cluster(gvkeyn)  
gen intable9a = e(sample)
areg  pct_def_agency c.inter8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if   if  intable9a==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.inter8q##c.long_investigation  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9a==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.inter8q##c.serious_settle  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9a==1, absorb(gvkeyn) cluster(gvkeyn)  

*****Panel B
areg  pct_cost_def_agency c.inter8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | inter_1==1 | inter_2==1 | inter_3==1 | inter_4==1 | inter_5==1 | inter_6==1 | inter_7==1 | inter_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn) cluster(gvkeyn)
gen intable9b = e(sample)
areg  pct_cost_def_agency c.inter8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9b==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.inter8q##c.long_investigation  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9b==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.inter8q##c.serious_settle  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9b==1, absorb(gvkeyn) cluster(gvkeyn)  

***Table 10
**Panel A
areg  pct_def_agency c.w8q##c.pc  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.logsumpc  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.largest_100_Max  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.connectedboard  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  

**Panel B
areg  pct_cost_def_agency c.w8q##c.pc  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.logsumpc  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.largest_100_Max  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.connectedboard  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  













*********************************************************************
**** CODE FOR PAPER "FRAUD ALLEGATIONS AND GOVERNMENT CONTRACTING" 
*****             BY JONAS HEESE AND GERARDO PEREZ CAVAZOS 
*************************************************************************

cap log close
clear 
clear mata
clear matrix
set mem 700m, permanently
set maxvar 32767, permanently
set matsize 11000


global  jarpaper "C:\Users\......."
use "$jarpaper\final_data", replace 

tsset gvkeyn yq_n2

**********************************************************************************************
****  REGRESSIONS 
**********************************************************************************************

**********************************************************************************************
*** generate variables
**********************************************************************************************

gen log_at = log(1+atq)
gen lev= ltq/seq
gen cogs = cogsq/l.saleq

generate sic2 = int(sic/100)
bysort sic2 fyearq: egen total_rev = sum(revtq)
bysort sic2 fyearq: gen mktshare = revtq/total_rev
bysort sic2 fyearq: egen hhi = sum(mktshare^2)
egen comp_med = median(hhi)
gen high_comp =1 if hhi<comp_med
replace high_comp=0 if high_comp==.

label variable log_at "Size"
label variable hhi "HHI"
label variable cogs "COGS"
label variable lev "Leverage"

*******************************
******* TABLE 2 
*****************************************************

sum   dollars_contract_sum    def_total_sum   pct_def_agency    cost_total_sum def_cost_total_sum pct_cost_def_agency  service_total_sum pct_cost_service  product_total_sum pct_cost_product  rd_total_sum pct_cost_rd atq hhi  cogs lev , d

***** REGRESSIONS:

*Treatment variable
gen w8q=1 if post_1==1
replace w8q=1 if post_2==1
replace w8q=1 if post_3==1
replace w8q=1 if post_4==1
replace w8q=1 if post_5==1
replace w8q=1 if post_6==1
replace w8q=1 if post_7==1
replace w8q=1 if post_8==1
replace w8q=0 if  w8q==.


***TABLE 3 
areg  pct_def_agency w8q  log_at hhi cogs lev  i.fyearq  if  (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn) cluster(gvkeyn)  
gen intable3= e(sample)
areg  pct_def_agency w8q  log_at hhi cogs lev   i.def_ag##i.fyearq i.def_ag##i.fqtr  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)    
areg  pct_def_agency w8q  log_at hhi cogs lev   i.def_ag##i.fyearq i.def_ag##i.fqtr i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)    


***TABLE 4 
areg  pct_cost_def_agency w8q  log_at hhi cogs  lev  i.fyearq   if  (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn)  cluster(gvkeyn)  
gen intable4 = e(sample)
areg pct_cost_def_agency w8q  log_at hhi cogs  lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr   if intable4==1 , absorb(gvkeyn) cluster(gvkeyn)  
areg pct_cost_def_agency w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if intable4==1  ,  absorb(gvkeyn) cluster(gvkeyn) 

*****Table 5
***panel A

** Service
areg pct_def_agency_service w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_def_agency_service w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

** Product
areg pct_def_agency_product w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_def_agency_product w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

** R&D
areg pct_def_agency_rd w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_def_agency_rd w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

***panel B
** Service
areg pct_cost_def_agency_service w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_cost_def_agency_service w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

** Product
areg pct_cost_def_agency_product w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_cost_def_agency_product w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

** R&D
areg pct_cost_def_agency_rd w8q log_at hhi cogs   lev  i.fyearq if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 
areg pct_cost_def_agency_rd w8q log_at hhi cogs   lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq   if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013,  absorb(gvkeyn) cluster(gvkeyn) 

*****Table 7 
reghdfe  pct_cost_def_agency pre_3 pre_4 pre_5 pre_6 pre_7 pre_8 post_1 post_2 post_3 post_4 post_5 post_6 post_7 post_8  log_at hhi cogs  lev i.fqtr if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | fraudq==1 | post_1==1 | post_2==1 | post_3==1 | post_4==1 | post_5==1 | post_6==1 | post_7==1 | post_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn)  cluster(gvkeyn) 

*****Table 8 
*****Panel A
areg  pct_def_agency c.w8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.long_investigation  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.serious_settle  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  

*****Panel B
areg  pct_cost_def_agency c.w8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.long_investigation  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.serious_settle  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  

*****Table 9 
*****Panel A

**Alternative Treatment: compare eight quarters prior to the whistleblower allegation to the eight quarters following the DOJ's intervention decision 
gen inter8q=1 if inter_1==1
replace inter8q=1 if inter_2==1
replace inter8q=1 if inter_3==1
replace inter8q=1 if inter_4==1
replace inter8q=1 if inter_5==1
replace inter8q=1 if inter_6==1
replace inter8q=1 if inter_7==1
replace inter8q=1 if inter_8==1
replace inter8q=0 if  inter8q==.

areg  pct_def_agency inter8q  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if   (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | inter_1==1 | inter_2==1 | inter_3==1 | inter_4==1 | inter_5==1 | inter_6==1 | inter_7==1 | inter_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn) cluster(gvkeyn)  
gen intable9a = e(sample)
areg  pct_def_agency c.inter8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if   if  intable9a==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.inter8q##c.long_investigation  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9a==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.inter8q##c.serious_settle  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9a==1, absorb(gvkeyn) cluster(gvkeyn)  

*****Panel B
areg  pct_cost_def_agency c.inter8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  (pre_1==1 | pre_2==1 |pre_3==1 | pre_4==1 | pre_5==1 | pre_6==1  | pre_7==1 | pre_8==1 | inter_1==1 | inter_2==1 | inter_3==1 | inter_4==1 | inter_5==1 | inter_6==1 | inter_7==1 | inter_8==1) & fyearq > 1999 & fyearq < 2013, absorb(gvkeyn) cluster(gvkeyn)
gen intable9b = e(sample)
areg  pct_cost_def_agency c.inter8q##c.serious_doj  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9b==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.inter8q##c.long_investigation  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9b==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.inter8q##c.serious_settle  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable9b==1, absorb(gvkeyn) cluster(gvkeyn)  

***Table 10
**Panel A
areg  pct_def_agency c.w8q##c.pc  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.logsumpc  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.largest_100_Max  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_def_agency c.w8q##c.connectedboard  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable3==1, absorb(gvkeyn) cluster(gvkeyn)  

**Panel B
areg  pct_cost_def_agency c.w8q##c.pc  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.logsumpc  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.largest_100_Max  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  
areg  pct_cost_def_agency c.w8q##c.connectedboard  log_at hhi cogs lev  i.def_ag##i.fyearq  i.def_ag##i.fqtr  i.ind_code##i.fyearq  if  intable4==1, absorb(gvkeyn) cluster(gvkeyn)  












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