title: How to do Left join in r
body: <p>I have two dataset one and two</p>
  
  <p>dataset one</p>
  
  <pre><code>a     b  c
  111   a  1
  112   b  2 
  113   c  3
  114   d  4
  115   e  5
  </code></pre>
  
  <p>dataset two</p>
  
  <pre><code>e    d   g
  222  ss  11
  111  ff  22
  113  ww  33 
  114  qq  44
  234  dd  55
  534  vv  66
  </code></pre>
  
  <p>I want to do a left join</p>
  
  <p>Below is the code written in SQL but when i try it in SQLDF it showing as error </p>
  
  <pre><code>proc sql;
  create table join1 as
  select one.*, two.*
  from  one left join two
  on one.a = two.e;
  quit;
  </code></pre>