LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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.

Back to: Top of message | Previous page | Main SAS-L page