Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA 7.1 Data Builder Range Join

Reply
Contributor
Posts: 43

SAS VA 7.1 Data Builder Range Join

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

Ask a Question
Discussion stats
  • 0 replies
  • 70 views
  • 0 likes
  • 1 in conversation