gen c = a
replace c = b if c==.
-----Original Message-----
From: SamL [mailto:[email protected]]
Sent: maandag 18 oktober 2004 6:06
To: Stata Listserve
Cc: [email protected]
Subject: st: Using 2 vars to make 1 in presence of missing
I have two variables, a and b, and 1.5 datasets, A and B. All cases in B are in A, but some cases
in A are not in B. I want to merge the two datasets, matching on the id.
Variable a is missing for some cases in A, but the same variable has valid
values for some of those cases in B (as b).
I have tried several approaches. What I want is:
do if (a ne .)
compute c=a
else if (b ne .)
compute c=b
else
compute c=.
end if
*
* 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/
