I need a solution
Sort Initialization Failure in SAS
I was wondering if there is a reason and fix for SORT Initialization in SAS ||(v 9.2) ? I am using PROC SQL and there are multiple left joins and then a last group By statement.
are you able to provide the exact error message?
and what are you trying to do exactly?
Not sure what your error is, but in your OPTIONS statement at the start of SAS, you can define the amount of SORT space that SAS uses as 0 (max).
This will not limited SAS to a fixed amount of memory for sorting. There are pluses an minuses to doing this, but sounds like what you are looking for.
The MEMSIZE option is one that has to be used when SAS is invoked. It can't be set after the session has been started like the SORTSIZE option can.
Add the MEMSIZE option to the invocation command for SAS. Set the value to 1 GB and set the SORTSIZE value to 750 MB, or 75% of the MEMSIZE value.
Solve your biggest tech problems alongside global tech experts with 1:1 help.
Tackle projects and never again get stuck behind a technical roadblock.
How it Works
Plans and Pricing
Become an Expert
Who We Are
Join Our Team
Hall of Fame
Experts Exchange, LLC.
All rights reserved. Covered by US Patent.