Deleting multiple xlsx files in a folder - SAS Support Communities

Obsidian | Level 7

Obsidian | Level 7

Deleting multiple xlsx files in a folder

Posted 02-26-2019 03:50 PM (2211 views)

Hi All

How can I delete multiple excel files (.xlsx) files in a folder, lets say they start with "xxx"? Any thoughts?

2 REPLIES 2

Tourmaline | Level 20

Tourmaline | Level 20

Re: Deleting multiple xlsx files in a folder

Posted 02-26-2019 03:56 PM (2206 views) | In reply to SASSLICK001

Perhaps see the FDELETE Function.

The DATA to DATA Step Macro
Blog: SASnrd

Super User

Super User

Re: Deleting multiple xlsx files in a folder

Posted 02-26-2019 04:10 PM (2196 views) | In reply to SASSLICK001

Use an OS command with CALL SYSTEM or an X statement.

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!