Esttab and recoded categorical variables

[Luke Brown]

Good morning users,
I would like to report my results in my paper, however when I use the command esttab I obtain the following result. I was wondering if it is possible to have a better output for categorical variables (age, race and education are recoded so that age1 age2,..,race1,race2,...,educ1,educ2, have different labels but they are not reported in this table). In addition I would like to supress the first value of comparison to have a better looking table.

Thank you so much for your help

----------------------------------------------------------------------------
                      (1)             (2)             (3)             (4)   
                riskavers       nofinrisk      medfinrisk      yesfinrisk   
----------------------------------------------------------------------------
main                                                                        
hhsex             -0.0769***        0.255***       -0.316***       -0.180*  
                  (-9.61)          (6.82)         (-9.14)         (-1.99)   

1.Age                   0               0               0               0   
                      (.)             (.)             (.)             (.)   

2.Age             -0.0828***        0.442***       -0.297***       -0.328** 
                  (-6.25)          (7.28)         (-5.22)         (-2.92)   

3.Age              -0.148***        0.712***       -0.475***       -0.686***
                 (-11.85)         (11.98)         (-8.58)         (-6.22)   

4.Age              -0.204***        0.937***       -0.630***       -0.991***
                 (-16.13)         (15.17)        (-11.11)         (-8.62)   

5.Age              -0.294***        1.400***       -0.961***       -1.362***
                 (-22.05)         (20.94)        (-15.67)        (-10.47)   

6.Age              -0.398***        1.994***       -1.533***       -1.313***
                 (-28.84)         (28.52)        (-23.85)         (-9.61)   

1.Educ                  0               0               0               0   
                      (.)             (.)             (.)             (.)   

2.Educ              0.113***       -0.530***        0.632***        0.247   
                   (5.37)         (-4.56)          (5.55)          (0.82)   

3.Educ              0.258***       -1.073***        1.158***        0.555   
                  (11.79)         (-9.06)         (10.02)          (1.81)   

4.Educ              0.333***       -1.583***        1.620***        0.381   
                  (15.30)        (-13.25)         (13.91)          (1.24)   

1.Race                  0               0               0               0   
                      (.)             (.)             (.)             (.)   

2.Race            -0.0285*          0.179***       -0.279***        0.451***
                  (-2.54)          (3.62)         (-6.07)          (4.27)   

3.Race             -0.121***        0.674***       -0.728***        0.479***
                  (-9.25)         (12.38)        (-13.98)          (4.22)   

4.Race            -0.0583***        0.431***       -0.419***        0.192   
                  (-3.92)          (5.75)         (-6.38)          (1.47)   

logincome          0.0323***       -0.326***        0.107***        0.118***
                  (10.30)        (-15.32)          (5.68)          (3.53)   

networth           0.0480***       -0.235***        0.186***        0.177***
                  (24.43)        (-21.57)         (18.73)          (7.24)   

crisis            -0.0438***        0.221***       -0.155***       -0.149** 
                  (-7.83)          (7.44)         (-5.67)         (-2.70)   

_cons               0.826***        5.360***       -2.922***       -6.105***
                  (23.84)         (23.09)        (-14.15)        (-15.46)   
----------------------------------------------------------------------------
lnsig2u                                                                     
_cons                              -5.749          -11.39          -3.938   
                                  (-0.69)         (-0.01)         (-0.91)   
----------------------------------------------------------------------------
N                   28816           28816           28816           28816

[Daniel Bela]

Hi Luke,

you provide few information about your problem; please review the FAQ (also linked from the top of each page) on how to post good (i.e. easy to answer) questions (especially: data examples, and posting the exact commands you entered into Stata).

Thus said, you probably should have a look at the very exhaustive online documentation for esttab. From the little information you provide, I guess that it is esttab's options label and nobaselevels you're looking for.

Kind regards
Bela