Statalist The Stata Listserver


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

RE: st: Count presence of item on different vars


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: Count presence of item on different vars
Date   Mon, 9 Oct 2006 16:43:20 +0100

This is the solution to a different problem, how 
many times do my variables equal the text "4500". 

Nick 
n.j.cox@durham.ac.uk 

Vimalanand S. Prabhu
 
> This should work:
> 
> gen sum=0
> forval i=1/146{
> replace sum = sum+1 if v`i'=="4500"
> }
 
Nikolaos A. Patsopoulos wrote:
 
> > I've got a set of variables v6-v146, each one containing 
> string values 
> > (unique values ~4500):
> > 
> > v6    v7   v8   v9   v10...
> > text1   text1   text3   text45 text1...
> > text5   text2   text1   text455   text1
> > .....
> > 
> > I want to count how many times each of the values appears 
> in at least 
> > one of the v6-v146 in each row [observation], e.g. text1 appears at 
> > least once in 7365obs.

*
*   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index