BookmarkSubscribeRSS Feed
Albert0
Quartz | Level 8

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 0 replies
  • 556 views
  • 0 likes
  • 1 in conversation