Hi Ody, I recommend to use regular expressions,if you want to search/substitue complex patterns in strings (like url's). SAS provides the prxmatch function for such tasks (for further informations I recommend the SAS help) proc sql; create table URL_Match as select a.url, b.match, b.field1, b.field2 from test1 as a inner join test as b on prxmatch("/\/"!!strip(b.match)!!"\//",a.url)>0; quit; Regular expressions are very powerful/standarized and available in a lot of modern programming languages. You can find a lot of tutorials on the web, I strongly recommend to take a look.
... View more