Index TEMPINDX cannot be created

[Ronein]

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?

[Kurt_Bremser]

Maxim 3: Know Your Data.

Look at the attributes of the involved variables.

[LinusH]

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-to...

[JosvanderVelden]

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?