Question about tables and display

[Soumya Upadhyay]

Is there a way to easily transport a Stata table into MS Word. Sometimes when the numbers are large , for example, per capita income, the regression output displays those numbers in a different way. In my case I got 1.20e-06. Is there a way to write this number in a more simplified way.

[Jesse Wursten]

This really depends on the command that produces the table and whether it allows you to specify the format of the output.

[William Lisowski]

The "simplified" version of 1.20e-06 is .00000120 which is not a lot better looking. Your easiest solution might be to re-express PCI in a different unit. For example, if you are measuring Albanian PCI in (constant) local currency between 1990 (80,000 leks) and 2015 (260,000 leks) [World Bank data] you might instead measure PCI in 100,000 lek units, from 0.8 in 1990 to 2.6 in 2015. Then your coefficient estimate would be 0.120.

My apologies to any Albanian or finance expert if my 10 minutes with Google, Wikipedia, and World Bank data has misrepresented Albanian economic data or performance. I needed an example of a country whose currency units led to a fairly large PCI and Albania was the first suitable example I found.

[Jorrit Gosens]

You mean output to word with esttab/estout? That has an option, b(), for display format for the point estimate. See the help file here: http://repec.org/bocode/e/estout/hlp_esttab.html
Also links to a number of formatting possibilities

[Soumya Upadhyay]

Thanks Jorrit. I am using svy:regress commands because I have survey data. I want my tables to show beta and standard errors in the first column with stars for significances. In the second column I want the Confidence intervals to be displayed. I tried the following:

esttab, se star brackets

But it doesnt include the confidence intervals. How can I do that? Also, is there a better command than esttab that I could use. I am looking for a way to get the tables in excel and esttab doesnt do it.

[Jorrit Gosens]

Well, it seems you understand how to use the options in esttab. The link that I gave has info on a umber of other options you can choose form, including outputting confidence intervals.
As for output to excel, estout is the package to use. Its very similar in its use to esttab, and also linked to at the top of the page I gave the link for.