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
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.