egen command?

[ajay pasi]

Can anyone suggest me to do this:

I need to generate a dummy var3 using var1 and var2.

Condition: v3=1 if (var1>0 & var1<. ) & (var2>0 & var2<.)

v3 =0 if out of var1 and var2, exactly one has nonzero (missing value)

thanks

[Hemanshu Kumar]

gen byte var3 = cond(var1>0 & var2>0 & !missing(var1) & !missing(var2), 1, cond((var1>0 & missing(var2)) | (var2>0 & missing(var1)),0,.))

[ajay pasi]

Thanks Hemanshu.

[Nick Cox]

Please cross-reference your other thread when asking two or more versions of the same question. In fact, please ask each question just once.

[ajay pasi]

My apologies nick, just started using dataex, so posted twice ( one without, and the other with dataex).