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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.