title: within proc sql replace string of a macro variable
body: <p>Within Proc SQL, I'd like to use a macro variable <code>&amp;condition3</code>, but I'd like to replace the string “t1” with “t6” in the macro variable. How can I make the following formula work: <code>translate(&amp;condition3,'T6','T1')</code>?</p>
  
  <p>By the way, <code>&amp;condition3</code> resolves to: <code>and t1.store in ('1234')</code></p>
  
  <p>The full query:</p>
  
  <pre><code>Proc sql;
    Create table xxx as
      Select....
        From ...
        Where condition1
          And condition 2
          &amp;condition3 
  </code></pre>