Date:         Tue, 19 Nov 2002 15:30:04 -0500
Reply-To:     Charles Patridge <Charles_S_Patridge@PRODIGY.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Charles Patridge <Charles_S_Patridge@PRODIGY.NET>
Subject:      Re: many to many merge
Comments: To: siva_ganesh@HOTMAIL.COM

Dear Ganesh,

Before answering your question, you need to be specific as to what you want
the final results (merged) to look like.

1.  Are you trying to append X with Y?
2.  If you are trying to actually merge X with Y, on what basis should the
records be merged on?  You sort by "name" and "num" but only merge
on "name".  What do you want to happen when "num" matches or does not match
between both files?

If you want to know more about "merge", may I suggest you look at

TIP00235 - TS-644 Everything you want to know about MERGE but were afraid
to ask by SAS Institute Inc. Technical Support

http://www.sconsig.com/sastips/tip00235.htm

Sorry, but I would need more info from you to provide any further
assistance.

HTH,
Charles Patridge
Email: Charles_S_Patridge@prodigy.net