AMO WORK Space and Stored Processes

[SterlingParamore]

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?

[Vince_SAS]

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

[SterlingParamore]

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

[SterlingParamore]

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.