Create generic regression table using built-in commands.

regression-table.do

// Demo code for creating simple regression table

sysuse auto.dta, clear


  // Run regressions
    reg price weight
      su price if e(sample)
      estadd scalar mean = r(mean)
      est sto reg1

    reg turn weight price
      est sto reg2

    reg turn weight price i.foreign
      est sto reg3

    reg headroom weight turn
      est sto reg4

  // Set up regression table
  est tab reg1 reg2 reg3 reg4 ///
    , drop(_cons) b(%9.3fc) se(%9.3fc) p(%9.3fc) stfmt(%9.2fc) ///
      varl stats(N r2 mean) vsquish

  // Output using putexcel
  cap putexcel close
  cap !rm "/users/bbdaniels/desktop/results.xlsx"
  putexcel set "/users/bbdaniels/desktop/results.xlsx"
    putexcel A1=etable , nformat(text)

// End of dofile