Sometimes you may not want to report unimportant independent variables. If you include interaction terms in regressions like this:. By the way, this is the highly recommended way to include interaction terms in regressions. This option will report two selected statistics usually b and the other one in two columns, rather than putting one e. This option will report variable labels, rather than variable names in the generated table.
Sometimes variable labels is easier to understand than variable names. In this case, you can set labels for independent variables and turn on this option. The complete help file for this command can be found here. There is a similar command outreg2 that you can check. But I find outreg is good enough and works really well for me. It provides regression output in spread-sheet readable files.
It was developed by John Luke Gallup, and the corresponding help file has many pages which you are encouraged to read at least once in your lifetime!
In a nutshell, you just need to run the regression s you want and type outreg using filename. What you get is a file called filename with all the output presented in publication style that is, with the standard errors below the coefficients, etc.
As explained in the help file, outreg rewards the use of variable labels: the names of the variables will be replaced by their labels. The investment of creating once the labels is has a great return if you need to do many versions of your regressions. Even when showing your results to a co-author, it's always nicer and faster to read in a table "Age of the Household Head Square" rather than aghhhdsq : This is also very useful to do your nice tables in a few minutes as described below.
With a combination of outreg and an empty Excel spreadsheet you can run a few regressions and have a nicely formatted table in a couple of minutes. With just a bit more of sofistication but not much - I'd appreciate help in this area it can happen literally in just a few seconds.
What I do with outreg output files is the following: the first time, just double click on it - Windows if you are using windows will ask you which program you want to open the file with. Select Excel if you are using excel and select "always use this program". Excel will open the tab delimited file into a non formatted spreadsheet, and next time you double click on a ".
This is much faster than taking a log file and cutting and pasting, but it will only save you a few seconds going to Excel, opening the file and going through the translation process. Most important, your table is still quite ugly My solution is quite simple. What I have is a very simple excel file that I use as a "shell" - the file is empty but formatted say, the first column and first two rows are bold, all the cells are justified - centered - etc.
Nothing to write home about, but still quite useful I think.
0コメント