Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Tabulation of multiple answer question


From   "Austin Nichols" <austinnichols@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Tabulation of multiple answer question
Date   Thu, 16 Mar 2006 07:42:40 -0500

The mean of an indicator variable, AKA dummy (with outcomes 1 for true
and 0 for false), is equal to the proportion of positive responses. 
So -sum A1_*- gives you a list of proportions, easily turned into
percentages.  Each proportion times N gives you the frequency.  Did
you need something more complicated?  The format you wanted is
available via the code:

foreach v of varlist A1_* {
   su `v', meanonly
   di as res "`v'" _col(12) %3.0f r(mean)*r(N) _col(20) %5.2f 100*r(mean)
}

or you could put it in a program:

cap prog drop mysum
prog def mysum
syntax varlist [if] [in]
di as res "Varname" _col(12) "Freq" _col(20) "Percent"
foreach v of varlist `varlist' {
   su `v' `if' `in', meanonly
   di as res "`v'" _col(12) %3.0f r(mean)*r(N) _col(20) %5.2f 100*r(mean)
}
end

and run, e.g.
. sysuse auto, clear
. qui tab rep78, g(A1_)
. mysum A1_*
Varname    Freq    Percent
A1_1         2      2.90
A1_2         8     11.59
A1_3        30     43.48
A1_4        18     26.09
A1_5        11     15.94

and you can add other columns in a similar fashion, e.g. number
missing, etc.  If you want to copy into another program on the Windows
OS, simply select, right click and choose Copy Table, and paste the
table into your word processor, spreadsheet, etc.

On 3/16/06, Munro, Cameron <munro@rand.org> wrote:
> I'm trying to tabulate the % of respondents to a multipunch survey question who answer affirmative to each alternative. In other words:
>
> indiv   A1_1    A1_2    A1_3
> 1       0       1       0
> 2       1       0       1
> 3       1       1       0
>
> I can -tabulate- each variable on their own, but I'm looking to have a table across all A1* variables, i.e.
>        Freq.     Percent
> A1_1       2       66.67
> A1_2       2       66.67
> A1_3       1       33.33

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2020 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index