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

View on GitHub

/* code from raw data to generate the baseline Table 3 */

/********************************************************************************************************/
/********************************* Preparing variables *****************************************/
/********************************************************************************************************/

clear
use compa_all.dta, clear /* raw compustat annual data */
keep gvkey datadate sich sic
sort gvkey datadate
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
tostring sich,gen(sich_string)
replace sich_string=sic if sich==.
replace sich_string="000"+ sich_string
replace sich_string=substr(sich_string,-4,4)
destring sich_string,gen(sich_num)
save compa_sich.dta ,replace
/************************************************************************************/

use compa_all.dta, clear /* raw compustat annual data */
keep gvkey datadate fyear at mkvalt csho prcc_f xrd dvc oibdp ppegt ppent dltt dlc capx txdb ceq pstkrv prstkc ib dp seq dvp che invt ppegt emp aqc aqs rect sale state ibcom oibdp xint txt act lct idit dvpsx_f ajex spi curcd
drop if datadate==.     
replace fyear=year(datadate) if fyear==.     
duplicates tag gvkey  fyear, gen(dupnum)     
tab dupnum
drop if dupnum==1 & at==.
duplicates list gvkey fyear
drop dupnum   

sort gvkey fyear
destring gvkey, generate(num_gvkey)
tsset num_gvkey fyear
replace idit=0 if idit==.
replace xint=0 if xint==.
gen CoreEarn=ib+0.6*xint-0.6*idit
sort num_gvkey fyear
by num_gvkey: gen lag_at=l.at
by num_gvkey: gen lag_earn = l.CoreEarn
gen DPS=dvpsx_f/ajex 
by num_gvkey: gen f_DPS=f.DPS
gen ROA=CoreEarn/lag_at
gen l1ROA=l.ROA
gen l2ROA=l2.ROA
gen l3ROA=l3.ROA
egen n=rownonmiss(ROA l1ROA l2ROA l3ROA)
egen ROAVol=rowsd(ROA l1ROA l2ROA l3ROA) if n==4
gen SI=spi/lag_at
generate LOSS=.
replace LOSS=1 if CoreEarn<0
replace LOSS=0 if CoreEarn>=0
replace LOSS=. if CoreEarn==.
bys num_gvkey: asreg CoreEarn lag_earn, wind(fyear 16) min(4)
rename _b_lag_earn Persist
drop _Nobs _R2 _adjR2 _b_cons n

sort gvkey fyear
gen lnsize_at=ln(at)     
gen ppeta=ppent/at      
gen lev=(dltt+dlc)/at      
gen data74=txdb      
replace data74=0 if txdb==.      
gen q=(csho*prcc_f+at-ceq-data74)/at
gen cashholding=che/at
merge 1:1 gvkey datadate using compa_sich, keepusing(sich_num sich_string) /* compustat industry info, generated above */
drop if _merge==2
drop _merge
gen sic3=substr(sich_string,1,3)
gen flag_fu=1 if 4900<=sich_num & sich_num<=4949      
replace flag_fu=1 if 6000<=sich_num & sich_num<=6999 
replace flag_fu=0 if missing(flag_fu)
keep if flag_fu==0
keep if curcd=="USD"
rename num_gvkey gvkey_n
sort gvkey_n datadate
save compa_from_Huan_final_JAR.dta, replace
/************************************************************************************/


/* 3-step SAS/Stata codes that generate cost stickiness measure (b_dec), written by Huan */

/* Step 1: SAS */
data compa;
set comp.compa_all(keep=gvkey datadate); /* raw compustat annual data */
num_qtr=(year(datadate)-1980)*4+qtr(datadate);
run;

data compq1;
set compq; /* raw compustat quarterly data */
num_qtr=(year(datadate)-1980)*4+qtr(datadate);
run;

proc sql;
create table compa_q as select
a.*,b.datadate as datadateq,b.fyearq,b.fqtr,b.fyr,b.datacqtr,b.datafqtr,b.num_qtr as num_qtrq,b.saleq,b.xsgaq,b.atq,b.cogsq,b.oiadpq,b.xrdq
from compa as  a left join compq1 as b
on a.gvkey=b.gvkey and a.num_qtr-b.num_qtr>=0 and a.num_qtr-b.num_qtr<=20;
quit;

proc sort data=compa_q;
by gvkey datadate datadateq;
quit;

/* Step 2: stata codes for generating datasets used in the above SAS code: */

use compa_q.dta, clear
gen order_q_dist= num_qtr - num_qtrq
drop if missing( order_q_dist)
gen datadate_qdate=quarterly( datacqtr ,"YQ")
replace datadate_qdate=qofd(datadateq) if missing(datacqtr)
format datadate_qdate %tq
egen gvkey_datadate=group(gvkey datadate)
duplicates tag gvkey_datadate datadate_qdate, gen(tag)
tab tag
browse if tag==1
browse if tag==2
drop if missing(datacqtr)
drop tag
duplicates tag gvkey_datadate datadate_qdate, gen(tag)
tab tag
browse if tag==1
browse if gvkey_datadate==392684
drop if gvkey_datadate==392684 & tag==1 & fyr==12
drop tag
xtset gvkey_datadate datadate_qdate ,quarterly
gen ch_lg_xsgaq=ln(xsgaq)-ln(l.xsgaq)
gen ch_lg_cogsq=ln(cogsq)-ln(l.cogsq)
gen ch_lg_oc=ln(saleq-oiadpq)-ln(l.saleq-l.oiadpq)
gen ch_lg_cost=ln(cogsq+xsgaq)-ln(l.cogsq+l.xsgaq)
gen ch_lg_saleq=ln(saleq)-ln(l.saleq)
gen dec=1 if saleq-l.saleq<0
replace dec=0 if saleq-l.saleq>=0
gen dec_ch_lg_saleq=dec*ch_lg_saleq
gen dec1=1 if saleq-l.saleq<0
replace dec1=0 if saleq-l.saleq>0
saveold compa_q1.dta ,replace

/* Step 3: SAS */

data compa_q1_16;
set compa_q1;
drop gvkey_datadate;
if order_q_dist>=0 & order_q_dist<=15;
if missing(ch_lg_xsgaq) or missing(ch_lg_saleq) then delete;
run;

proc sort data=compa_q1_16;
by gvkey datadate desending order_q_dist;
quit;

proc reg data=compa_q1_16 noprint outest=b_dec_16 edf;
by gvkey datadate;
model ch_lg_xsgaq=ch_lg_saleq dec_ch_lg_saleq;
quit;

data b_dec_16(drop=_p_ _edf_);
set b_dec_16(keep=gvkey datadate ch_lg_saleq dec_ch_lg_saleq _p_ _edf_ _rsq_);
n=_p_+_edf_;
rename dec_ch_lg_saleq=b_dec;
rename ch_lg_saleq=b;
rename _rsq_=r_square;
run;

/*********************** Table 3: baseline OLS regressions **********************************/
/*******************************************************/

use compa_from_Huan_final_JAR, clear
gen year=year(datadate)
merge 1:1 gvkey datadate using b_dec_16,keepusing(b b_dec n)
drop if _m==2
drop _merge
replace b_dec=b_dec*(-1)
replace b_dec=. if n<16
drop n
drop year
rename fyear year
sort gvkey_n year
xtset gvkey_n year, yearly
egen sic3_year=group(sic3 year)
keep if year>=1978 & year<=2016 
foreach var in f_DPS b_dec lnsize_at lev q cashholding ppeta ROA ROAVol SI Persist {
winsor `var', gen(w`var') p(0.01)
}
gen neg_wSI=-wSI

set more off
unab control: wlnsize_at wlev wq wcashholding wppeta wROA wROAVol LOSS neg_wSI wPersist

reghdfe wf_DPS wb_dec `control', noabsorb cluster(gvkey_n)
keep if e(sample)
reghdfe wf_DPS wb_dec `control', a(sic3_year) cluster(gvkey_n) 

/* generating identifiers */

keep gvkey 
duplicates drop
save identifier_gvkey
/* code from raw data to generate the baseline Table 3 */

/********************************************************************************************************/
/********************************* Preparing variables *****************************************/
/********************************************************************************************************/

clear
use compa_all.dta, clear /* raw compustat annual data */
keep gvkey datadate sich sic
sort gvkey datadate
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
tostring sich,gen(sich_string)
replace sich_string=sic if sich==.
replace sich_string="000"+ sich_string
replace sich_string=substr(sich_string,-4,4)
destring sich_string,gen(sich_num)
save compa_sich.dta ,replace
/************************************************************************************/

use compa_all.dta, clear /* raw compustat annual data */
keep gvkey datadate fyear at mkvalt csho prcc_f xrd dvc oibdp ppegt ppent dltt dlc capx txdb ceq pstkrv prstkc ib dp seq dvp che invt ppegt emp aqc aqs rect sale state ibcom oibdp xint txt act lct idit dvpsx_f ajex spi curcd
drop if datadate==.     
replace fyear=year(datadate) if fyear==.     
duplicates tag gvkey  fyear, gen(dupnum)     
tab dupnum
drop if dupnum==1 & at==.
duplicates list gvkey fyear
drop dupnum   

sort gvkey fyear
destring gvkey, generate(num_gvkey)
tsset num_gvkey fyear
replace idit=0 if idit==.
replace xint=0 if xint==.
gen CoreEarn=ib+0.6*xint-0.6*idit
sort num_gvkey fyear
by num_gvkey: gen lag_at=l.at
by num_gvkey: gen lag_earn = l.CoreEarn
gen DPS=dvpsx_f/ajex 
by num_gvkey: gen f_DPS=f.DPS
gen ROA=CoreEarn/lag_at
gen l1ROA=l.ROA
gen l2ROA=l2.ROA
gen l3ROA=l3.ROA
egen n=rownonmiss(ROA l1ROA l2ROA l3ROA)
egen ROAVol=rowsd(ROA l1ROA l2ROA l3ROA) if n==4
gen SI=spi/lag_at
generate LOSS=.
replace LOSS=1 if CoreEarn<0
replace LOSS=0 if CoreEarn>=0
replace LOSS=. if CoreEarn==.
bys num_gvkey: asreg CoreEarn lag_earn, wind(fyear 16) min(4)
rename _b_lag_earn Persist
drop _Nobs _R2 _adjR2 _b_cons n

sort gvkey fyear
gen lnsize_at=ln(at)     
gen ppeta=ppent/at      
gen lev=(dltt+dlc)/at      
gen data74=txdb      
replace data74=0 if txdb==.      
gen q=(csho*prcc_f+at-ceq-data74)/at
gen cashholding=che/at
merge 1:1 gvkey datadate using compa_sich, keepusing(sich_num sich_string) /* compustat industry info, generated above */
drop if _merge==2
drop _merge
gen sic3=substr(sich_string,1,3)
gen flag_fu=1 if 4900<=sich_num & sich_num<=4949      
replace flag_fu=1 if 6000<=sich_num & sich_num<=6999 
replace flag_fu=0 if missing(flag_fu)
keep if flag_fu==0
keep if curcd=="USD"
rename num_gvkey gvkey_n
sort gvkey_n datadate
save compa_from_Huan_final_JAR.dta, replace
/************************************************************************************/


/* 3-step SAS/Stata codes that generate cost stickiness measure (b_dec), written by Huan */

/* Step 1: SAS */
data compa;
set comp.compa_all(keep=gvkey datadate); /* raw compustat annual data */
num_qtr=(year(datadate)-1980)*4+qtr(datadate);
run;

data compq1;
set compq; /* raw compustat quarterly data */
num_qtr=(year(datadate)-1980)*4+qtr(datadate);
run;

proc sql;
create table compa_q as select
a.*,b.datadate as datadateq,b.fyearq,b.fqtr,b.fyr,b.datacqtr,b.datafqtr,b.num_qtr as num_qtrq,b.saleq,b.xsgaq,b.atq,b.cogsq,b.oiadpq,b.xrdq
from compa as  a left join compq1 as b
on a.gvkey=b.gvkey and a.num_qtr-b.num_qtr>=0 and a.num_qtr-b.num_qtr<=20;
quit;

proc sort data=compa_q;
by gvkey datadate datadateq;
quit;

/* Step 2: stata codes for generating datasets used in the above SAS code: */

use compa_q.dta, clear
gen order_q_dist= num_qtr - num_qtrq
drop if missing( order_q_dist)
gen datadate_qdate=quarterly( datacqtr ,"YQ")
replace datadate_qdate=qofd(datadateq) if missing(datacqtr)
format datadate_qdate %tq
egen gvkey_datadate=group(gvkey datadate)
duplicates tag gvkey_datadate datadate_qdate, gen(tag)
tab tag
browse if tag==1
browse if tag==2
drop if missing(datacqtr)
drop tag
duplicates tag gvkey_datadate datadate_qdate, gen(tag)
tab tag
browse if tag==1
browse if gvkey_datadate==392684
drop if gvkey_datadate==392684 & tag==1 & fyr==12
drop tag
xtset gvkey_datadate datadate_qdate ,quarterly
gen ch_lg_xsgaq=ln(xsgaq)-ln(l.xsgaq)
gen ch_lg_cogsq=ln(cogsq)-ln(l.cogsq)
gen ch_lg_oc=ln(saleq-oiadpq)-ln(l.saleq-l.oiadpq)
gen ch_lg_cost=ln(cogsq+xsgaq)-ln(l.cogsq+l.xsgaq)
gen ch_lg_saleq=ln(saleq)-ln(l.saleq)
gen dec=1 if saleq-l.saleq<0
replace dec=0 if saleq-l.saleq>=0
gen dec_ch_lg_saleq=dec*ch_lg_saleq
gen dec1=1 if saleq-l.saleq<0
replace dec1=0 if saleq-l.saleq>0
saveold compa_q1.dta ,replace

/* Step 3: SAS */

data compa_q1_16;
set compa_q1;
drop gvkey_datadate;
if order_q_dist>=0 & order_q_dist<=15;
if missing(ch_lg_xsgaq) or missing(ch_lg_saleq) then delete;
run;

proc sort data=compa_q1_16;
by gvkey datadate desending order_q_dist;
quit;

proc reg data=compa_q1_16 noprint outest=b_dec_16 edf;
by gvkey datadate;
model ch_lg_xsgaq=ch_lg_saleq dec_ch_lg_saleq;
quit;

data b_dec_16(drop=_p_ _edf_);
set b_dec_16(keep=gvkey datadate ch_lg_saleq dec_ch_lg_saleq _p_ _edf_ _rsq_);
n=_p_+_edf_;
rename dec_ch_lg_saleq=b_dec;
rename ch_lg_saleq=b;
rename _rsq_=r_square;
run;

/*********************** Table 3: baseline OLS regressions **********************************/
/*******************************************************/

use compa_from_Huan_final_JAR, clear
gen year=year(datadate)
merge 1:1 gvkey datadate using b_dec_16,keepusing(b b_dec n)
drop if _m==2
drop _merge
replace b_dec=b_dec*(-1)
replace b_dec=. if n<16
drop n
drop year
rename fyear year
sort gvkey_n year
xtset gvkey_n year, yearly
egen sic3_year=group(sic3 year)
keep if year>=1978 & year<=2016 
foreach var in f_DPS b_dec lnsize_at lev q cashholding ppeta ROA ROAVol SI Persist {
winsor `var', gen(w`var') p(0.01)
}
gen neg_wSI=-wSI

set more off
unab control: wlnsize_at wlev wq wcashholding wppeta wROA wROAVol LOSS neg_wSI wPersist

reghdfe wf_DPS wb_dec `control', noabsorb cluster(gvkey_n)
keep if e(sample)
reghdfe wf_DPS wb_dec `control', a(sic3_year) cluster(gvkey_n) 

/* generating identifiers */

keep gvkey 
duplicates drop
save identifier_gvkey
/* code from raw data to generate the baseline Table 3 */

/********************************************************************************************************/
/********************************* Preparing variables *****************************************/
/********************************************************************************************************/

clear
use compa_all.dta, clear /* raw compustat annual data */
keep gvkey datadate sich sic
sort gvkey datadate
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
by gvkey: replace sich=sich[_n+1] if missing(sich) & !missing(sich[_n+1])
tostring sich,gen(sich_string)
replace sich_string=sic if sich==.
replace sich_string="000"+ sich_string
replace sich_string=substr(sich_string,-4,4)
destring sich_string,gen(sich_num)
save compa_sich.dta ,replace
/************************************************************************************/

use compa_all.dta, clear /* raw compustat annual data */
keep gvkey datadate fyear at mkvalt csho prcc_f xrd dvc oibdp ppegt ppent dltt dlc capx txdb ceq pstkrv prstkc ib dp seq dvp che invt ppegt emp aqc aqs rect sale state ibcom oibdp xint txt act lct idit dvpsx_f ajex spi curcd
drop if datadate==.     
replace fyear=year(datadate) if fyear==.     
duplicates tag gvkey  fyear, gen(dupnum)     
tab dupnum
drop if dupnum==1 & at==.
duplicates list gvkey fyear
drop dupnum   

sort gvkey fyear
destring gvkey, generate(num_gvkey)
tsset num_gvkey fyear
replace idit=0 if idit==.
replace xint=0 if xint==.
gen CoreEarn=ib+0.6*xint-0.6*idit
sort num_gvkey fyear
by num_gvkey: gen lag_at=l.at
by num_gvkey: gen lag_earn = l.CoreEarn
gen DPS=dvpsx_f/ajex 
by num_gvkey: gen f_DPS=f.DPS
gen ROA=CoreEarn/lag_at
gen l1ROA=l.ROA
gen l2ROA=l2.ROA
gen l3ROA=l3.ROA
egen n=rownonmiss(ROA l1ROA l2ROA l3ROA)
egen ROAVol=rowsd(ROA l1ROA l2ROA l3ROA) if n==4
gen SI=spi/lag_at
generate LOSS=.
replace LOSS=1 if CoreEarn<0
replace LOSS=0 if CoreEarn>=0
replace LOSS=. if CoreEarn==.
bys num_gvkey: asreg CoreEarn lag_earn, wind(fyear 16) min(4)
rename _b_lag_earn Persist
drop _Nobs _R2 _adjR2 _b_cons n

sort gvkey fyear
gen lnsize_at=ln(at)     
gen ppeta=ppent/at      
gen lev=(dltt+dlc)/at      
gen data74=txdb      
replace data74=0 if txdb==.      
gen q=(csho*prcc_f+at-ceq-data74)/at
gen cashholding=che/at
merge 1:1 gvkey datadate using compa_sich, keepusing(sich_num sich_string) /* compustat industry info, generated above */
drop if _merge==2
drop _merge
gen sic3=substr(sich_string,1,3)
gen flag_fu=1 if 4900<=sich_num & sich_num<=4949      
replace flag_fu=1 if 6000<=sich_num & sich_num<=6999 
replace flag_fu=0 if missing(flag_fu)
keep if flag_fu==0
keep if curcd=="USD"
rename num_gvkey gvkey_n
sort gvkey_n datadate
save compa_from_Huan_final_JAR.dta, replace
/************************************************************************************/


/* 3-step SAS/Stata codes that generate cost stickiness measure (b_dec), written by Huan */

/* Step 1: SAS */
data compa;
set comp.compa_all(keep=gvkey datadate); /* raw compustat annual data */
num_qtr=(year(datadate)-1980)*4+qtr(datadate);
run;

data compq1;
set compq; /* raw compustat quarterly data */
num_qtr=(year(datadate)-1980)*4+qtr(datadate);
run;

proc sql;
create table compa_q as select
a.*,b.datadate as datadateq,b.fyearq,b.fqtr,b.fyr,b.datacqtr,b.datafqtr,b.num_qtr as num_qtrq,b.saleq,b.xsgaq,b.atq,b.cogsq,b.oiadpq,b.xrdq
from compa as  a left join compq1 as b
on a.gvkey=b.gvkey and a.num_qtr-b.num_qtr>=0 and a.num_qtr-b.num_qtr<=20;
quit;

proc sort data=compa_q;
by gvkey datadate datadateq;
quit;

/* Step 2: stata codes for generating datasets used in the above SAS code: */

use compa_q.dta, clear
gen order_q_dist= num_qtr - num_qtrq
drop if missing( order_q_dist)
gen datadate_qdate=quarterly( datacqtr ,"YQ")
replace datadate_qdate=qofd(datadateq) if missing(datacqtr)
format datadate_qdate %tq
egen gvkey_datadate=group(gvkey datadate)
duplicates tag gvkey_datadate datadate_qdate, gen(tag)
tab tag
browse if tag==1
browse if tag==2
drop if missing(datacqtr)
drop tag
duplicates tag gvkey_datadate datadate_qdate, gen(tag)
tab tag
browse if tag==1
browse if gvkey_datadate==392684
drop if gvkey_datadate==392684 & tag==1 & fyr==12
drop tag
xtset gvkey_datadate datadate_qdate ,quarterly
gen ch_lg_xsgaq=ln(xsgaq)-ln(l.xsgaq)
gen ch_lg_cogsq=ln(cogsq)-ln(l.cogsq)
gen ch_lg_oc=ln(saleq-oiadpq)-ln(l.saleq-l.oiadpq)
gen ch_lg_cost=ln(cogsq+xsgaq)-ln(l.cogsq+l.xsgaq)
gen ch_lg_saleq=ln(saleq)-ln(l.saleq)
gen dec=1 if saleq-l.saleq<0
replace dec=0 if saleq-l.saleq>=0
gen dec_ch_lg_saleq=dec*ch_lg_saleq
gen dec1=1 if saleq-l.saleq<0
replace dec1=0 if saleq-l.saleq>0
saveold compa_q1.dta ,replace

/* Step 3: SAS */

data compa_q1_16;
set compa_q1;
drop gvkey_datadate;
if order_q_dist>=0 & order_q_dist<=15;
if missing(ch_lg_xsgaq) or missing(ch_lg_saleq) then delete;
run;

proc sort data=compa_q1_16;
by gvkey datadate desending order_q_dist;
quit;

proc reg data=compa_q1_16 noprint outest=b_dec_16 edf;
by gvkey datadate;
model ch_lg_xsgaq=ch_lg_saleq dec_ch_lg_saleq;
quit;

data b_dec_16(drop=_p_ _edf_);
set b_dec_16(keep=gvkey datadate ch_lg_saleq dec_ch_lg_saleq _p_ _edf_ _rsq_);
n=_p_+_edf_;
rename dec_ch_lg_saleq=b_dec;
rename ch_lg_saleq=b;
rename _rsq_=r_square;
run;

/*********************** Table 3: baseline OLS regressions **********************************/
/*******************************************************/

use compa_from_Huan_final_JAR, clear
gen year=year(datadate)
merge 1:1 gvkey datadate using b_dec_16,keepusing(b b_dec n)
drop if _m==2
drop _merge
replace b_dec=b_dec*(-1)
replace b_dec=. if n<16
drop n
drop year
rename fyear year
sort gvkey_n year
xtset gvkey_n year, yearly
egen sic3_year=group(sic3 year)
keep if year>=1978 & year<=2016 
foreach var in f_DPS b_dec lnsize_at lev q cashholding ppeta ROA ROAVol SI Persist {
winsor `var', gen(w`var') p(0.01)
}
gen neg_wSI=-wSI

set more off
unab control: wlnsize_at wlev wq wcashholding wppeta wROA wROAVol LOSS neg_wSI wPersist

reghdfe wf_DPS wb_dec `control', noabsorb cluster(gvkey_n)
keep if e(sample)
reghdfe wf_DPS wb_dec `control', a(sic3_year) cluster(gvkey_n) 

/* generating identifiers */

keep gvkey 
duplicates drop
save identifier_gvkey
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