topic Using SAS code to delete many different .xlsx files in a folder in SAS Programming

Using SAS code to delete many different .xlsx files in a folder

gradus — Wed, 11 Sep 2019 08:55:53 GMT

Hello,

I need to find a way how to 'empty' a folder with many different named Excel files using SAS.

'Fdelete' does not work, as it works only for one file, but I have many...

Thanks 🙂

JosvanderVelden — Wed, 11 Sep 2019 11:27:41 GMT

ballardw — Wed, 11 Sep 2019 15:21:59 GMT

If the X command has not been disabled at your installation then

x "del c:\folder\subfolder\*.xlsx" ;

should delete all xlsx files in the target folder on a windows system

If you have groups of files will similar names you can use:

x "del c:\folder\subfolder\CommonNamePart*.xlsx"

x "del c:\folder\subfolder\*CommonNamePart.xlsx"