Re: st: Count presence of item on different vars

["Nikolaos A. Patsopoulos" <npatsop@cc.uoi.gr>]

Vimalanand S. Prabhu wrote:
> Hi,
>
> This should work:
>
> gen sum=0
> forval i=1/146{
> replace sum = sum+1 if v`i'=="4500"
> }
>
> Prabhu
>
> Nikolaos A. Patsopoulos wrote:
> > Hi all,
> >
> > 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.
> >
> > How can achieve this?
> >
> >
> > Nikos
> >
> > *
> > *   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/
Sorry, but it seems I failed to explain my problem sufficiently enough.

I want to create a new var (countAppear) that is going to hold the count 
of "appear at least once" of each unique value in the varlist v6-v146. 
Var v5 is the "primary" var that contains all unique values. Hence, if a 
value is not in v6 it will not be in the others as well.  Lets say we 
have the value "text1" that appears 200 times at least once in the given 
varlist (v6-v146). So the value of  the var countAppear for text1 will 
be 200 (int).

Hope its less confusing.

Nikos

*
*   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/