Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Nick Cox <n.j.cox@durham.ac.uk> |
To | "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu> |
Subject | st: RE: new var from an old one if a third var has a certain value |
Date | Mon, 24 Jan 2011 18:33:47 +0000 |
There is a very direct answer: . gen var3 = var1 if var2 == whatever You are also not far away from . gen var3 = cond(var2 == whatever, var1, .) Using -cond()- has no advantages for this problem -- except perhaps that some people might like it being explicit that missing is the value supplied when var2 != whatever. However, watch out. Tests for equality are only reliable when <whatever> is an integer (or a string). Nick n.j.cox@durham.ac.uk Caterina Astarita I need to generate a new variable that have the values of an old one if a third variable has a certain value, othewise a missing value. Let's say we have two variables var1 and var2, I would like to generate a var3 that has the value of var1 but only if var2 has a certain value otherwise not. * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/