title: PROC SQL like operator
body: <p>I was just wondering if there is a way to implement a like with a % sign for a variable. I basically want region to contain market and any other characters for there to be a match. An example is if REGION = ALBANY-SXSX-TVTV and market=ALBANY,I want there to be a match between region and market.</p>
  
  <pre><code>select a.*, b.Code,b.HHLDS
  from Master1 as a left join map as b
  on a.region like "b.market%"; /*not sure about this*/ 
  </code></pre>