Your SAS programs, embedded in web apps and elsewhere

AMO WORK Space and Stored Processes

Reply
Occasional Contributor
Posts: 9

AMO WORK Space and Stored Processes

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?
SAS Super FREQ
Posts: 304

Re: AMO WORK Space and Stored Processes

Posted in reply to SterlingParamore
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
Occasional Contributor
Posts: 9

Re: AMO WORK Space and Stored Processes

Posted in reply to Vince_SAS
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
Occasional Contributor
Posts: 9

Re: AMO WORK Space and Stored Processes

Posted in reply to 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.
Ask a Question
Discussion stats
  • 3 replies
  • 446 views
  • 0 likes
  • 2 in conversation