How do I increase IBUFSIZE

[Siva_Harish]

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.

[Kurt_Bremser]

See this:

(currently 32767)

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

[Siva_Harish]

could you explore indexed variable mean?

[Kurt_Bremser]

---

@Siva_Harish wrote:

could you explore indexed variable mean?

---

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

[Siva_Harish · Accepted solution]

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 .

[Kurt_Bremser]

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