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
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
Statistical Data Analyst
Marshfield Epidemiology Research Center