Creates a delete query that removes records from one or more of the tables listed in the FROM clause that satisfy the WHERE clause. DELETE is especially useful when you want to delete many records. To ...

Learn the basic syntax and examples of the SQL DELETE statement, as well as its limitations and alternatives, for deleting data from a table in a relational database.

If you have many rows to delete, you could use a macro variable for EMPID instead of the individual EMPID values to change the values more easily. %let empid='346917'; proc sql; delete from ...