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 Employee
Posts: 284

Re: AMO WORK Space and Stored Processes

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

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

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
  • 442 views
  • 0 likes
  • 2 in conversation