title: How would you add spaces in front of every capital letter in a macro string, in SAS?
body: <p>I have several macro variables like this:</p>
  
  <pre><code>%let name=MyCamelisedString;
  </code></pre>
  
  <p>And I'm searching for a formula to automatically add spaces in front of every capital letter (except the first one but that I can correct myself).</p>
  
  <p>In order to obtain:</p>
  
  <blockquote>
    <p>My Camelised String</p>
  </blockquote>
  
  <p>My current idea is to go with <a href="http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002194376.htm" rel="nofollow noreferrer">ANYUPPER()</a>  function but that would require a loop which would be nice to avoid.</p>