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;
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.
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: