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.
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""";
- Cheers -
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""";
- Cheers -
That works with some modifications to my program. Thanks
%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;
Thanks, that works as well
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.