title: Grouping by set of 2 columns with switched values (character columns)
body: <p>I have a desperate question:) I want to group the data by 2 columns in proc sql in sas. </p>
  
  <p>Here is the example</p>
  
  <pre><code>A           B          C
  --------------------------    
  John      Smith        5
  Smith     John         4
  Adam      Gibbs        3 
  </code></pre>
  
  <p>The result I want is:</p>
  
  <pre><code>A           B           C
  ---------------------------
  John       Smith        9
  Adam       Gibbs        3
  </code></pre>
  
  <p>I want to group values from 2 columns that may have a switched values. </p>
  
  <p>Regardless of the "side" where the value is as long as they are the same in 2 columns. These are character columns so no least or greatest functions can be used. Please help!!!:)</p>