Some very complicated solutions here!
Consider:
gen newvar = max(var1, var2) if missing(var1, var2)
Logic:
If just one of var1 or var2 is missing,
then -missing()- will return true.
In that case, max(var1, var2) will
return the non-missing value in question.
If both are missing, then you get missing returned,
but that is fair enough.
If neither is missing, missing is returned.
Nick
[email protected]
Paswel Phiri Marenya
> What to me is easier is something like:
>
> gen var3 = var2
> then replace var3=var1 in 4/5 and so on...although with a
> long data set it
> may be tedious perhaps.
> regrads
> PPm
>
> > Thank you to everyone who answered my last question on
> > creating a variable corresponding to the row number.
> >
> > Now I have a question about combining the data from two
> > variables (in the same data set) into one variable. I want to
> > combine the variables in such a way that the data from one
> > variable can replace the missing values from the other. I have
> > created an example of what I am looking for below:
> >
> >
> > Have: Want:
> > var1 var2 newvar
> > . 2 2
> > . 8 8
> > . 0 0
> > 7 . 7
> > 3 . 3
> > . . .
> >
> > Any thoughts on how to do this?
*
* 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/
