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

From |
"Scott Merryman" <smerryman@kc.rr.com> |

To |
<statalist@hsphsun2.harvard.edu> |

Subject |
st: RE: compact output for series of one-way tabulations |

Date |
Mon, 23 May 2005 15:15:11 -0500 |

Rich, Do mean something like this: //Create 32 categorical variables clear set obs 10 forv i = 1/32 { gen byte x`i' = cond(uniform()<.3 , 1 ,cond(uniform()>.5, 2, 3)) } //Create Frequencies set obs 14 forv i = 1/32 { qui { sum x`i' if x`i' == 1 replace x`i' = r(N)/10 in 11 sum x`i' if x`i' == 2 replace x`i' = r(N)/10 in 12 sum x`i' if x`i' == 3 replace x`i' = r(N)/10 in 13 replace x`i' = r(N) in 14 } } xpose, clear var keep v11 - _var order _v v11 label var v11 "Frequency of ones" label var v12 "Frequency of twos" label var v12 "Frequency of threes" label var v13 "Total number of threes " l Scott > -----Original Message----- > From: owner-statalist@hsphsun2.harvard.edu [mailto:owner- > statalist@hsphsun2.harvard.edu] On Behalf Of Richard Goldstein > Sent: Monday, May 23, 2005 2:31 PM > To: statalist > Subject: st: compact output for series of one-way tabulations > > I have a set of 32 variables, each can have any of the categorical values. > What I want is an output that (excluding the header) is 32 rows by 5 > columns, > where the first column is the variable name and columns 2-4 are the three > categories (frequency or count) and the last column is the total number > having > one of the three categories. > > I admit that I cannot see even how to start coding this so I'm hoping that > either someone already has coded it (though I couldn't find anything) or > that > someone has a hint or two they could share. > > Thanks, > > Rich Goldstein > * * 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/

**Follow-Ups**:**Re: st: RE: compact output for series of one-way tabulations***From:*Richard Goldstein <richgold@ix.netcom.com>

**References**:**st: compact output for series of one-way tabulations***From:*Richard Goldstein <richgold@ix.netcom.com>

- Prev by Date:
**st: RE: compact output for series of one-way tabulations** - Next by Date:
**Re: st: compact output for series of one-way tabulations** - Previous by thread:
**st: compact output for series of one-way tabulations** - Next by thread:
**Re: st: RE: compact output for series of one-way tabulations** - Index(es):

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