DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 53

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

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;


 

 

Super User
Posts: 11,343

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

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.

PROC Star
Posts: 1,760

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

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;

   

Ask a Question
Discussion stats
  • 2 replies
  • 69 views
  • 0 likes
  • 3 in conversation