As in other PROC and DATA steps, you can use only a view descriptor or other SAS data set in an SQL procedure statement, not an access descriptor. If you did not create the DBF file, you must be ...

Some DBMSs require the SQL procedure's UNDO_POLICY option before you can use the INSERT, DELETE, or UPDATE statements with a DBMS view descriptor. For example: proc sql undo_policy=none; Refer to your ...