Hi All,
our job runs every 20 mins like 8:00,8:20,8:40.9:00 ,9:20 so on
so I need read the file which is in time_XX_XX folder(folder names are like time_06_00, time_06_20,time_06_40 and so on).
EX:
If I run a job at 8:00 it should read time_06_00 (2 hrs delay) folder sometimes it can be delayed few secs/mins however we need to read time_06_00 folder
/Input/test/date_2021_8_13/time_06_00/
If I run a job at 8:20 it should read time_06_20 (2 hrs delay) folder sometimes it can be delayed few mins however we need to read time_06_20 folder
/Input/test/date_2021_8_13/time_06_20/
And so on
%let time=%sysfunc(time(), hhmm); %put &time;
%let Time_HH = %scan(&Time.,1,:) ;
%let Time_MM = %scan(&Time.,2,:) ;
%let DateCCYY = %sysfunc(date(),year4.) ;
%let Date_MM = %sysfunc(date(),Month2.) ;
%let Date_DD = %sysfunc(date(),Day2.) ;
%let folder= /Input/test/date_&DateCCYY._&Date_MM._&Date_DD./time_&Time_HH._&Time_MM./;
%put &Time_HH &Time_MM &DateCCYY.&Date_MM. &Date_DD. &folder;
... View more
