General form, DELETE
statement for deleting rows in a table:
DELETE FROM table-name
<WHERE expression>;
table-name
specifies the name
of the table in which rows will be deleted.
WHERE
is used to specify
an expression that subsets
the rows to be deleted.
|
proc sql; create table work.frequentflyers2 as select ffid, milestraveled, pointsearned, pointsused from sasuser.frequentflyers;
proc sql;
delete from work.frequentflyers2
where pointsearned-pointsused <= 0;