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.
