Re: st: Creating a frequency table with multiple rows

[Nick Cox <njcoxstata@gmail.com>]

You may get very good answers about other programs, but I can speak for -tabm-.

-tabm- is from SSC (part of -tab_chi- package). (Recall that you are
asked to explain where user-written programs you refer to come from.)

I typically, indeed never, provide options for export to any word or
text processing program. One good reason, although not personally the
most important, is that doing it properly is a very big deal.

-tabm- does what it is intended to do, but the real problem is that
Stata at present doesn't provide direct support for tabulating many
variables simultaneously. For maximum flexibility, it's best to
-reshape- to a structure in which your data lead directly to a two-way
table. Then you can use whichever program you most like for exporting
to wherever you want.

That's what -tabm- does, and the code for -tabm- may give some ideas
on how to do it.

There arguably should be an option to -tabm- that lets you -save- the
dataset it uses directly to a .dta file, but I make no promises about
implementing it.

Nick


On Wed, Nov 14, 2012 at 3:23 PM, Meulemann  Max <mmeulemann@ethz.ch> wrote:
> Im using Stata 12 and this questions has already been asked on statalist a while ago, http://www.stata.com/statalist/archive/2007-04/msg00976.html
>
> Can someone please recommend to me a way to create a frequency table
> with multiple rows, one row per variable?
>
> I've got survey data and many of the questions were typical 5-point
> likert scales, where a particular question was asked of 6-12 different
> subquestions. Each variable corresponds to a subquestion, and is
> typically coded 1-5. I'd like to output the data like this:
>
>       1     2    3     4    5      N
> q2a   6    15   33    29   27   1459
> q2b   2    26   48    20    4   1424
>
> The solution for this was to use tabm which works fine for me personally in Stata, but I was wondering if someone has written any new programme to export the output to Word or Latex? I could not find anything so far.
>
> Best
>
> Max
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/statalist-faq/
> *   http://www.ats.ucla.edu/stat/stata/
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/