title: Finding Null Records - PROC SQL
body: <p>I’m trying to get all the records from table a that are not found in table b… I’m getting zero results, and I know that is not the case...Any idea what I am doing wrong?</p>
  
  <pre><code>proc sql;
  title 'Merge';
  select a.report_date, a.pharmacy, a.pme_id, a.rx_number, a.product, a.status, a.fill
  from hc.horizoncaresMaster a 
  left join  TMP1.horizoncares_master b on a.rx_number = b.rx_number
  where( a.report_date in ('2016-11-11','2016-11-04')
  and a.status ="Hold"
  and a.pme_id=62
  and b.rx_number is NULL )
  order by a.report_date;
  quit;
  </code></pre>