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

qwerty12 — Wed, 01 Mar 2023 10:19:09 GMT

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

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

LinusH — Mon, 06 Mar 2023 07:44:06 GMT

Have you tried to increase the IBUFSIZE?

What is the variable length for each join variable?

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

Patrick — Mon, 06 Mar 2023 08:39:44 GMT

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.

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

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

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

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