topic Re: How to clean all files in sas folder? in New SAS User

How to clean all files in sas folder?

az94 — Mon, 22 Jul 2019 13:15:04 GMT

Hi Everyone,

I need to know how to clean all files (excel, sas ,txt,...) in a sas folder ?

I did a search on this community and I only found how to clean sas files and a macro to clean file to file, but I need something to do this automatically.

Can you help me?

Thank you.

Re: How to clean all files in sas folder?

Kurt_Bremser — Mon, 22 Jul 2019 13:34:13 GMT

The easiest way is to use the respective command from the operating system.

Does your directory contain subdirectories? If yes, do you want to remove them also, or only files in there, recursively?

Re: How to clean all files in sas folder?

ballardw — Mon, 22 Jul 2019 14:34:19 GMT

Define what you mean by "clean".

If you mean delete files then OS commands are preferred. If you want to do this from SAS you may be able to use the X command such as

X "del <path>\*.* ";

to delete ALL files in the folder for Windows to delete all files in the Path, which should start at a drive letter such as c:\folder\subfolder\*.*

If you want just specific types of files then replace the second * with the file extension such as TXT, XLSX or what ever as needed.

Unix commands I'm not as familiar with but similar should work.

In many aspects of SAS cleaning refers to code to ensure that variables have the desired characteristics and values prior to analysis.

Since you are mentioning Excel and text that seems unlikely.

Re: How to clean all files in sas folder?

Reeza — Mon, 22 Jul 2019 14:54:11 GMT

FDELETE()

Re: How to clean all files in sas folder?

az94 — Tue, 23 Jul 2019 10:23:20 GMT

Some directory contain subdirectories yes. And I need to delete only the files in this folders. This folders are in sas server.

Re: How to clean all files in sas folder?

az94 — Tue, 23 Jul 2019 10:24:18 GMT

I want to delete files in a folder. This folder is on sas server

Re: How to clean all files in sas folder?

az94 — Tue, 23 Jul 2019 10:25:11 GMT

With this function I can delete all files in a sas server folder?

Re: How to clean all files in sas folder?

Reeza — Tue, 23 Jul 2019 14:59:06 GMT

Are they SAS datasets? If so, use PROC DATASETS but yes, FDELETE can clean out all files.

Re: How to clean all files in sas folder?

Kurt_Bremser — Tue, 23 Jul 2019 16:19:31 GMT

Do you have XCMD enabled? And which operating system is your SAS running on?

Re: How to clean all files in sas folder?

az94 — Wed, 24 Jul 2019 07:59:36 GMT

windows

Re: How to clean all files in sas folder?

az94 — Wed, 24 Jul 2019 08:00:22 GMT

Are datasets and excel and txt files

Re: How to clean all files in sas folder?

Reeza — Wed, 24 Jul 2019 15:00:04 GMT

XCMD?
proc options option=xcmd;
run;

And check the log. If it says XCMD you're good, if it shows NOXCMD you're not.

Re: How to clean all files in sas folder?

az94 — Fri, 26 Jul 2019 08:25:59 GMT

Re: How to clean all files in sas folder?

Reeza — Fri, 26 Jul 2019 14:51:48 GMT

Why would you paste that as an image when pasting the text would be so much easier?

Anyways, this means you do not have the xcmd enabled, which means you need to use FDELETE() to navigate through and clean the files or talk to the IT area about setting up something on the server side.