SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Logic

Reply
New Contributor
Posts: 4

Logic

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?

Super User
Posts: 22,818

Re: Logic

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.

Trusted Advisor
Posts: 1,822

Re: Logic

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

Respected Advisor
Posts: 4,536

Re: Logic

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

New Contributor
Posts: 4

Re: Logic

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?
Trusted Advisor
Posts: 1,822

Re: Logic

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.

New Contributor
Posts: 4

Re: Logic

It is updating existing data
only one instance should be running
Respected Advisor
Posts: 4,536

Re: Logic

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

New Contributor
Posts: 4

Re: Logic

18 hours ago


It is updating existing data
only one instance should be running
Super User
Posts: 22,818

Re: Logic

@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

 

 

 

 

 

Ask a Question
Discussion stats
  • 9 replies
  • 379 views
  • 0 likes
  • 4 in conversation