how to get the last modified file in a folder

alepage — Thu, 12 Nov 2020 15:51:58 GMT

Hello,

I am already using the macro below to get the latest modified file. As I am not very familiar with the Unix command, is there a way to improve this search tool to get the latest modified file in a folder for a file containing for example the word validation or the word scenario ?

%macro lastmodifiedfile(path,MName);

/** Change the filename below to the following to run on UNIX **/
/** filename test pipe "ls &path -rt"; **/

/** Change the filename below to the following to run on Windows **/
/** filename test pipe "dir &path /od /t:w /b"; **/

filename test pipe "ls &path -rt";

data _null_;
infile test;
input;
call symputx("&Mname.",_infile_,'g');
run;

%put Last file to be modified in &path is: &Mname.;

%mend lastmodifiedfile;
%lastmodifiedfile(/dwh_operation/sasdata/smp_production/prod_smpi2/pilot/,Fname);

So I would like to modified the above mentioned code to permit to add a part of the filename.

ex:

//.../pilote_2020_validation_v1.spde...

//.../pilote_2020_validation_v2.spde...

//.../pilote_2020_validation_v3.spde...

//.../pilote_2020_scenario_v1.spde...

//.../pilote_2020_scenario_v2.spde...

//.../pilote_2020_scenario_v3.spde...

Moreover, I can't use the version number to trace the latest modified file. So is there a way to modified the script to specify file containing the word validation, then the word scenario and so on.

Thank in advance for your help.

Re: how to get the last modified file in a folder

Kurt_Bremser — Thu, 12 Nov 2020 16:01:48 GMT

Add a grep:

ls &path -rt|grep validation

this will filter for filenames that contain the string, while keeping the order.

Re: how to get the last modified file in a folder

alepage — Thu, 12 Nov 2020 16:22:04 GMT

Thank you so much for your help

topic Re: how to get the last modified file in a folder in SAS Enterprise Guide

how to get the last modified file in a folder

Re: how to get the last modified file in a folder

Re: how to get the last modified file in a folder