When you use a PROC SQL UPDATE statement on a database management table accessed via the OLEDB LIBNAME engine, rows that should be updated might not be updated. This issue might occur when your WHERE clause includes a function that does not get passed to the database. The UPCASE function is a good example.

Instead of the database processing the WHERE clause, SAS does the processing. The data read in from the database is not transcoded correctly, resulting in matches not being found. As a result, the data is not updated as it should be. 

A potential workaround for this issue is to use the LIBNAME option SQL_FUNCTIONS=ALL. This workaround results in additional SAS functions being passed down to the database.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS/ACCESS Interface to OLE DB 9.3_M2 is available at: