topic Re: Filename pipe getting listing of all xlsx file names and modification date in linux directory in SAS Programming

Filename pipe getting listing of all xlsx file names and modification date in linux directory

Matt3 — Thu, 28 Sep 2017 19:20:09 GMT

Hi,

Could anyone please help me how to get all file names and and modification date from linux directory using windows is quit simple:

filename xl pipe 'dir /T:W "c:\test\*.xlsx"'

but '*' signth for linux is not working:

filename xl pipe 'ls -r "/test/*.xlsx"'

Another problem is what variable names should I put in input statment to get just filename and last modification date.

data want;
 format moddate datetime20.;
 infile xl;
 input fname (?) $char50. moddate (?) 8.;
run;

Re: Filename pipe getting listing of all xlsx file names and modification date in linux directory

ballardw — Thu, 28 Sep 2017 19:52:34 GMT

I don't know which wildcard to use in Linux LS command but you likely need to provide a complete path from your root (or the server) otherwise the execution is likely to be looking for a folder test in the location of the executing SAS session.

If you are unclear where to look in the output for desired bits perhaps you should direct the output of an X command using the LS to a text file instead of a Pipe. Then you would have something to look at you could parse.

Or you could use the SAS function DOPEN, Dread and such to read directly.

Re: Filename pipe getting listing of all xlsx file names and modification date in linux directory

ChrisNZ — Thu, 28 Sep 2017 21:12:13 GMT

1- The star wildcard works fine when using ls. Linux is case-sensitive though, while Windows in not. Could this be the reason for you troubles? (for example, it's ls -R not ls -r )

2- Try to see what your input line looks like and then parse it:


filename LS pipe 'ls -R "/test/*.xlsx"' ;

data WANT; 
  format MODDATE datetime20.; 
  infile LS pad; 
  input LINE 256.;
  FNAME=substr(X,..) etc; 
run;