Hi. I have two sets of data, set 1 with variables HDR_startdate and HDR_enddate, and set 2 with variables EOH_startdate and EOH_enddate. I need to merge dataset 1 into dataset 2 conditional on HDR dates falling between the EOH date range. Something like:
  • EOH_startdate =< HDR_startdate <= EOH_enddate
  • EOH_startdate =< HDR_enddate <= EOH_enddate
I know how to identify when one range of dates falls within another date range, but am unsure on how to merge on this condition. Any help would be much appreciated.