Hi all,
I would like to merge two datasets by identifier and date within range
dataset A:
accountnumber variableA date
dataset B:
accountnumber variableB startdate enddate

I would like to have a dataset like:
accountnumber variableA variableB date
where date would be between startdate and enddate

I looked at range join, but it seems like it would only accomplish merging using one variable? But I would like to have oaccountumber matched as well.

Thanks so much!