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/
