how to get the last modified file in a folder

[alepage]

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_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.

[Kurt_Bremser · Accepted solution]

Add a grep:

ls &path -rt|grep validation

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

[alepage]

Thank you so much for your help