I have a table that runs daily it gets kick off by task in windows. The issue is that there is a column in table for date that must be from yesterday its a indicator data has refreshed. When its not we have to manually kick off the sas code to bring in the most current data. I need help in creating a loop that runs the 1st part of the table an see that date eq yesterday an it proceeds. When it doesn't eq to yesterday day it stops goes to sleep for 30min an reruns script until date matches yesterday date...Thanks for assistance
Your question contains the answer SLEEP.
Thanks for the quick reponse. I would like the loop to look to see if the settlement date matches yesterday. If it does than the rest of the code runs. If it doesn't match yesterday date than it stops an starts the process over again until settlement day matches yesterday day.
Those details are specific to your data. What is "settlement data" and where is it, etc. You will need to supply more details for me. Others may be able to devine the question without knowing the answer. 🙂
The table has a.Col name Settlement date it's formatted in mmddyy. What I want to have is a loop that looks at the 1st entry an if the settlement date. Matches yesterday date to contiune running script. If it doesn't eq to yesterday date it stops script . I would want it to start process again until the settlement matches yesterday day... Thanks again
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.