topic Re: Index TEMPINDX cannot be created in SAS Programming

Index TEMPINDX cannot be created

Ronein — Thu, 16 Nov 2023 05:53:06 GMT

Hello

I run this code

proc sql;
create table WANT as
select Company_Code,Company_Code_Desc,
       count(*) as nr_Transactions format=comma23.,
	   count(distinct Branch_Cust_IP) as nr_Customers  format=comma23.,
	   sum(AMOUNT)/1000000 as AMOUNT   format=comma23.
from  r_r.Have
group by  Company_Code,Company_Code_Desc
;
quit;

I get this error


ERROR: Index TEMPINDX cannot be created on file WORK.'SASTMP-000000169'n because the length of the index value (30640 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.

What does it mean?

HOw can I solve it?

Re: Index TEMPINDX cannot be created

Kurt_Bremser — Thu, 16 Nov 2023 07:50:24 GMT

Maxim 3: Know Your Data.

Look at the attributes of the involved variables.

Re: Index TEMPINDX cannot be created

LinusH — Thu, 16 Nov 2023 11:17:01 GMT

Apparently you had the same error in March – this is a thread where you didn’t reply to any of suggestions given:
https://communities.sas.com/t5/SAS-Programming/ERROR-Index-TEMPINDX-cannot-be-created-index-value-too-large/m-p/863998#M341231

Re: Index TEMPINDX cannot be created

JosvanderVelden — Thu, 16 Nov 2023 11:52:23 GMT

Investigate the length of company_code and company_code_desc (the variables in the group by). I assume there is no need to have both variables in the group by statement and that company_code_desc has a considerable length. Does the code run if you remove company_code_desc?