title: Replace dashes and spaces by underscores and make column names uppercase
body: <p>In <code>sas eg</code>, for issues of compatibility, I need to copy a table renaming its columns to avoid spaces and dashes, and make the names uppercase.</p>
  
  <p>Here are a sample of names from my table, in reality I have many more:</p>
  
  <blockquote>
    <ul>
    <li>'Call - Investments IN'</li>
    <li>'E-mail - Campaign'</li>
    <li>'E-mail - Investments OUT'</li>
    <li>'Letter - Campaign'</li>
    </ul>
  </blockquote>
  
  <p>I want to get rid of the dashes and spaces and make the names upper case, these would be the columns of my output :</p>
  
  <blockquote>
    <ul>
    <li>'CALL_INVESTMENTS_IN'</li>
    <li>'E_MAIL_CAMPAIGN'</li>
    <li>'E_MAIL_INVESTMENTS_OUT'</li>
    <li>'LETTER_CAMPAIGN'</li>
    </ul>
  </blockquote>
  
  <p><em>Edit:</em> </p>
  
  <p><em>To be clear, my input is a table, and my output should be new table, and I don't want to type or copy paste individual column names, I want the operations to be done on ALL column names (I may have to use this on many columns on many tables that I receive from external sources).</em></p>
  
  <p>What sql query (or sas macro) should I use ?</p>