Date:         Wed, 10 Apr 2002 17:36:03 -0400
Reply-To:     "Braten, Michael (Exchange)" <mbraten@BEAR.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Braten, Michael (Exchange)" <mbraten@BEAR.COM>
Subject:      Re: Merge W/O Sort
Comments: To: "abdu.elnagheeb@BANKOFAMERICA.COM"
          <abdu.elnagheeb@BANKOFAMERICA.COM>
Content-Type: text/plain

If this is all to be done on a mainframe, perhaps sort both files  by using
a SORT utility.  You can then read them into SAS and
use the dataset option SORTEDBY= variablename.   You can then do a MERGE and
not have to use SAS to sort.



> -----Original Message-----
> From: Abdu Elnagheeb [SMTP:abdu.elnagheeb@BANKOFAMERICA.COM]
> Sent: Wednesday, April 10, 2002 3:56 PM
> To:   SAS-L@LISTSERV.UGA.EDU
> Subject:      Merge W/O Sort
>
> Hello,
> I really need your help. I have two BIG data sets (17,000,000 ad
> 26,000,000)
> which I want to merge on one key variable, but I want to avoid sorting any
> of them. What is the most efficient and fastest way to do that?
> BWT, I want to do a left join on this key variable      (i.e. keep
> everyone
> in the smaller data set : Note I may have duplicate in the bigger one and
> that is fine).
>
> Please, email me.
>
> Thanks,
> abdu


***********************************************************************
Bear Stearns is not responsible for any recommendation, solicitation,
offer or agreement or any information about any transaction, customer
account or account activity contained in this communication.
***********************************************************************