This error is related to the SAS tool that you are using. It is generally caused by the syntax used when updating/deleting the data. To bypass this, please try to manipulate your data using the Pass-Through Facility syntax described in the solution from the forum: Solved: ODBC MySQL table update - Optional feature not implemented error - SAS Support Communities
PROC SQL;
CONNECT TO ODBC (DSN="<DNS Name>");
EXEC (DELETE FROM <table_name> WHERE <condition>;) BY ODBC;
QUIT;
