topic Re: Delete a non-empty Folder in SAS Enterprise Guide

Delete a non-empty Folder

PReintsch — Wed, 02 Sep 2020 23:20:29 GMT

Hello guys! I am new utilising SAS Enterprise Guide and I have been frustrating over this,

My Libraries and OUTPUT folders have been created this way:

options dlcreatedir;
libname OUTPUT "&CARPETA.\&SERIE.";

where, &CARPETA is a path and &SERIE is the name of the FOLDER.

After all the regressions are done, the FOLDER called 'SERIE' contains:

- SAS tables; aaa.sas
- Excel file; bbb.xlsx

I want to DELETE the FOLDER 'SERIE' completely.

I have tried deleting what is inside first, but I just managed to delete the SAS tables only. Is there a way to delete the FOLDER itself at once? In case it is not posible, how can I delete the excel file? Please!!!

Greetings!

Re: Delete a non-empty Folder

SASKiwi — Thu, 03 Sep 2020 00:04:56 GMT

The FDELETE function will do what you want: FDELETE

Re: Delete a non-empty Folder

Kurt_Bremser — Thu, 03 Sep 2020 09:30:07 GMT

This is best done by using the appropriate operating system command with the necessary options. Since you seem to have Windows underneath your SAS, use "del".

Try this:

filename oscmd pipe "del '&CARPETA.\&SERIE.' /f 2>&1";

data _null_;
infile oscmd;
input;
put _infile_;
run;

The single quotes might be necessary if blanks appear in the path.

Re: Delete a non-empty Folder

Reeza — Thu, 03 Sep 2020 14:25:23 GMT

FDELETE to delete files and an empty folder.

https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p0h945u5r0cv6yn1u6qs35hiqt9t.htm&docsetVersion=9.4&locale=en#n17zq8fabdl8tbn1v2qvpytktbhj

Macro to recursively delete files using FDELETE

https://www.sascommunity.org/mwiki/index.php?title=Recursively_Delete_Files

Or use XCMD and a command line statement.

https://communities.sas.com/t5/SAS-Programming/delete-a-folder-directory-and-all-files-on-it/td-p/584870

@PReintsch wrote:
Hello guys! I am new utilising SAS Enterprise Guide and I have been frustrating over this,

My Libraries and OUTPUT folders have been created this way:

options dlcreatedir;
libname OUTPUT "&CARPETA.\&SERIE.";

where, &CARPETA is a path and &SERIE is the name of the FOLDER.

After all the regressions are done, the FOLDER called 'SERIE' contains:

- SAS tables; aaa.sas
- Excel file; bbb.xlsx

I want to DELETE the FOLDER 'SERIE' completely.

I have tried deleting what is inside first, but I just managed to delete the SAS tables only. Is there a way to delete the FOLDER itself at once? In case it is not posible, how can I delete the excel file? Please!!!

Greetings!

Re: Delete a non-empty Folder

PReintsch — Thu, 03 Sep 2020 17:58:29 GMT

Thanks for the detailed answer Kurt. However I got 3 Error messages, from which these two are very particular:

ERROR: Insufficient authorization to access PIPE.

ERROR: No logical assign for filename OSCMD.

Re: Delete a non-empty Folder

Kurt_Bremser — Thu, 03 Sep 2020 18:06:05 GMT

This means that, sadly, your SAS administrator has not enabled the XCMD system option. Either you get him/her to enable that, or you use the macro linked to by @Reeza