In SQL we support non-standard clause called ON CONFLICT / OR. It is not a separate clause which can appear in INSERT/UPDATE statements or as a column option in CREATE TABLE statements. See examples ...

To update the data, you can specify view descriptors in the PROC SQL INSERT, DELETE, and UPDATE statements. Here is a summary of these PROC SQL statements: DELETE deletes records from a CA-DATACOM/DB ...

proc sql; create table proclib.paylist (IdNum char(4), Gender char(1), Jobcode char(3), Salary num, Birth num informat=date7. format=date7., Hired num informat=date7 ...

I have a small request as I did not find anything similar in documentation (or did I overlook sth?). One to insert many rows to DB's table must use executemany with ...