Using a work library from another SAS project/session

[Andy_D]

How do I pull in datasets from the work library from another SAS session/project?

Thanks in advance,

Andy

[FreelanceReinh · Accepted solution]

Hi @Andy_D,

1. Determine the path of the work library in question, e.g., by submitting this in the other session:
   

   %put %sysfunc(pathname(work));

2. Use the path in a LIBNAME statement as usual (in the main session):
   

   libname work2 'the_path_goes_here';

[ballardw]

Since presumably this is someone else's work library and it might not be friendly to delete or overwrite data sets there, or if the intent is only to read data from that library it might be a good idea to use the Libname option Access=Readonly.

[FreelanceReinh]

This is a good point which I forgot to mention. I was not even sure that my suggestion would work for the OP because of possibly insufficient (read) permissions. Most often, I use this technique when working with two or more SAS sessions in parallel.

[ballardw]

---

@FreelanceReinh wrote:

This is a good point which I forgot to mention. I was not even sure that my suggestion would work for the OP because of possibly insufficient (read) permissions. Most often, I use this technique when working with two or more SAS sessions in parallel.

---

I have the luxury (?) of not working in a server environment so I also was not sure that permissions would allow the connection, or at least not without an Admin's help. But I do work with shared network location libraries and try to not accidentally corrupt my supervisors data.