For databases that allow variable names longer than 32 characters, some variables might not appear in the results of a query. When the variables are retrieved, names that are longer than 32 characters are truncated. If two or more columns result in the same name, when the resulting data set is created, only the first variable that is part of the group of duplicate names is retained. All other variables with that name are dropped, and a warning is written to the log.

This issue will occur when the following conditions exist in the SQL procedure query:

• The LIBNAME engine is used to access a database management system (DBMS) with one of the following products:
  • SAS/ACCESS^® Interface to Aster
  • SAS/ACCESS^® Interface to Greenplum
  • SAS/ACCESS^® Interface to Neoview
  • SAS/ACCESS^® Interface to Microsoft SQL
  • SAS/ACCESS^® Interface to Netezza
  • SAS/ACCESS^® Interface to ODBC
  • SAS/ACCESS^® Interface to OLE DB
  • SAS/ACCESS^® Interface to Sybase IQ
• Rather than dropping the last character of the truncated duplicate names and appending a number to make them unique, as would be expected, the variable names remain the truncated 32 characters.

To work around this issue, use explicit pass-through processing and rename the variables in the query.