Hi!
Let's say this is my data

Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input int price float headroom int trunk
 4099 2.5 11
 5189   2 16
 3299 2.5  9
 5104   2 16
 3667   2  7
 3984   2  8
 4389 1.5  9
 4187   2 10
13594 2.5 18
 5172   2 16
 4195   2 10
 4647   2 11
 4425 2.5 11
 6486 1.5  8
 4934 1.5  7
 5222   2 16
 4172   2  7
 6295 2.5 11
 9735 2.5 12
 6229 1.5  6
 4589   2  8
 5079 2.5  8
 8129 2.5  8
 4296 2.5 16
 4499 2.5  5
 3798 2.5 11
 5899 2.5 14
 5719   2 11
 7140 2.5 12
 6850   2 16
11995 2.5 14
end
I run two regressions:
  1. Code:
    reg price headroom i.trunk
  2. Code:
    reg price headroom i.trunk if trunk<8
I would like to export to excel the coefficient and standard error of each variable, including the factor variable of trunk.
Here's an example of what I am looking for:
headroom_coef headroom_se 6.trunk_coef 6.trunk_se 7.trunk_coef 7.trunk_se 8.trunk_coef 8.trunk_se ... 18.trunk_coef 18.trunk_se number of obs
model 1 -632.0262 1074.751 1097.974 2358.746 -662.6841 1858.073 901.5895 1682.252 9095 2099.665 31
model 2 -2029 874.6857 -299 1010 -1594 714.1778 5
Many Thanks!