Two super important user written codes for STATA that you may not be aware of but will make your life A LOT EASIER: outreg2 and logout outreg2: exports your regressions to journal ready tables in text, excel, latex, or other formats. It has a lot of options such as controlling formatting, adding in stars, number of decimal places, etc.The command outreg2 gives you the type of presentation you see in academic papers. It is important to notice that outreg2 is not a Stata command, it is a user-written procedure, and you need to install it by typing (only the first time) ssc install outreg2 . Follow this example (letters in italics you type) use
Stata Test Procedure in Stata. In this section, we show you how to analyse your data using a Pearson's correlation in Stata when the four assumptions in the previous section, Assumptions, have not been violated.You can carry out a Pearson's correlation using code or Stata's graphical user interface (GUI).After you have carried out your analysis, we show you how to interpret your results.In Excel, open the file created by outreg and follow the default choices in the Text Import Wizard (note that when loading the output into a spreadsheet, the parentheses around the t statistics may convert to negative numbers). Other word processors and spreadsheet software should be similar.I'm having trouble getting outreg2 to post tables to word. I would like to get nice looking tables into word but it seems like given it's name, outreg2 is a bit more suited towards outputting regression results. I've briefly tried esttab and estout with poor results.
The above gets it into Excel, but I don't know how to append tables to the same Excel file (like outreg2 would). Also, I don't know how to change the format of it. The 2nd way would be to use frmttable (this is probably the way I would go). See here for an example similar to your ownTwo STATA commands are particularly useful: tabulate and summarize. Summary Self Assessment Regression with Categorical Predictors. To obtain summary statistics we can simply type in the command line summarize and hit. Step 3: Request selective statistics and output results to SAS dataset. In Stata, both estout and outreg2 can write to Excel formats, as does xml_tab by Zurab Sajaia and Michael Lokshin. Until recently, it was not straightforward to print information into Excel, and each of these softwares dealt with interoperability hurdles in different ways.