Date:         Fri, 8 Dec 2000 14:40:41 -0600
Reply-To:     "Schulthess, Rebecca" <schulthr@MMRF.MFLDCLIN.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Schulthess, Rebecca" <schulthr@MMRF.MFLDCLIN.EDU>
Subject:      More Merge Information
Content-Type: text/plain; charset="iso-8859-1"

One last piece of information on my merge.  Data set B has repeats of the by
variable.  So in essence this is a one to many merge.

Data set A has about 300 observations and Data set B has around 5000.  All I
want is the "added" information from B for the 300 in A.


I have two data sets, A and B.  A has the following variables: e,f,g,q.  B
has the following variables: x,y,z,w,d,q. Notice q is common to both data
sets (it will hold the same value in both data sets too).  I want to have
the observations in A have the variables (and values) of B.  How can I do
this?

Example:  Data set A: Joe Blowe Doctor 34
                Data set B: Marshfield WI 54449 Peds GR4 34
                GOAL:  Joe Blowe Doctor 34 Marshfield WI 54449 Peds GR4


Becky Schulthess
Statistical Data Analyst
Marshfield Epidemiology Research Center
x93757