Desktop productivity for business analysts and programmers

Delete specific excel files from a folder

Accepted Solution Solved
Reply
Contributor
Posts: 22
Accepted Solution

Delete specific excel files from a folder

 

Hello experts,

 

I want to delete specific excel files from a folder on the network using a sas code. How can I achevie that?

 

Thank You.


Accepted Solutions
Solution
‎06-20-2016 01:02 PM
Super User
Posts: 7,371

Re: Delete specific excel files from a folder

a) what keeps you from doing it with operating system tools (shell script)?

b) to do it from SAS, you either need to be able to use external commands (which is prohibited by the default configuration of the workspace server), or you can use the fdelete function.

c) to get filenames for a directory, also use external commands (preferrably with the filename pipe), or try what is described here

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎06-20-2016 01:02 PM
Super User
Posts: 7,371

Re: Delete specific excel files from a folder

a) what keeps you from doing it with operating system tools (shell script)?

b) to do it from SAS, you either need to be able to use external commands (which is prohibited by the default configuration of the workspace server), or you can use the fdelete function.

c) to get filenames for a directory, also use external commands (preferrably with the filename pipe), or try what is described here

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 22

Re: Delete specific excel files from a folder

 

I just used fdelete function it worked. Thanks so much for your help.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 268 views
  • 0 likes
  • 2 in conversation