title: SAS PROC SQL to join two tables using FULL JOIN
body: <p>Suppose I have two datasets,</p>
  
  <pre><code>--Table 1--      --Table 2--
  ID  Amount       ID  Amount1 Code
  A01   0.1        A01  0.3     x
  A02   0.2        A02  0.2     y
  A02   0.3        A03  0.4     g 
  A03   0.4        A03  0.5     u
  A05   0.6        B01  0.1     k
  </code></pre>
  
  <p>I am trying to create a new dataset (Table 3) by joining Table 1 and Table 2.
  The intended final result should look like this:</p>
  
  <pre><code>--Table 3--
  ID  Amount  Amount1  Code
  A01   0.1     .       .
  A01   .       0.3     x
  A02   0.2     0.2     y
  A02   0.3     .       .
  A03   0.4     0.4     g
  A05   0.6     .       .
  B01   .       0.1     k
  </code></pre>
  
  <p>where the table will be joined based on the ID with the amount and amount1 compared at the same time.
  I tried using PROC SQL FULL JOIN but the results appear to be a little weird. 
  Thank you.        </p>