Working with NLS Characters in PostgreSQL Data

If your data contains NLS characters, you might receive errors in the SAS log that stop processing for a DATA step. If you prefer to continue with processing, you can enable the SAS_POSTGRES_UPDATE_WARNING= environment variable. When you specify SAS_POSTGRES_UPDATE_WARNING=1, then a warning is printed to the SAS log and processing continues.

The warning might resemble the following example:

WARNING: During update: [SAS][ODBC PostgreSQL Wire Protocol driver]No rows were affected by UPDATE/DELETE WHERE CURRENT OF cursor 
         emulation
Last updated: February 3, 2026