Date:         Tue, 23 Sep 2003 19:52:22 -0500
Reply-To:     "Kundu, Om (US - Boston)" <omkundu@DELOITTE.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Kundu, Om (US - Boston)" <omkundu@DELOITTE.COM>
Subject:      Qn: How to Merge Data-sets based on Matches in Variable substring
              s ?

I'm trying to merge 2 datasets based upon whether a substring of a
text-variable in one dataset occurs in a text-variable of the other dataset.
Upon invoking the index function for performing a SQL inner-join (per code
below), SAS is unable to complete it and reports that the query involves a
Cartesian-product that is not optimized:

PROC SQL;
CREATE TABLE sasdata.t3 AS
  SELECT *
        FROM sasdata.t1 T1, sasdata.t2 T2
      WHERE INDEX(T1.key1, T2.key2)>0;
RUN;

Any quick suggestions to (a)work around this OR (b)alternative ways to
accomplish this Merge would be greatly appreciated.

Thanks in advance!
~Om
This message (including any attachments) contains confidential information
intended for a specific individual and purpose, and is protected by law.  If
you are not the intended recipient, you should delete this message.  Any
disclosure, copying, or distribution of this message, or the taking of any
action based on it, is strictly prohibited.