Re: st: Re: Can -outreg- show the coefficient in (eform-1)*100

 From lr480@columbia.edu To statalist@hsphsun2.harvard.edu Subject Re: st: Re: Can -outreg- show the coefficient in (eform-1)*100 Date Mon, 30 Jun 2003 13:01:43 -0400

```Quoting Roger Newson <roger.newson@kcl.ac.uk>:
THIS MESSAGE HAS BEEN SENT TO THE WRONG EMAIL
> At 11:07 30/06/03 -0400, Renzo Comolli wrote:
> >Dear Statalist,
> >
> >I am using -outreg- version 3.0.6  27nov00
> >Intercooled Stata 8.0 for Windows
> >
> >I need to show the regression coefficients (which Stata stores
> in e(b)) in
> >the following format
> >(exp(e(b))-1)*100
> >is it possible to do so with -outreg-? Maybe writing a line
> before -outreg-?
> >I tried to write the following lines, but the execution breaks
> at the second
> >line:
> >regress ln_wage women other_regressors
> >replace e(b)=(exp(e(b)-1)*100)
> >outreg using myregression.txt, replace se
> >
> >I imagine that this problem has been tackled many times before,
> in fact, in
> >the example here, the transformation (exp(b)-1)*100 has the
> interpretation
> >"women's wages are % lower than men's".
> >
> >I know -outreg, eform- shows the regression coeffcients b in the
> form exp(b)
> >and adjusts the standard errors correspondently, but that's one
> step short
> >of what I need.
> >
> >I looked also at -reformat- but it does not do it either. I
> can't use
> >-mktab- for unrelated reasons.
> >I haven't understood how to use -parmby-, so I would avoid if
> possible.
>
> In fact, -parmby- has an -eform- option, and could be part of
> solution. If you type
>
> gene byte baseline=1
> parmby "regress ln_wage women other_regressors baseline,noconst
> eform(GM/Ratio)",eform label norestore format(estimate min* max*
> %8.2f)
> foreach X of estimate min95 max95 {
>    replace `X'=100*(`X'-1) if parm!="baseline"
> }
> list parm label estimate min95 max95
>
> then -parmby- will call -regress-, which will display the
> coefficients,
> including the baseline male geometric mean wage, and write them
> (with their
> confidence limits and P-values) to a new data set in memory with
> 1
> observation per parameter, overwriting your original data set.
> The
> -foreach- loop converts the parameters other than the baseline
> male
> geometric mean wage to percentage differences. The -list- command
> lists the
> parameters. (The trick with -baseline-, -eform(GM/Ratio)- and
> -noconst- is
> a way of ensuring that -regress- displays the baseline geometric
> mean.)
>
> If you do not want to overwrite the existing data set in memory,
> then you
> can use the -saving- option of -parmby- instead of the
> -norestore- option,
> and save the parameters to a disk data set. You might also use
> -listtex-
> (downloadable from SSC) instead of -list-, and list the
> parameters in a
> form that can be cut and pasted into a Microsoft Word, TeX or
> HTML table.
>
> I hope this helps.
>
> Roger
>
>
> --
> Roger Newson
> Lecturer in Medical Statistics
> Department of Public Health Sciences
> King's College London
> 5th Floor, Capital House
> 42 Weston Street
> London SE1 3QD
> United Kingdom
>
> Tel: 020 7848 6648 International +44 20 7848 6648
> Fax: 020 7848 6620 International +44 20 7848 6620
>    or 020 7848 6605 International +44 20 7848 6605
> Email: roger.newson@kcl.ac.uk
> Website: http://www.kcl-phs.org.uk/rogernewson
>
> Opinions expressed are those of the author, not the institution.
>
> *
> *   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/
```