Querying a column name that is more than 30 characters long returns "The following columns were not found in the contributing tables"


When you query a column name with more than 30 characters from a CDE LIBNAME table, the following error occurs:

ERROR: The following columns were not found in the contributing tables: COLUMNNAMEWITH31CHARSFORTESTIN.

In addition, the column name is truncated to 30 characters, and you are unable to find the column name in the given table.

This issue occurs when the underlying CDE database is Oracle.

Workaround

To work around this issue, create a table view that renames the column names to a name that is not longer than 30 characters.

Note: This issue occurs in SAS® Cloud Data Exchange.