Christer Thrane wrote:
I have two income measures, X and Y. I want to create a variable, Z, that is
equal to X for those obs where X>=Y and equal to Y for those obs where Y>X.
Like this:
id X Y Z
1 12 11 12
2 10 10 10
3 10 12 12
Is there a simple way?
--------------------------------------------------------------------------------
You can use -cond()-. You can nest -cond()-s to handle missing values.
See also -egen-.
Joseph Coveney
clear *
input byte id byte X byte Y byte Z
1 12 11 12
2 10 10 10
3 10 12 12
end
assert !missing(X) & !missing(Y)
generate byte Zstar = cond((X >= Y), X, Y) // Here
assert Zstar == Z
exit
*
* 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/
