getting this error can any one help me out, let me know if you need more information
Have you tried to increase the IBUFSIZE?
What is the variable length for each join variable?
Assuming your ..._key variables aren't very long I can't really understand what could trigger the error.
If the error message can be trusted then your index page size is already set to the maximum of 32KB and though you can't increase ibufsize any further.
There is an old problem note about this here which indicates that even though an error message gets written to the SAS log you don't get an error condition. Is that true in your case? Does the SAS job continue to execute like there wouldn't be an error?
What you could try is one of the magic options (magic=101 or magic=102) as described in the whitepaper here to explicitly instruct the SQL compiler to not use a hash join - which according to the problem note is what creates the issue.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: