topic Re: deleting folders (keeping 5 days folders only) in SAS Programming

deleting folders (keeping 5 days folders only)

sathya66 — Mon, 30 Apr 2018 11:58:33 GMT

Hi all,

I want to delete the folders (want to keep 5 days folders only).

my code is creating folders every day yymmdd10. format.

but I want to keep only 5 days folders only.

my folders are like this

20180419
20180420

20180421
20180423

20180424
20180425

20180426
20180427

20180428
20180429

20180430

Thanks,

SS.

Re: deleting folders (keeping 5 days folders only)

RW9 — Mon, 30 Apr 2018 12:19:38 GMT

Something like (and you don't mention which os you use so windows assumed):

http://support.sas.com/kb/45/805.html

Filename filelist pipe "dir /b /s c:\temp\*.sas"; 
                                                                                   
Data _null_;                                        
  Infile filelist truncover;
  Input filename $100.;
  if _n_>5 then call execute(cats('%sysexec(del c:/temp/"',filename,'");'));
Run;

You can change the if as you like, maybe input as date and check if date is today()-5 or less.

Re: deleting folders (keeping 5 days folders only)

sathya66 — Mon, 30 Apr 2018 12:39:57 GMT

It is windows.

I want to delete the folders irrespective of files in those folders.

Below filename statement referring .sas files.

Filename filelist pipe "dir /b /s c:\temp\*.sas";

see the attached

Re: deleting folders (keeping 5 days folders only)

RW9 — Mon, 30 Apr 2018 12:54:47 GMT

I am not opening zip files.

Just change the filename to point to your area, i.e replace c:/temp with where your folders are located:

Filename filelist pipe "dir /b /s /ad c:\temp\";

Note I added /ad to restrict list to directories only.

Re: deleting folders (keeping 5 days folders only)

sathya66 — Mon, 30 Apr 2018 13:19:28 GMT

Thank you,

I think,I have an issue with my sas shortcut.

NOTE: The infile FILELIST is:Unnamed Pipe Access Device,PROCESS=dir /b /s C:\test\.

Thanks,

Re: deleting folders (keeping 5 days folders only)

RW9 — Mon, 30 Apr 2018 13:29:22 GMT

I don't know what "I think,I have an issue with my sas shortcut." means? The note seems correct, assuming all your folders are in c:/test. Note your missing the /ad, which only gets directories.

Re: deleting folders (keeping 5 days folders only)

Reeza — Mon, 30 Apr 2018 15:14:01 GMT

You need XCMD enabled to use PIPE commands or to use system commands.

options xcmd;

If that errors out, you'll need a different method, most likely using FDELETE instead. It's still possible, just a different approach required.