Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: st: Missing value= Help with gen command.


From   Nick Cox <n.j.cox@durham.ac.uk>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   RE: st: Missing value= Help with gen command.
Date   Thu, 5 May 2011 15:15:52 +0100

This sounds to me like 

gen byte dumab = (cond(missing(a), 0, a) + cond(missing(b), 0, b)) > 0 

As Rich Goldstein pointed out, (cond(missing(a), 0, a) + cond(missing(b), 0, b)) is what -egen, rowtotal()- does 

Nick 
n.j.cox@durham.ac.uk 

Oliver Jones

gen sum_of_a_b = A + B

gen byte dumab = (sum_of_a_b > 0) | (sum_of_a_b == .)

Am 05.05.2011 14:38, schrieb vikramfinavker:

> I am trying to generate new variable which is sum of A and B. i used:
>
> gen dumab=0
>
> replace dumab=1 if A+B>0
>
> however my problem is that where A has value and B has missing value (.) it
> gives me answer (.) but instead i want 1.


*
*   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/


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