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?
Maxim 3: Know Your Data.
Look at the attributes of the involved variables.
Apparently you had the same error in March – this is a thread where you didn’t reply to any of suggestions given:
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.