When you run an analysis in SAS Warranty Analysis, a query on sashelp.vindex frequently occurs to ensure that the index that is being created does not already exist. If the index does exist, an error is generated. Because this error is benign, an SQL query is made to suppress the error from being written to the SAS log. However, this query is potentially very long. As a result, performance degradation occurs during SAS Warranty Analysis steps that involve index creation, and is usually noticeable if the USSERL, USERDL, or USERFDL library has grown very large.

To improve performance and avoid the potentially long query, this query should be eliminated and a note should be written to the log to indicate that the subsequent error message is benign:

NOTE: This datasets procedure may produce an error if the index to be created already exists.

NOTE: This error is safe to ignore.

ERROR: An index named xxxxx with the same definition already exists for file yyyyy.

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

Operating System and Release Information

A fix for this issue for SAS Warranty Analysis 4.31 is available at: