Date:         Tue, 17 Mar 2009 21:41:15 +0800
Reply-To:     Eins Bernardo <einsbernardo@yahoo.com.ph>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Eins Bernardo <einsbernardo@yahoo.com.ph>
Subject:      creating a third variable
Content-Type: multipart/alternative;

I have two variables X and Y, where X have no missing values while Y have many missing values.  I want to create a third variable Z whose values are the values of Y and the missing values of Y are replace with the values of X.  The data structure looks like below:
 
X     Y        Z
a     f         f
b              b
c     g       g
d              d
e              e
 
Do you know the syntax for this?  
 
Thank you.
Eins
 
 
   


      Get your preferred Email name!
Now you can @ymail.com and @rocketmail.com. 
http://mail.promotions.yahoo.com/newdomains/ph/
[text/html]