| Date: | Wed, 30 May 2001 11:26:43 -0400 |
|---|
| Reply-To: | Bob Burnham <robert.a.burnham@DARTMOUTH.EDU> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Bob Burnham <robert.a.burnham@DARTMOUTH.EDU> |
|---|
| Organization: | Dartmouth College |
|---|
| Subject: | Re: merge question |
|---|
Hi Eileen,
You might have more luck using PROC SQL for this type of merge. Try
something like this:
proc sql noprint;
create table dataset3 as
select a.ptid, a.md_last, b.prov_id
from dataset1 a, dataset2 b
where a.md_last = b.md_last
order by a.md_last, a.ptid;
Hope this helps.
--
Bob Burnham
robert.a.burnham@dartmouth.edu
http://www.dartmouth.edu/~bburnham
"Eileen Farrelly" <Eileen_Farrelly@PCIT.COM> wrote in message
news:OFFF0883D5.E819B1FD-ON85256A5C.00512789@pcit.com...
> It fails where more than one patient lists the same MD_Last name. With the
> above example it is doing this for Adams:
>
> 001 Adams 1234
> 004 Adams 9001
> 004 Adams 3425
| 
