Migration from SPSS and publication-quality tables

[Lukas]

Hi,

sorry if this question has been asked a million times before - if so, could you kindly redirect me to wherever it has alredy been answered?

In case it hasn't: SPSS allows you to create publication level (excel) frequency tables very easily, with minimal aditional formating required, and with several horizontal variables acting as completely separate "by"-variables by which any number of vertical variables are then tabulated or summarized (see attached file for a mock-up example).

To emphasize this point: This is only about simple two-way tabulations being put in a row and then looking good in Excel to people who know nothing about statistics and don't care.

Is there any relatively efficient way to do this in Stata?

[Marcos Almeida]

Hello Lukas,

You may be interested in reading this information:

http://www.ats.ucla.edu/Stat/stata/faq/tab_nway.htm

If you want percentages by groups, you can also "play" with some sort of commands like this:

. by var1, sort: tab2 var2 var3, cell

Best,

Marcos

[Konrad Zdeb]

Hi Lukas,

The topic of creating publication quality tables in Stata is widely discussed over the Internet, for a start I would suggest that you explore:

1. Tabout - program developed precisely for that purpose (PDF)
2. Articles on exporting Stata results to Excel
3. You may also find the logout and ketchup (SSC) command very useful

Of course there is a number of other solutiones designed for the purpose of exporting specific results, like regression or tabulation (tab2xl SSC), etc. On the matter of the frequency tables, presumably you will find the fre (SSC) module useful. In effect, the module would enable you to export the obtained results to a tab delimited format, which should fully address your request of obtaining a frequency table in Excel-friendly format. Naturally, if in addition to the results you are interested in generating some fancy formatting then presumably you will end up using tabout that provides a number of useful options to generate fancy and elaborate tables.

Please also note that this board requires its users to use their full names when posting.