I think the key element here is:
NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.
Does the code suppose to do that?
Usually cartesian joins is not what you want. But on the other hand, the SQLS and SAS code looks "identical"...?
I see two ways forward here:
- Go back to the requirements to understand what output is to produce, and then building it with an ETL flow from scratch, instead of copy/paste code
- Look into your data, compare your SAS work tables with corresponding ones in SQLS
... View more