BookmarkSubscribeRSS Feed

PROC DELETE to remove SAS tables

Started ‎07-03-2018 by
Modified ‎01-09-2019 by
Views 83,724

Proc Delete is faster than either PROC DATASETS or PROC SQL.  Here are a few examples of how SAS programmers delete SAS tables.

 

 

proc delete data = libref.dataname;
run;

proc sql;
  drop table libref.dataname;
quit;

proc datasets library = libref;
  delete dataname;
run;

data _null_;
  length dd $8;
  rc = filename(dd,cats(pathname('libref'),'\dataname.sas7bdat'));
  rc = fdelete(dd);
  put _all_;
run;

 

 

 Since SAS 9.4, PROC DELETE has had more capabilities than ever -- find out more in Chris Hemedinger's blog.

 

This was originally posted by Ronald Fehd on sasCommunity.org.

Comments
RW9

I am sorry, but that coding is all over the place, upper case used, sometimes indents, unfinished blocks (e.g. missing run; after first proc.  Your other tips follow a coding standard?

Good points, @RW9.  We're moving some of the most popular posts from sasCommunity.org (now in stasis) to here, and these are coming over "as is" -- but I've fixed up this one.

Version history
Last update:
‎01-09-2019 12:28 PM
Updated by:
Super User

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Labels
Article Tags