This should work:
egen newvar=rowtotal(var1 var2)
replace newvar=. if var1==. & var2==.
Regards,
Ricardo Sierra
On 3/7/07, [email protected] <[email protected]> wrote:
Thank you to everyone who answered my last question on
creating a variable corresponding to the row number.
Now I have a question about combining the data from two
variables (in the same data set) into one variable. I want to
combine the variables in such a way that the data from one
variable can replace the missing values from the other. I have
created an example of what I am looking for below:
Have: Want:
var1 var2 newvar
. 2 2
. 8 8
. 0 0
7 . 7
3 . 3
. . .
Any thoughts on how to do this?
Thanks
Eleanor Friedman
*
* 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/
