Skip to main content

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;