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 lock in 2025 pricing—just $495!
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.