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.
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.
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.
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.