topic Re: How do I increase IBUFSIZE in SAS Programming

How do I increase IBUFSIZE

Siva_Harish — Tue, 23 Feb 2021 14:06:15 GMT

Hi Folks,

Can anyone help on below error .

Tried in multiple ways :

1) options ibufsize=32767;

2)options ibufsize=32767;
proc options option=ibufsize;run;

ERROR: Index TEMPINDX cannot be created on file WORK.'SASTMP-000000132'n because the length of the
       index value (13408 bytes) is too large. The index page size (currently 32767) must be large
       enough to store three index values plus a small overhead structure. Reduce the length of
       the index value or use the IBUFSIZE= option to increase the index page size (up to a
       maximum of 32,767 bytes).
ERROR: :Unable to create temporary index while processing summary functions.

Re: How do I increase IBUFSIZE

Kurt_Bremser — Tue, 23 Feb 2021 14:39:50 GMT

See this:

(currently 32767)

You already have the maximum IBUFSIZE defined. You MUST reduce the size of the index variable(s).

Re: How do I increase IBUFSIZE

Siva_Harish — Tue, 23 Feb 2021 15:55:58 GMT

could you explore indexed variable mean?

Re: How do I increase IBUFSIZE

Kurt_Bremser — Tue, 23 Feb 2021 18:36:29 GMT

@Siva_Harish wrote:

could you explore indexed variable mean?

It's the variable(s) used for the index you tried to create.

Re: How do I increase IBUFSIZE

Siva_Harish — Thu, 25 Feb 2021 10:00:59 GMT

Thank you for the explanation. In my code we didn't create any indexes eventhough I got this error because in my grouping variables one variable length is 4000 and changed length to hundreds then iam not able to see this error .

Re: How do I increase IBUFSIZE

Kurt_Bremser — Thu, 25 Feb 2021 10:02:16 GMT

Please post the complete log of the step that caused the ERROR message.