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/