topic Re: how to delete all files in sas library ? in SAS Programming

how to delete all files in sas library ?

nannà — Tue, 30 Oct 2012 14:32:27 GMT

In my sas library path I have got some data_set and some empty folder

I want delete all but if I use

proc datasets lib=output kill nolist memtype=all;

quit;

I clean only data-sets.

Re: how to delete all files in sas library ?

Doc_Duke — Tue, 30 Oct 2012 15:54:01 GMT

You could use the "x" command to go out to the operating system and delete the non-sas files.

Re: how to delete all files in sas library ?

ArtC — Tue, 30 Oct 2012 19:00:16 GMT

The X or SYSTASK statements should do the trick (as Doc@Duke suggests), however if you need more control to select certain types of files, try the FDELETE function. This function will delete any type of file, and since you are in the DATA step, this gives you a great deal of flexibility. For windows:

filename list pipe 'dir "c:\temp\sasdat" /b/o';

data _null_;
   length fname $40;
   infile list truncover;
   input fname $;
   rc=filename('abc',catt("c:\temp\sasdat\",fname));
   if rc = 0 and fexist('abc') then rc=fdelete('abc');
   rc=filename('abc');
run;

Re: how to delete all files in sas library ?

nannà — Wed, 31 Oct 2012 09:41:27 GMT

Thank you very much !!