Category Archives: Stata

Sample code for “outreg” command in Stata

outreg is very powerful and time-saving command in Stata. The following code generates a ready-for-use results table:

Please change x1, x2, x3 and x4 to variables that you want to report.

Posted in Stata | Leave a comment

A loop of cross-sectional regressions for calculating abnormal accruals in Stata

I write a loop of cross-sectional regressions for calculating abnormal accruals. This program can be easily modified and replaced with Jones, modified Jones, or Dechow and Dichev model. I add detailed comments in the program to help you prepare the input … Continue reading

Posted in Stata | 5 Comments

Rolling-window computation in SAS and Stata

SASers often find proc expand plus transformout very useful for rolling-window (or moving-window) computation. Stataers may wonder if there is a counter party in Stata. The answer is “yes”. The command in Stata is rolling. See the manual below: http://www.stata.com/manuals13/tsrolling.pdf The … Continue reading

Posted in Learning Resources, SAS, Stata | Leave a comment

Regression with a large dummy-variable set (e.g., firm and year fixed effects) in Stata

I run a regression in Stata with a Compustat dataset that contains fyear and gvkey. I want to add firm and year fixed effects, so I type the following command: regress DV IV i.fyear i.gvkey But Stata returns the error … Continue reading

Posted in Stata | Leave a comment

Handy Stata command to create Fama-French industry classifications based on SIC codes

See ffind written by Judson Caskey. Here is his website: https://sites.google.com/site/judsoncaskey/data The syntax is as follows (download Help file here): ffind sic, newvar(ffi) type(30) type(30) means Fama_French 30 industries classification. Type must be 5, 10, 12, 17, 30, 38, 48 or … Continue reading

Posted in Stata | 15 Comments

Fuzzy match in Stata

Nice article. http://ebp-projects.isr.umich.edu/NCRN/papers/wasi_flaaen_statarecordlinkageutilities.pdf Author’s website: http://www-personal.umich.edu/~nwasi/programs.html For installation, type the following command in Stata: net from http://www-personal.umich.edu/~nwasi/programs net install stnd_compname.pkg

Posted in Stata | Leave a comment

Calculate CFO tenure with Execucomp in Stata

Nice article and nice blog! Happy to find that someone built a similar blog. https://robsonglasscock.wordpress.com/2014/04/01/determining-cfo-tenure-with-execucomp-data/

Posted in Stata | Leave a comment

SAS and Stata—Which is better for archival accounting research?

The short answer is: we need both. When we do archival accounting research, we often need to merge data across various databases, such as COMPUSTAT, CRSP, and EXECUCOMP. Stata can by no means beat SAS in this regard. SAS supports … Continue reading

Posted in Learning Resources, SAS, Stata | 1 Comment