I created a table on SAS work.sas_table with 5 columns(3 char and 2 numeric) by running a select query from an external database(hive presto). I got a warning that "the following columns could have a lenght in SAS of 32767. if so, SAS performance is impacted."   I tried to work with work.sas_table then got this error: "ERROR: Index TEMPINDX cannot be created on file WORK.'SASTMP-000000019'n because the length of the index value (32767 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."   On checking the properties of wor.sas_table I discovered the the reason for the first error looking at the length   Name Type Length Format Informat Label Col 1 Character 32767 $32,767.00 $32,767.00 month Col 2 Numeric 8 20 20 msisdn_key Col 3 Numeric 8 11 11 smartphones Col 4 Character 32767 $32,767.00 $32,767.00 imei tech Character 32767 $32,767.00 $32,767.00 tech   Please how do I alter the table and possible reduce the length of the character columns of work.sas_table. Is there a function in SAS I can use? I am running SAS Enterprise ... View more