Date:         Wed, 30 Sep 1998 15:50:11 -0400
Reply-To:     murphym2@NATIONWIDE.COM
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Mike Murphy <murphym2@NATIONWIDE.COM>
Subject:      Merging two datasets
Content-Type: text/plain; charset=us-ascii

I ommitted the first two lines of the code.  It should look like this:
 
Proc SQL;
Select
PROCESS.LOT,
PROCESS.OPER,
PROCESS.EQP,
RESULT.WF,
RESULT.YIELD
from WORK.PROCESS
FULL JOIN WORK.RESULT
ON PROCESS.LOT
=RESULT.LOT
;
 
Note the full join.  You can build this in the Query Window.  Go to the
command line and type "query".
---------------------- Forwarded by Michael F Murphy/Nationwide/NWIE on
9/30/1998 12:48:59 PM ---------------------------
 
 
Michael F Murphy
9/30/1998 10:26:12 AM
 
Sent by:  Michael F Murphy
 
cc:
Subject:  Merging two datasets
 
Proc SQL works well here.  Try this:
 
PROCESS.LOT,
PROCESS.OPER,
PROCESS.EQP,
RESULT.WF,
RESULT.YIELD
from WORK.PROCESS
FULL JOIN WORK.RESULT
ON PROCESS.LOT
=RESULT.LOT
;
 
Note the full join.  You can build this in the Query Window.  Go to the
command line and type "query".
---------------------- Forwarded by Michael F Murphy/Nationwide/NWIE on
9/30/1998 10:25:35 AM ---------------------------
 
 
Jeff.YUAN@ST.COM on 09/30/98 09:46:49 AM
 
Please respond to Jeff.YUAN@ST.COM
 
Sent by:  Jeff.YUAN@ST.COM
 
cc:   (bcc: Michael F Murphy/Nationwide/NWIE)
Subject:  Merging two datasets
 
 
 
 
     Hi folks,
 
     I have two data sets that are
 
     process:   lot     oper    eqp
                lot1    1010    ca01
                lot1    1020    su01
                lot1    1040    pw01
                lot2    1010    su01
                lot2    1020    ca01
 
     result:    lot     wf      yield
                lot1    a       80
                lot1    b       65
                lot2    a       90
 
     I need the final dataset to be the following:
 
     lot     oper    eqp     wf      yield
     lot1    1010    ca01     a      80
     lot1    1020    su01     a      80
     lot1    1040    pw01     a      80
     lot1    1010    ca01     b      65
     lot1    1020    su01     b      65
     lot1    1040    pw01     b      65
     lot2    1010    su01     a      90
     lot2    1020    ca01     a      90
 
     I tried different ways, but have not got what I want. Do you have a
     good way to do it?
 
     Thank you very much.
 
     Regards,
 
     Jeff