topic Re: How to read the unix directory and unix date modified in SAS? in SAS Programming

How to read the unix directory and unix date modified in SAS?

StickyRoll — Thu, 02 Dec 2021 07:26:07 GMT

I have a script that needs to read the unix directory information such as path and the last modified date.

filename filelist pipe "ls -lrtd /sas/data/master/*/";

data directory_raw;
infile filelist truncover;
input filename $1000.;
run;

The script will first list out all files and folders from the directory /sas/data/master/*/

What I actually want to achieve here is to find what is inside /sas/data/master/*/*/

I created this thread to seek help for allowing me to scan the files in the directory, scan for its last modified date and delete it if it exceeded 30 days. To do so, I need to first identify each and every files and folders' last modified date.

Since it is a ls command in unix, I have limited control. Notice that I want to actually drill down into the the second * in the unix directory. Is there anyone that can assist for me to identify the last modified date from unix directory (at least)?

Re: How to read the unix directory and unix date modified in SAS?

ChrisNZ — Thu, 02 Dec 2021 08:06:38 GMT

why not add option s to the ls command?

Re: How to read the unix directory and unix date modified in SAS?

ChrisNZ — Thu, 02 Dec 2021 08:15:10 GMT

Another solution maybe:

filename filelist pipe "ls -lrtd /sas/data/master/*/ && ls -lrtd /sas/data/master/*/*/";

Unsure that'd work, my unix shell knowledge has not been used for a long time.

Re: How to read the unix directory and unix date modified in SAS?

Kurt_Bremser — Thu, 02 Dec 2021 08:45:18 GMT

Try this:

filename filelist pipe "find /sas/data/master -type f -mtime +30 -print 2>&1";

data directory_raw;
infile filelist truncover;
input filename $1000.;
run;

Once you have verified that it works correctly, you can expand the external command to

find /sas/data/master -type f -mtime +30 -print -exec rm -f {} \;

so that it removes the files also.