Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: Creating a frequency table with multiple rows


From   Nick Cox <njcoxstata@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Creating a frequency table with multiple rows
Date   Wed, 14 Nov 2012 15:42:58 +0000

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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index