SAS 9.4 SQL Procedure User's Guide, Second Edition, 2nd Edition

Note: Alternatively, you can set the SQLUNDOPOLICY system option. For more

information, see “SQLUNDOPOLICY= System Option” on page 383.

Deleting Rows

The DELETE statement deletes one or more rows in a table or in a table that underlies a

PROC SQL or SAS/ACCESS view. For more information about deleting rows from

views, see “Updating a View” on page 132. The following DELETE statement deletes

the names of countries that begin with the letter R:

/* Create and populate Newcountries */

proc sql;

create table sql.newcountries like sql.countries;

insert into sql.newcountries

select * from sql.countries

where population ge 130000000;

proc sql;

delete

from ...