topic Re: Deletion of Log Files in SAS in Administration and Deployment

Deletion of Log Files in SAS

laxmanpai — Tue, 09 Aug 2022 05:08:10 GMT

Hi Team,

Could you let me know how to delete the log files from the Logs Folder in SAS which are older than 1 month.

Currently i am manually deleting the files from this folder.

Is there a SAS job which can be written or any script which can be auto triggered ?.

Regards

Laxman

Re: Deletion of Log Files in SAS

laxmanpai — Tue, 09 Aug 2022 05:09:14 GMT

I want this through SAS DI Studio job or any other script which will get auto triggered

Re: Deletion of Log Files in SAS

andreas_lds — Tue, 09 Aug 2022 05:58:54 GMT

A solution depends on the os of the sas server. On a windows server i would use something like the solution posted on https://stackoverflow.com/questions/17829785/delete-files-older-than-15-days-using-powershell.

Re: Deletion of Log Files in SAS

laxmanpai — Wed, 10 Aug 2022 03:35:46 GMT

Thank you.

Also wanted to know whether it can be done through SAS jobs in DI studio.

Re: Deletion of Log Files in SAS

Patrick — Wed, 10 Aug 2022 03:44:22 GMT

@laxmanpai wrote:

Thank you.

Also wanted to know whether it can be done through SAS jobs in DI studio.

DI Studio is just generating and executing SAS code.

If XCMD is set you can execute OS level commands via SAS.

Proc Options option=xcmd; run; will tell you what's set.

IF your compute server where SAS executes is Unix/Linux then what you want can be done with a single command (Unix find ) that you then can call out of SAS via Filename pipe or system()/call system();

Using DIS just a single node with user written code.

Re: Deletion of Log Files in SAS

Kurt_Bremser — Wed, 10 Aug 2022 07:27:11 GMT

See this piece of SAS code which extracts the modification timestamp for files in a directory:

data times;
length dref fref $8 fname $200;
rc = filename(dref,"name of your logs directory");
did = dopen(dref);
if did
then do;
  do i = 1 to dnum(did);
    fname = dread(did,i);
    rc = filename(fref,cats("~/",fname));
    fid = fopen(fref);
    if fid
    then do;
      modified = input(finfo(fid,foptname(fid,5)),nldatm30.);
      rc = fclose(fid);
      output;
    end;
    rc = filename(fref);
  end;
  rc = dclose(did);
end;
rc = filename(dref);
format modified e8601dt19.;
drop dref fref rc did fid i;
run;

From this dataset, you can then run a data step which uses the FDELETE Function (if you're comfortable with the code once you tested it, you can add the FDELETE immediately before the OUTPUT).

Re: Deletion of Log Files in SAS

laxmanpai — Thu, 11 Aug 2022 06:59:05 GMT

Thank you