Thanks @Astounding As you mentioned there is space after 'DOUBLEBED'. I changed the code to: Proc Sql;
Create Table t3 as select distinct
A.*
from t1 A, t2 B
where trim(A.Attribute) contains trim(B.Attribute)
order by A.Location, A.Number;
Quit; It returns correct table. Thanks!
... View more
