The case of a column name in a Netezza table might be preserved when being created even without the LIBNAME option PRESERVE_COL_NAMES=YES when the following conditions exist in your code:

• The Netezza LIBNAME engine is being used to access the Netezza Database Management System (DBMS).
• The LIBNAME statement includes the option DEFER=YES.
• The LIBNAME statement includes the option DSN=.
• The Netezza table is being created as the result of running one of the following Base SAS^® procedures that have been enabled for SAS^® In-Database processing:
• • FREQ
  • SORT
  • RANK

This does not occur with the TABULATE, MEANS, SUMMARY, or REPORT procedures. There is no workaround for this issue.