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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: