Logic

[Devyani]

Hi,

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?

[Reeza]

Are you asking about scheduling a process to run and checking if it ran successfully?

It's not clear what you're asking for here.

[Shmuel]

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".

[Patrick]

@Devyani

Describe what you have, how you would like to work and how things work currently and what the problem is that you need to solve.

[Devyani]

Actually my yesterday data is scheduled at 11am automatically which takes atleast 3hrs of time to execute
I manually scheduled day before yesterday data at 2am because there is an issue with its data
once completed and when repeat or reconciliation
rerun for recon issues
both the dates data hit the same table
code should only have one instance running
can anyone please let me know the logic here?

[Shmuel]

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.

[Devyani]

It is updating existing data
only one instance should be running

[Patrick]

@Devyani

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.

[Devyani]

18 hours ago


It is updating existing data
only one instance should be running

[Reeza]

@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:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-ask-a-question-in-SAS-Analytics-U-Comm...

and here:

https://stackoverflow.com/help/how-to-ask