Date:         Tue, 29 Nov 2011 14:26:10 -0600
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: Merge/coding problem using index, find,
              or some other SAS function (with have and need data)
Comments: To: Paul Miller <pjmiller_57@yahoo.com>
In-Reply-To:  <1322597770.18298.YahooMailClassic@web161604.mail.bf1.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1

Hmmm.  Are the individual pieces always whole words?  Like in your
example you had two words, one of which matched.  If that's the case,
then you could build a format list, and use SCAN to search over the
word, checking each SCANned piece to see if it mathces.  Also, if you
do indeed have first part always being the match, you can take
advantage of that, as pointed out earlier.

-Joe

On Tue, Nov 29, 2011 at 2:16 PM, Paul Miller <pjmiller_57@yahoo.com> wrote:
> Hi Joe,
>
> The first dataset has 9,110,746 rows. The second dataset has only 361 rows.
>
> Thanks,
>
> Paul
>
> --- On Tue, 11/29/11, Joe Matise <snoopy369@gmail.com> wrote:
>
>> From: Joe Matise <snoopy369@gmail.com>
>> Subject: Re: Merge/coding problem using index, find, or some other SAS function (with have and need data)
>> To: "Paul Miller" <pjmiller_57@yahoo.com>
>> Cc: SAS-L@listserv.uga.edu
>> Received: Tuesday, November 29, 2011, 2:07 PM
>> What size are the two datasets
>> respectively?
>>
>> -Joe
>>
>
>