Thanks, Joseph. That's exactly what I have figured out!
Ying
> Ying Wang wrote:
>
> I transfered my data from long to wide, and thus have continuous variables
> like obrum1 through obrum10. I want to add the values of each obrum*
> variable together. I am trying to use the command egen
> obrumtot=rowtotal(obrum1-obrum10).
>
> However, it keeps giving me an error message "type mismatch". I looked
> into those 10 vars. The storage type of obrum1 and obrum2 is int., and
> that of the rest is byte. Does this have some say on the error message?
>
> I also tried to use recast to set the int. to byte., but it didn't seem to
> be working.
>
> I have done some research and didn't have any luck. Can anybody kindly
> suggest me how to deal with this?
>
> --------------------------------------------------------------------------------
>
> -egen . . . rowtotal()- doesn't mind a mixture of int and byte (see
> below),
> so that isn't your problem. You use the variable list shorthand,
> obrum1-obrum10. This will include all variables between obrum1 and
> obrum10;
> check to make sure that you don't have a string variable in the middle of
> that list (see below). Consider using obrum* instead for the varlist
> shorthand: -egen int obrumtot = rowtotal(obrum*).
>
> Joseph Coveney
>
> . clear
>
> . set more off
>
> . set seed `=date("2006-01-19", "ymd")'
>
> . set obs 10
> obs was 0, now 10
>
> . forvalues i = 1/2 {
> 2. generate int var`i' = floor(1000 * uniform())
> 3. }
>
> . forvalues i = 3/10 {
> 2. generate byte var`i' = 100 * uniform()
> 3. }
>
> . egen vartot = rowtotal(var1-var10)
>
> . set linesize 72
>
> . slist in 1/2, noobs // No problem
>
> var1 var2 var3 var4 var5 var6 var7 var8 var9 var10 vartot
> 221 291 80 70 34 17 31 86 13 8 851
> 809 837 44 31 4 86 36 50 76 20 1993
>
> . drop vartot
>
> . generate str itsme = "Hi there!"
>
> . order var1 itsme
>
> . capture noisily egen vartot = rowtotal(var1-var10) // Problem here
> type mismatch
>
> . egen vartot = rowtotal(var*)
>
> . slist in 1/2, noobs // No problem
>
> var1 itsme var2 var3 var4 var5 var6 var7 var8 var9 var10
> 221 Hi there! 291 80 70 34 17 31 86 13 8
> 809 Hi there! 837 44 31 4 86 36 50 76 20
>
> vartot
> 851
> 1993
>
> *
> * 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/
>
*
* 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/
