When you use the EQT operator in an SQL procedure's SELECT clause, the software incorrectly considers rows with missing values to be a match for rows whose values begin with the value that is used in the comparison.

For example, if you run a query with the following SELECT clause, the software will flag not only those rows that start with the value yes but also any rows where there is no value:

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: