topic Re: Continuous Processing of Node in SAS Data Management

Continuous Processing of Node

yashpande — Mon, 04 Sep 2017 11:18:19 GMT

Hi All,

I need an idea on how to proceed this. I want to run a node (mostly it would be a user written node) till I get value updated from another table.

E.g.

Code 1 /SQL Join transformation :

Proc sql;

select user_name,user_id,email_address,lot_name,completed_flag,process_date from user_table where completed_flag=1 and process_date="&sysdate."d;

quit;

Code 2 :

Send an email to user_name and email_address from Code1 ;

Now my requirement is to keep on checking for Code1 for entire day and the moment I get completed_flag's value as 1 , I need to send email to the users. In short, I need infinite while loop for Code1 till the day is completed.

Any help/idea is appreciated

Re: Continuous Processing of Node

DmitryErshov — Mon, 04 Sep 2017 11:52:15 GMT

Hello!

Why didn't you use scheduler (e.g. crontab in Linux) to execute your code ex. every 5 minutes and check for flag update?

Re: Continuous Processing of Node

yashpande — Mon, 04 Sep 2017 12:05:14 GMT

Yes ultimately we are going to use LSF. But thats not the question. We need only 1 instance of execution and not rerun. In short only 1 infinite while loop and the moment flag value is 1 I need to break from the loop. Somehow I am not getting it.

Re: Continuous Processing of Node

DmitryErshov — Mon, 04 Sep 2017 12:09:41 GMT

Please, provide the code of your loop.

Re: Continuous Processing of Node

TomKari — Mon, 04 Sep 2017 12:49:06 GMT

Easy, but what environment are you working in? EG, DMS, DIS?

Tom

Re: Continuous Processing of Node

Patrick — Mon, 04 Sep 2017 21:31:59 GMT

@yashpande

As already mentioned that's something which should be done via scheduling. But to answer your question: You can use CALL SLEEP() or the SLEEP() function to pause a process for a defined amount of time. Just use this within your loop until the condition becames TRUE.

Once TRUE just jump out of the loop (using LEAVE).