topic Re: Multi-Threading in SAS Programming

Multi-Threading

_AW_ — Thu, 21 Jan 2010 22:58:19 GMT

I have a program that calls a number of other macro programs in sequential order.

However some of the programs are not dependent on the previous completing.

Let's say macros 1,2,3,4,5 need to run sequentially and are dependent on the previous macro(s) executing to completion.

There is also macros A,B,C,D,E that do not have to wait until the previous macros complete.

Let's also assume the 1,2,3,4,5 need to complete before A,B,C,D,E are submitted.

Does anyone know if or how I could multi-thread and submit A,B,C,D,E to all run at the same time and have them run independently.

Thanx.
_AW_

Re: Multi-Threading

sbb — Thu, 21 Jan 2010 23:07:17 GMT

I might consider it be called job/task-scheduling. You can spawn independent SAS tasks in your SAS operating environment.

And without a scheduling subsystem, you can write logic to "sleep" and "awaken" to test for some crumbs/morsels that are left by a predecessor job/process.

And, SAS jobs can be executed in sequence using various techniques, such as parent/child process/task execution or sequential threading (A completes, then submits B, C, D, and waits for B and C before submitting E - waits for D and E, then submits F).

Sure it's possible. Recommend reviewing the particular SAS companion guide for your OS, with focus on the OS system interfaces, such as CALL EXECUTE, CALL SYSTEM, and FILENAME PIPES engine, to start.

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument for this topic/post:

batch program scheduling site:sas.com

Re: Multi-Threading

LinusH — Fri, 22 Jan 2010 07:44:12 GMT

You might also consider the technique called MP CONNECT, see on-line doc for details.

/Linus

Re: Multi-Threading

DanielSantos — Fri, 22 Jan 2010 08:59:32 GMT

Yep,

Either leave it to the system/scheduler
or
if your site has SAS/CONNECT licensed then MP CONNECT gives you the ability to submit asynchronous remote/local processes.

http://support.sas.com/documentation/cdl/en/connref/61908/HTML/default/a002626619.htm

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

Re: Multi-Threading

deleted_user — Fri, 22 Jan 2010 15:34:50 GMT

Thanks to all.

_AW_

Re: Multi-Threading

data_null__ — Fri, 22 Jan 2010 16:51:19 GMT

I believe all these features you desire are provided for with the SAS statements SYSTASK and WAITFOR.