I have code that checks the last modified date of a specific dataset and compares it to the current system date. If the modified date of the desired dataset does not match the current system date, the macro then checks a specified number of times at set intervals (10 minutes) to see if the dataset is current. This code works as intended - no issues. What I need help with is when the dates match, how can I execute a process flow (or set of process flows) in the EG project where the macro resides?
%IF &MODATETIME2 = &NOW2 %THEN %DO;
%PUT NOTE:EXECUTE DESIRED PROCESS FLOWS>>>>>>>>>; <<<--what goes here to execute one or more process flows in the project?
*exit the macro once execution completes;
%return;
%END;
Currently I have %put statements indicating the dates match while I resolve this issue.
Why don't you set this as the first step in the process flow? When the step completes successfully, the next step executes.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!
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.
Ready to level-up your skills? Choose your own adventure.