topic Re: Logic in SAS Data Management

Logic

Devyani — Sun, 27 Aug 2017 17:55:10 GMT

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?

Re: Logic

Reeza — Sun, 27 Aug 2017 18:03:36 GMT

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.

Re: Logic

Shmuel — Sun, 27 Aug 2017 19:02:05 GMT

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

Re: Logic

Patrick — Sun, 27 Aug 2017 23:13:12 GMT

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

Re: Logic

Devyani — Mon, 28 Aug 2017 03:51:51 GMT

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?

Re: Logic

Shmuel — Mon, 28 Aug 2017 04:04:14 GMT

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.

Re: Logic

Patrick — Mon, 28 Aug 2017 08:50:18 GMT

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

Re: Logic

Devyani — Mon, 28 Aug 2017 09:57:38 GMT

It is updating existing data
only one instance should be running

Re: Logic

Devyani — Tue, 29 Aug 2017 03:53:33 GMT

18 hours ago

It is updating existing data
only one instance should be running

Re: Logic

Reeza — Tue, 29 Aug 2017 04:06:44 GMT

@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-Communities/ta-p/221163

and here:

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