As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.

PROC Delete

From sasCommunity
Jump to: navigation, search

As part of the decommissioning effort for this article/tip has been migrated to

The new home for this article/tip is PROC Delete (

Proc Delete is faster than either Datasets or SQL.

PROC Delete data = Libref.DataName;
PROC SQL; drop table Libref.DataName;
PROC Datasets library = Libref;
              delete    DataName;
DATA _Null_;
length dd $8;
rc = filename(dd,cats(pathname('Libref'),'\DataName.sas7bdat'));
rc = fdelete(dd);
put _all_;

Previously.Old.News.Note: Proc Delete is/was officially deprecated; you could not get help from Tech Support about it, prior to 2013.


--macro maven == the radical programmer 11:58, 5 January 2009 (EST)