title: Proc Sql query in Sas
body: <p>I need some help. I am writing a piece of code in Proc Sql and I'm stuck.</p>
  
  <p>I need to select the 5 values after JLC in a string. The name of the column is <code>response_body</code>. The string contains a mixture of number of characters, numerics &amp; alpha-numerics. The issue is, I need to find JLC and the next few characters associated with it. And JLC can be placed anywhere within the string. </p>
  
  <p>I am writting </p>
  
  <pre><code>SUBSTRING(response_body,position('JLC' in response_body), 7) AS JLC
  </code></pre>
  
  <p>but to no avail.</p>
  
  <p>Many thanks</p>