I did a simplified example using SASHELP.CLASS:
14 /* Infoga anpassad kod före skickad kod här */
15 options msglevel=i;
16
17 data ClassPartname;
18 set sashelp.class;
19 length PartName $2;
20 PartName = substr(name,2,2);
21 keep Partname;
22 run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set WORK.CLASSPARTNAME has 19 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
23
24 proc sql;
25 create table ContainsJoin as
26 select class.*, PartName
27 from sashelp.class as class,
28 ClassPartName
29 where class.Name contains ClassPartName.PartName
30 ;
NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.
NOTE: Table WORK.CONTAINSJOIN created, with 31 rows and 6 columns.
31 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
To help you out more, please share the input data to the "join", and any LOG information that could be of interest.
/Linus
Message was edited by: Linus H
Data never sleeps