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