Search code examples
unixsasls

sas unix dirlist - how to read in file and last modified timestamp in yyyymmmdd:hh:ss format

I am using the following code in UNIX SAS to try and read in the files from a folder:

filename DIRLIST pipe 'dir "&path." ls -lt';

data dirlist ;
  length file $1000 ;
  infile dirlist length=reclen ;
  input file $varying256. reclen ;
  if index(file, '.txt')>=1;
run;

I do indeed manage to read in the files I need but the timestamp looks a little odd:

rw-r--r--. 1 user      8252 Oct 28 12:18 spec.txt

Is it possible to get the timestamp in a yyyymmmdd hh:ss format or similar?

thanks

Solution

  • The --full-time option to ls provides an ISO style date/time. It's not exactly what you ask, but "YYYY-MM-DD HH:MM:SS.ssssssss" fits the "or similar" part of your comment.

    Depending on your platform, --full-option may not be available, but it seems it's part of standard linux distributions.