This is the solution to a different problem, how
many times do my variables equal the text "4500".
Nick
[email protected]
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/