SAS VA 7.1 Data Builder Range Join

[Albert0]

Hi All,

I would like to ask your help in finding an alternative approach in my problem.

Currently, I'm doing my transformation in Data Builder of SAS VA 7.1. I need to convert my code below into a DataQuery.

proc sql;

create table a 

as select t1.receive, t1.due, t2.date, t2.value

from TableA as t1 left join TableB as t2 

on (t1.receive >= t2.date and t1.due <= t2.date);

quit;

I know for a fact that Data Builder of SAS VA only support equal value joining.

Can anyone suggests an alternative way?

Thanks.

Albert0