sorry but quick follow up question, if my "condition" is date (if today's date=date from table), how can i interpret, "condition" lines in your code (i tried to put quotation mark around but didn't work). Receiving error like "ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: not &condition "?     %let condition=0; %DO %UNTIL(&condition or &count=3); %let condition=%SYSFUNC(FILEEXIST(&TESTFILE)); %if not &condition %then %do; %if &condition %then %do; %if &count=3 and not &condition       ... View more

Thanks a lot Miller. I tested it two ways, positive/negative scenario and it worked fine. Don't worry about formatting, you knows SAS EG has cool formatting option, right click in program editor and select "format code"      @ Wilson, if i keep sleep (300), it seems working fine, i am running in linux.  ... View more

actually, this link is awesome solution but (example) i want to run condition only 3 times in 15 minutes (each execution happens 5 min apart) and then stop. once 3 execution completes, put message in log "reached max execution".      https://communities.sas.com/t5/SAS-Programming/SAS-MACRO-WITH-SLEEP-FUNCTION/td-p/314327     ... View more