ERROR: Index TEMPINDX cannot be created on file WORK.'SASTMP-000000044'n because

[qwerty12]

getting this error can any one help me out, let me know if you need more information

[LinusH]

Have you tried to increase the IBUFSIZE?

What is the variable length for each join variable?

[Patrick]

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.