topic Re: AMO WORK Space and Stored Processes in Developers

AMO WORK Space and Stored Processes

SterlingParamore — Wed, 19 Jan 2011 23:45:46 GMT

When I open up Excel and connect to a SAS server through AMO, a WORK library is created. Is there any way for a stored process that is executing during that AMO session to determine the file path to where the AMO WORK library is?

Re: AMO WORK Space and Stored Processes

Vince_SAS — Thu, 20 Jan 2011 00:05:12 GMT

This is not specific to AMO/STP, but does it give you what you want?

[pre]%let WORKPATH=%sysfunc(pathname(work));[/pre]

Vince DelGobbo
SAS R&D

Re: AMO WORK Space and Stored Processes

SterlingParamore — Thu, 20 Jan 2011 00:09:32 GMT

Vince,

Thanks, but no. The WORK library in AMO is different from the WORK library that gets created when the STP runs. I was just wondering if there was any way that the STP that is called could be aware of where the WORK directory is that exists in AMO.

Thanks,
Sterling

Re: AMO WORK Space and Stored Processes

SterlingParamore — Thu, 20 Jan 2011 00:39:25 GMT

What I'm looking for is a way to have two stored processes talk to each other when they're run through the same AMO session so that I can have multiple stored processes output to multiple worksheets in the same workbook.