08-27-2017 01:55 PM
My question is in daily code it will first execute the back dated data from the source and then execute the remaining code.
For example when we run on 23 date it will first execute 22 data and then the remaining data, when we run on 24 it will first execute 23 data and then the remaining data.
EX : Yesterday date is set at 11am automatically and day before yesterday is set at 2am manually and once completed.
actually my question is that the code should have only one instance running.
So, what is the logic?
Rerun for recon issues logic?
08-27-2017 03:02 PM
Do you have daily datasets or a acummulated data.
Assuming the last is true and that the data contains a date or a timestamp variable
then calculate the "yesterday" day and run with where date variable is GE "yesterday".
08-27-2017 11:51 PM
08-28-2017 12:04 AM
It is still not clear what the code is doing.
Is it updating existing data? adding new data?
What is the ID variables?
Can you post your code and sample of your data?
What issues do you have ?
The logic may differ according to your answers.
08-28-2017 04:50 AM
To clearly formulate what you have, what you need and what problem you have to solve will not only help us to understand you and provide advise, it will also help you to take a structured approach to problem analysis and resolution.
08-29-2017 12:06 AM
@Devyani There is not a character limit here. Please post more details if you want any help otherwise please contact SAS Tech Support.
Details on how to ask a good question are here: