title: SAS merge with duplicate observations
body: <p>I have two datasets (d1 and d2) that I would like to merge based on an individual specific identifier (ind_ID). The issue is that there are some cases where the same ind_ID appears twice in one or both data sets (with the other fields different).</p>
  
  <p>I am choosing one duplicate in d1 to merge with both duplicates in d2, but I'm not sure how to tell SAS to select just one of the observations in d1 and merge it to both in d2. I am doing it this way because I haven't been told yet which observation is the correct one, and I would like to move forward with my coding until that information comes in. </p>
  
  <p>So far, I have tried merging just based on loan number (first example code) and by using a merge identifier (second example code). It seems that both have the same result, and that SAS is just randomly choosing which ind_ID from the duplicates to merge with which.</p>
  
  <p>Short of manually going through the data and deleting the observations that I don't want to merge, is there a way to do this?</p>
  
  <pre><code>data merge_test;
  merge d1 d2;
  by ind_ID;
  run;
  
  data merge12;
  merge d1(in=a) d2(in=b);
  by ind_ID;
  if a and b;
  mergecheck = compress(a||b);
  run;
  </code></pre>