Thanks a lot, I will do that ... View more

Tables in excel are essentially named range of cells with header and data. It is essentially an excel feature. SAS documentation does not list it. https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsug/p09n5pw9ol0897n1qe04zeur27rv.htm)   ... View more

I'm sorry, but that wouldn't work in this case. The whole idea is to give ONE SAS session access to ANOTHER concurrent session's work library, so the libname must be hardcoded,  The problem in this post is not a DI Studio priobem. DI Studio is a code generator that sends code to execution, and each open window in DI Studio will have it's own workspace server session. So it is just the same as having two Display Manager sessions open at the same time and finding a way to get access from one session to the other session's work library.  ... View more

I'm sorry, but that wouldn't work in this case. The whole idea is to give ONE SAS session access to ANOTHER concurrent session's work library, so the libname must be hardcoded,  The problem in this post is not a DI Studio priobem. DI Studio is a code generator that sends code to execution, and each open window in DI Studio will have it's own workspace server session. So it is just the same as having two Display Manager sessions open at the same time and finding a way to get access from one session to the other session's work library.  ... View more