Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Creating Tables


From   John Ayers <[email protected]>
To   [email protected]
Subject   Re: st: Creating Tables
Date   Tue, 13 Jan 2009 12:15:17 -0500

I find estout helpful for 90% of scenarios, and possibly yours. See
http://repec.org/bocode/e/estout/ , john
On Tue, Jan 13, 2009 at 4:27 AM, Stephen P. Jenkins
<[email protected]> wrote:
> -----------------------------
>
> Date: Mon, 12 Jan 2009 07:10:12 -0800 (PST)
> From: "Ana R. Rios" <[email protected]>
> Subject: st: Creating Tables
>
> Stata users,
>
> I would like to create tables with results estimated using ineqrbd.  I
> am particularly interested in the column "100*s_f" for "residual" and
> "aedu".  Is there any way to do this without manipulating the
> following output in Excel?  Any help is greatly appreciated.
>
> . ineqrbd loginhr aedu edad edad2 exper [aweight=weight] if
> muestraok==1, noreg
>
> Regression-based decomposition of inequality in  loginhr
> -
> ----------------------------------------------------------------------
> -----
> Decomp.  |     100*s_f        S_f     100*m_f/m      CV_f
> CV_f/CV(total)
> -
> ---------+------------------------------------------------------------
> -----
> residual |     79.9596      0.1723     -0.0000   -3.41e+13   -1.58e+14
> aedu     |     15.7009      0.0338     14.9804      0.5778      2.6819
> edad     |      7.9071      0.0170     56.2559      0.3317      1.5397
> edad2    |     -4.3796     -0.0094    -23.4335     -0.6496     -3.0155
> exper    |      0.8120      0.0017      0.5354      1.8563      8.6163
> -
> ---------+------------------------------------------------------------
> -----
> Total    |    100.0000      0.2154    100.0000      0.2154      1.0000
> -
> ----------------------------------------------------------------------
> -----
> Note: proportionate contribution of composite var f to inequality of
> Total,
>      s_f = rho_f*sd(f)/sd(Total). S_f = s_f*CV(Total).
>      m_f = mean(f). sd(f) = std.dev. of f. CV_f = sd(f)/m_f.
>      Total = loginhr
>
> . return list
>
> macros:
>              r(sf_Z4) : ".0081196268060714"
> <snip>  ....
>            r(varlist) : "loginhr aedu edad edad2 exper"
>
> Thank you for your time.
>
> Regards,
>
> Ana Rios
> ====================
>
> -ineqrbd-, for regression-based inequality decomposition,  is on SSC
> (authors: Carlo Fiorio and me).  Statalist etiquette (See FAQ) tells
> users to report this sort of information when you post a question.
>
> -ineqrbd- is an rclass program, so doesn't easily yield to the various
> output processing programs available (of which -estout- and its
> siblings are my personal favourites).
>
> So, I recommend using the -file- command combined with -forvalues-
> loops to process the results held in the r(.) macros and to write out
> tab-limited output that you can then easily handle.
>
> For an example, look at the penultimate case study in the
> SPJ-workshop-1.do file in my materials from "Workshops on 'Audit
> trails, reproducibility and output processing' and 'Effective use of
> Stata graphics'", downloadable from
> http://www.iser.essex.ac.uk/files/teaching/stephenj/docs/ISER-Stata-wo
> rkshops-Jenkins.zip
>
> This is perhaps a case of using a hammer to crack a nut, but the
> 'tricks' can be applied in other cases.
>
> A short-cut alternative is to do what you're presumably doing -- using
> cut/paste from the output window to paste into Excel and then process
>
>
> Stephen
> -------------------------------------------------------------
> Professor Stephen P. Jenkins <[email protected]>
> Director, Institute for Social and Economic Research
> University of Essex, Colchester CO4 3SQ, U.K.
> Tel: +44 1206 873374.  Fax: +44 1206 873151.
> http://www.iser.essex.ac.uk
> Survival Analysis using Stata:
> http://www.iser.essex.ac.uk/iser/teaching/module-ec968
> Downloadable papers and software: http://ideas.repec.org/e/pje7.html
>
> Learn about the UK's new household panel survey, "Understanding
> Society": http://www.understandingsociety.org.uk/
>
>
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index