Developers

A forum for collaboration, Q&A, and knowledge sharing on SAS and open source integration
BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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
4 REPLIES 4
deleted_user
Not applicable
Never mind... I found the answer in following thread...i've changed it to a macro...

EG Stored Processes vs Autocall Macros?

- Matthew
hpl104
Calcite | Level 5

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

Quentin
Super User

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.

The Boston Area SAS Users Group is hosting free webinars!
Next webinar will be in January 2025. Until then, check out our archives: https://www.basug.org/videos. And be sure to subscribe to our our email list.
hpl104
Calcite | Level 5

Thanks Quetin.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 1666 views
  • 0 likes
  • 3 in conversation