topic Re: Stored process not seeing data in Work library in Developers

Stored process not seeing data in Work library

deleted_user — Mon, 11 Feb 2008 20:07:36 GMT

EG...Stored process not seeing data in Work library
using EG on server...I've checked to make that it is pointing to the server

if I cut and paste the code into code window it works fine...

TIA

- Matthew

Re: Stored process not seeing data in Work library

deleted_user — Mon, 11 Feb 2008 21:18:27 GMT

Never mind... I found the answer in following thread...i've changed it to a macro...

EG Stored Processes vs Autocall Macros?

- Matthew

Re: Stored process not seeing data in Work library

hpl104 — Thu, 31 May 2012 16:55:32 GMT

Hi Matthew,

May I know how you do it? I can't see the data in my work library either, when I run stored process.

Thanks,

Hui

Re: Stored process not seeing data in Work library

Quentin — Fri, 01 Jun 2012 13:06:35 GMT

Hi,

Not sure what Matthew means by changing it to a macro.

As I understand it, when you execute a stored process from EG (or elsewhere) it runs on a server, and has it's own WORK library. It does not use the same work library as the EG session. See for example.:

https://communities.sas.com/message/8585#8585

I suppose it's possible that in your EG session you could find the physical path to the work directory:

%put %sysfunc(pathname(work));

And then you could pass that as a parameter when you invoke the stored process. But that would feel like a kludge. Probably better to just put whatever data you want the stored process to see in a permanent directory that the stored process can see.

--Q.

Re: Stored process not seeing data in Work library

hpl104 — Fri, 01 Jun 2012 20:05:57 GMT

Thanks Quetin.