Re: st: how to cope with missing value in my case

[Richard Goldstein <richgold@ix.netcom.com>]

use egen var4=rowtotal(var1 var2 var3)

Rich

Jia Xiangping wrote:

> Dear all,
>
> I came across a problem about missing value. For example:(var1 var2
> var3 are categorical variables)
> index  var1   var 2   var3   var 4
>   1        .       1        1
>   2        1      1        .
>   3        .       1       1
>
> Now I want to get the frequecy of each observation and generate a
> variable var4 which is the sum of frequency. So when I run -gen
> var4=var1+var2+var3-, I should have got 2,2,1. But I got three missing
> value. I'd like to say this problem is quite typical for missing value
> topic. I tried to find answer online. But no clue now. Does anybody
> can help me? Thanks
>
> --
> Xiangping JIA
>
> *
> *   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/