Statalist


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

st: RE: Creating Tables


From   "Martin Weiss" <[email protected]>
To   <[email protected]>
Subject   st: RE: Creating Tables
Date   Mon, 12 Jan 2009 16:21:51 +0100

Line for the server...

Your problem strikes me as similar to
http://www.stata.com/statalist/archive/2009-01/msg00374.html
Lines 99 to 154 in ineqrbd.ado show you how the table is constructed, as far
as I can tell.
Put those into a matrix and use -ssc d mat2txt-


HTH
Martin


-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Ana R. Rios
Sent: Monday, January 12, 2009 4:10 PM
To: [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"
              r(cv_Z4) : "1.856268010856377"
              r(sd_Z4) : ".0329355355049573"
            r(mean_Z4) : ".0177428772743666"
              r(sf_Z3) : "-.0437961986553662"
              r(cv_Z3) : "-.6496454738603447"
              r(sd_Z3) : ".5044808392506561"
            r(mean_Z3) : "-.776547916593513"
              r(sf_Z2) : ".0790708585726617"
              r(cv_Z2) : ".3317180771607708"
              r(sd_Z2) : ".6183993788812"
            r(mean_Z2) : "1.864231772275365"
              r(sf_Z1) : ".1570092491099513"
              r(cv_Z1) : ".577786946494659"
              r(sd_Z1) : ".286828667617012"
            r(mean_Z1) : ".4964263546574661"
              r(sf_Z0) : ".7995964641666858"
              r(cv_Z0) : "-34099290428909.52"
              r(sd_Z0) : ".6383929043798791"
            r(mean_Z0) : "-1.87215891108e-14"
             r(cv_tot) : ".2154372178269523"
             r(sd_tot) : ".7139250469472358"
           r(mean_tot) : "3.313842678383865"
              r(total) : " loginhr"
              r(xvars) : "aedu edad edad2 exper"
               r(yvar) : "loginhr"
            r(varlist) : "loginhr aedu edad edad2 exper"

Thank you for your time.

Regards,

Ana Rios   



      

*
*   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