Hashing functions do not perform as expected when the numbers of rows that are processed are increased. As the numbers of rows increase, there is an exponential decrease in performance.

For example, processing 8,000 rows might take 1 second and use 3 MB of memory. You could then reasonably expect that 64,000 rows would take eight times as long to process (8 seconds) and use a similar amount of memory. However, the 64,000 rows might take 108 seconds and use 64 MB of memory.

Note: Different operating systems will perform differently. The values that are discussed above are examples only.

For a full list of the SAS functions that are affected, see Hashing Functions and Hash-Based Message Authentication Code.

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 Threaded Kernel User Functions 9.4_M7 is available at:

A fix for this issue for SAS Threaded Kernel User Functions 9.4_M6 is available at: