# RE: st: combining two variables

 From "Moore, Jesse" To Subject RE: st: combining two variables Date Wed, 7 Mar 2007 14:02:52 -0500

```Will this work for more than two variables?  I'm working with a similar
situation, but with 7 variables.

Thanks,

JSM

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Nick Cox
Sent: Wednesday, March 07, 2007 12:15
To: statalist@hsphsun2.harvard.edu
Subject: RE: st: combining two variables

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
n.j.cox@durham.ac.uk

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

Confidentiality Notice:
This message, and any attachments, may contain information that is confidential, privileged, and/or protected from disclosure under state and federal laws that deal with the privacy and security of medical information. If you received this message in error or through inappropriate means, please reply to this message to notify the Sender that the message was received by you in error, and then permanently delete this message from all storage media, without forwarding or retaining a copy.

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