topic Can you specify SAS invocation options for a particular stored process? in Developers

Can you specify SAS invocation options for a particular stored process?

Quentin — Wed, 25 Jul 2012 14:01:43 GMT

Hi,

If I write a stored process that uses a (non-pooled) workspace server, the server actually starts a new session to run the process, right?

Is there a way I can define SAS invocation options for the stored process (-altlog -autoexec -config etc?). I want to define these at the stored process level (so, e.g. different stored processes might use different autoexecs), not at the server level. I'm developing stored processes, but I don't administer the server.

One approach would be to use systask to kick off a new SAS session (with the desired options), as Scott Bass describes:

https://communities.sas.com/thread/34901

But was wondering if I could define in the stored process metada (and/or as a prompt) the system options to be specified during invocation.

Thanks,

--Q.

Re: Can you specify SAS invocation options for a particular stored process?

shivas — Thu, 26 Jul 2012 09:25:45 GMT

Hi ,

Try this link...it may give some idea...

http://support.sas.com/kb/32/231.html

For individual stored processes , add the custom SASAUTOS path by adding the path in an OPTIONS statement that is specified at the beginning of the stored process code. For example:

OPTIONS SASAUTOS=("c:\myautocalls\dir" "SASEnvironment/sasMacro" SASAUTOS)

Re: Can you specify SAS invocation options for a particular stored process?

Quentin — Thu, 26 Jul 2012 13:22:06 GMT

Thanks,

SASAUTOS can be defined in the actual stored process code. And that is what I'm doing now:

options insert=(sasautos="/myautocalls/dir");

But lots of system options (ALTLOG, AUTOEXEC, CONFIG) can only be specified during invocation. Seems that when a new SAS process is invoked to run a stored process, it would be nice to be able to define (in the metadata associated with the stored process), the system options that should be set during the invocation.

But I guess we can't do that yet. Maybe I'll propose this to the SASware ballot.

Thanks,

-Q.