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
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.
Thanks Quetin.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.