Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


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

st: Getting outreg2 to output variable labels instead of names?


From   Amar Radia <amarradia@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Getting outreg2 to output variable labels instead of names?
Date   Tue, 10 Aug 2010 13:59:09 +0300

Hi there,

I'm using Stata 10.1 and trying to use outreg2 to create an excel file
with the output of all of my regression outputs. I'm running the same
regression with a large number of different dependent variables.
However, the variable names are not meaningful, but the labels are,
and I want to output these instead of/as well as the names.

My code is as follows:

local z "q114_8	q117_b q117_g "
foreach k of local z{
reg `k' t panel interaction, robust
outreg2 using "D:\...\regressions outreg", label excel
}

q114_8, q117_b and q117_g are my variables (there are actually a lot
more but ive just put a few here)

However my output in excel appears like this, with the variable names
instead of labels:
  (1) (2) (3) VARIABLES q114_8 q117_b q117_g         t 0.00284 -0.0441
-0.0543* (0.0200) (0.0299) (0.0311) panel 0.0520* 54.68*** 52.89***
(0.0282) (1.518) (1.533) interaction -0.000142 -4.547** -5.049**
(0.0395) (2.128) (2.147) Constant 0.108*** 0.485*** 0.527*** (0.0148)
(0.0214) (0.0223) Observations 4,432 3,912 3,881 R-squared 0.001 0.348
0.332

Any suggestions?

Thanks in advance
*
*   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index