title: syntax search over a string with sas
body: <p>Got the following example</p>
  
  <p><img src="https://i.stack.imgur.com/euJde.png" alt="enter image description here"></p>
  
  <p>I'm trying to know if any part of string in the column <code>nomvar</code> in table tata does exist in col1 in table toto and if yes, give me the definition using col2.</p>
  
  <p>For I2010,RT,IS-IPI,F_CC11_X_CCXBA, I would have in the column <code>intitule</code> "yes,toto,tata,well"</p>
  
  <p>I thought about using a <code>proc sql</code> with an insert and a select but I have two tables and I would need to do a join.</p>
  
  <p>In the same time, I thought to have everything in one table but I'm unsure if it is a good idea.</p>
  
  <p>Any suggestions are welcomed as I'm deeply stuck.</p>