Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

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


From   Fei Deng <dengfei@bu.edu>
To   statalist <statalist@hsphsun2.harvard.edu>
Subject   Re: st: how to cope with missing value in my case
Date   Fri, 7 Oct 2005 10:11:19 -0400 (EDT)

It is quite common for STATA to give a missing value if any of you variable in the adding is missing. One way you might try it like this:

replace var1=0 if var1==.
replace var2=0 if var2==.
replace var3=0 if var3==.
gen var4=var1+var2+var3

Hope it helps.

Best,
Sophie


On Fri, 7 Oct 2005, 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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index