As earlier suggested, you should try -reshape long-.
Nick
[email protected]
Nikolaos A. Patsopoulos
> 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).
*
* 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/