st: RE: RE: 2 -estout- queries

["Newson, Roger B" <r.newson@imperial.ac.uk>]

Thanks to Ben for his very helpful reply to my queries. (I had noticed
the -lhs()- suboption, but had not succeeded in making it work.)

One more query. Does -estout- have any way of saving, in its output
spreadsheet, the variable labels of the X-variables (or even the
Y-vatiables)? This capability would be similar to the -label- and
-ylabel- options of -parmest-.  I am aware of the -varlabels()- option
of -estout-, but this seems to require the user to input the variable
labels of the X-variables manually one by one. (Ideally, I would like to
be able to use -descsave- and -factext- to reconstruct factor values in
a dataset created by -insheet-ing the output spreadsheet, and then to
use these with -eclplot-, in the manner of Newson (2003).)

Thanks in advance

Roger

References

Newson R. Confidence intervals and p-values for delivery to the end
user. The Stata Journal 2003; 3(3): 245-269. Pre-publication draft
downloadable from
http://www.imperial.ac.uk/nhli/r.newson/

Roger Newson
Lecturer in Medical Statistics
POSTAL ADDRESS:
Respiratory Epidemiology and Public Health Group
National Heart and Lung Institute at Imperial College London
St Mary's Campus
Norfolk Place
London W2 1PG
STREET ADDRESS:
Respiratory Epidemiology and Public Health Group
National Heart and Lung Institute at Imperial College London
47 Praed Street
Paddington
London W1 1NR
TELEPHONE: (+44) 020 7594 0939
FAX: (+44) 020 7594 0942
EMAIL: r.newson@imperial.ac.uk
WEBSITE: http://www.imperial.ac.uk/nhli/r.newson/
Opinions expressed are those of the author, not of the institution.


-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Ben Jann
Sent: 18 March 2006 09:40
To: statalist@hsphsun2.harvard.edu
Subject: st: RE: 2 -estout- queries

Roger asks:
> 1. Is there a way of suppressing the table heading [in estout]?

The table header is composed of several elements (model labels and
column labels, possibly equation labels and model groups labels). Each
element can be suppressed manually using the -none- label suboption.
Example:

    . sysuse auto, clear
    (1978 Automobile Data)

    . egen c_mpg = cut(mpg), group(7)

    . ta c_mpg, nofreq gen(c_)

    . qui regress weight c_1-c_6, noconst

    . estout, cells("b ci_l ci_u") mlabels(, none) collabels(, none)

    c_1     4103    3499.693        4706.307
    c_2     3536.25 2861.732        4210.768
    c_3     3323.333        2687.392        3959.275
    c_4     3272.727        2697.496        3847.958
    c_5     2848.462        2319.326        3377.597
    c_6     2336.667        1785.925        2887.408

Furthermore:
> 2. Is there a way of inserting text into the blank cell above the
column
> of X-variable names?

There is a -lhs()- label suboption. Example:

    . estout, cells("b ci_l ci_u") collabels(, lhs(xvar))

            .
    xvar    b       min95   max95
    c_1     4103    3499.693        4706.307
    c_2     3536.25 2861.732        4210.768
    c_3     3323.333        2687.392        3959.275
    c_4     3272.727        2697.496        3847.958
    c_5     2848.462        2319.326        3377.597
    c_6     2336.667        1785.925        2887.408

ben

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/