topic Delete All files with a specific extension in SAS Programming

Delete All files with a specific extension

texasmfp — Wed, 02 Aug 2023 08:39:20 GMT

Each month I create roughly 200 Excel files, 100 files are the old school "XLS" Excel files, then those files are turned into new "XLSX" files.

So there are two files with identical names, but with different extensions. I want to delete all of the "XLS" files but not the "XLSX" files. Each month the file names are different.

Re: Delete All files with a specific extension

Oligolas — Wed, 02 Aug 2023 09:19:05 GMT

Hi,

if you do not need to double check if the *.xlsx exists before deleting the *.xls you could simply use the x command:

x "del ""YourPath\*.xls""";

Re: Delete All files with a specific extension

texasmfp — Wed, 02 Aug 2023 12:00:41 GMT

That works with some modifications to my program. Thanks

Re: Delete All files with a specific extension

Ksharp — Wed, 02 Aug 2023 11:56:33 GMT

%let path= c:\temp\a  ;


data _null_;
rc=filename('x',"&path.");
did=dopen('x');
do i=1 to dnum(did);
  fname=dread(did,i);
  if upcase(scan(fname,-1,'.'))='XLS' then do;
    rc=filename('y',cats("&path.\",fname));
	rc=fdelete('y');
  end;
end;
did=dclose(did);
run;

Re: Delete All files with a specific extension

texasmfp — Wed, 02 Aug 2023 11:59:49 GMT

Thanks, that works as well