In an inner join in the SQL procedure, the use of the CALCULATED keyword in a WHERE clause generates a cartesian product.

This behavior causes performance problems. In such cases, the following note is written to the SAS log:

NOTE: The execution of this query involves performing one or more
Cartesian product joins that can not be optimized.

The following events are also symptoms of this problem:

• queries that run for extreme periods of time, or queries that do not complete
• result sets that are much larger than expected
• errors in creating the results set that occur because of a lack of disk space

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: