BookmarkSubscribeRSS Feed
sas_
Fluorite | Level 6
How can i delete a sas dataset from a library other than using SAS Datasets procedure.Any macro or functions are there to delete.
3 REPLIES 3
milts
Pyrite | Level 9
Hi,

How about using proc sql delete from or drop table?

Milton
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
You also have PROC DELETE.

Scott Barry
SBBWorks, Inc.
Oleg_L
Obsidian | Level 7
Hello.

You can try this macro to delete SAS datasets or any other files in library.
You can also use Windows commands.

%macro dirclear(dir=d:\test,ext=xls);
%let ext=%upcase(&ext);
%let dlm=\;
%let filrf=;
%let rc=%sysfunc(filename(filrf,"&dir"));
%let did=%sysfunc(dopen(&filrf));
%let lstname=;
%let memcount=%sysfunc(dnum(&did));
%if &memcount > 0 %then %do;
%do i=1 %to &memcount;
%let lstname=%sysfunc(dread(&did,&i));
%let file=&dir&dlm&lstname;
%let ln=%length(&lstname);
data _null_;
c="&lstname"; c1=reverse(c); ln1=index(c1,'.'); ln=&ln-ln1+2; ln3=ln1-1;
ln4=upcase(substr(c,ln,ln3));
call symput('ln2',trim(left(ln4)));
run;
%if &ln2=&ext or &ext= %then %do;
%let rb=%sysfunc(filename(fname,"&file"));
%let rv=%sysfunc(fdelete(&fname));
%end; %end; %end;
%let rc=%sysfunc(dclose(&did));
%mend dirclear;

libname test v9 'd:\work\test';

%let l=%sysfunc(pathname(test));
/* use macro */
%dirclear(dir=&l,ext=sas7bdat);

/* use Windows command */
systask command "del ""&l.\*.sas7bdat""" wait taskname="del";

or use fdelete() function

data _null_;
rc=filename('fname', "&l.\recartis.sas7bdat");
if fexist('fname') then rc=fdelete('fname');
run;


Regards,
Oleg. Message was edited by: Oleg_1976

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!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 823 views
  • 0 likes
  • 4 in conversation