topic Chaining Stored processes in Developers

Chaining Stored processes

deleted_user — Thu, 06 Apr 2006 14:13:55 GMT

I am new to Stored Processes. We are trying to convert all .sas programs (reports) into Stored processes.

In our old sas code we are using include to call other code. I am looking for a way to replace the include command by calling a stored process. Is this possible and how.

Re: Chaining Stored processes

deleted_user — Sat, 08 Apr 2006 03:10:00 GMT

I don't believe this is possible in SAS 9.1.x.

A solution around this is to convert your programs into macros and call these macros from your stored processes, thereby enabling calling the code chunks from many stored processes.

Re: Chaining Stored processes

deleted_user — Mon, 10 Apr 2006 06:04:42 GMT

I was afraid that is was not possible.

Stored Processes have the advantage that the meta data is stored in the meta data server and you can control who may use the Stored process.

Another advantage is that (we are using Unix) that the Stored Processes places the code on the server with the correct user rights.

Re: Chaining Stored processes

Vince_SAS — Mon, 10 Apr 2006 15:20:27 GMT

Do you really need to convert all the %INCLUDE code to stored processes? People routinely write stored processes that use %INCLUDE.

Vince DelGobbo
SAS R&D