01-11-2013 03:37 PM
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
01-11-2013 05:56 PM
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.
01-11-2013 06:30 PM
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. :-)
01-12-2013 11:05 AM
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