I'm new on this forum and quite new with SAS coding too, so thanks for your help and your kind understanding of my "ignorance".
I am trying to link table 1 (1 column called client_name) to table 2 (1 column called advertiser_name) where table 2 contains a list of 5000 terms that could (or could not) be embedded into any of the client_names in table 1.
Here is an example
Walt Disney Corporation
.com Amazon account
The output i need is a 3rd table that would look like this
Walt Disney Corporation Disney
Ebay Inc Ebay
.com Amazon account Amazon
Like %table2.advertiser_Name% would have been great but it seems the like operator only works with a constant.
I also tried this statement that did not work either:
Create table temp as
from SSP.SSPClients as t2
inner join SSP.Datamart as t1
on t1.Company_name like '%' + t2.Advertiser + '%';
Company_name and Advertiser are both text fields (length of $44 and $36)
Is there any solution to resolve this problem.
THANK you SO MUCH for your help. I much appreciate it!