With some queries or WHERE clauses that run against large data sets through a SAS/SHARE server, the server might become unresponsive. For example, a query such as the query shown below, when run against a table that has 20 million observations, might not yield to other users or requests.

The problem is that the underlying BASE engine yields only after a given number of selected observations are read, rather than after raw observations are read. In this situation, setting LRPYIELD= to a higher value in PROC SERVER will not help.

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 :