With SAS^® 9.1, SAS Warranty Analysis 4.1 returns 372 rows in the resulting data set for queries that are made by SELECT statements in the SQL procedure. The correct number of rows is 316.

Example

Assume that you have a table called TEST with 316 rows and a column called VAR1:

1. If you run the query select VAR1 from .TEST using the integrated object model (IOM) JDBC driver, the resulting data set will contain 316 rows. This is the number of rows that the resulting set should contain.
2. If you run the query select * from .TEST using IOM JDBC, 372 rows will be returned.
3. If you run either query using Base SAS^® software, you will get the correct number of rows, 316.

The problem is triggered when you use the syntax SELECT* instead of SELECT A, B, C in PROC SQL queries.

This problem does not happen in all data sets. It is a server issue that affects SAS/SHARE^® servers in the third maintenance release for SAS 9.1.3 (TS1M3), Service Pack 4.

Workaround

Add this %LET statement in front of the remote engine LIBNAME statement:

The NOOVLPIO macro forces the remote engine to turn off overlapping I/O for situations such as those described in this SAS note.

An alternate workaround is to upgrade from SAS 9.1.3 Service Pack 4, to SAS^® 9.2.

Click 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: