Remote SAS library is not loading in Base SAS window

SSA1 — Tue, 26 Jul 2016 04:31:34 GMT

1) We are able to connet Remote server server from client machine.

2) And we are able to assign Oracle library through SAS macro.

3) And then we ar able to call the stored complied macro for oracle connection from Base SAS Windowing Environment

When we click the remote library, the remote library is loading and it is not displaying. It is taking long time and it leads to terminate the SAS session.

Can you please help how to quickly load the remote library in Base SAS Environment.

%LET sunsas=server_name port_number;

OPTIONS REMOTE=sunsas COMAMID=TCP;
options compress=yes;
FILENAME RLINK "C:\sas\connect\saslink\tcpunixf.scr";
signon;

rsubmit;

libname t_lib '/one/two';
options mstored sasmstore=t_lib;
%conn_macro(one, two, oracl);
endrsubmit;

libname t_ora remote slibref=oracl server=sunsas;

Re: Remote SAS library is not loading in Base SAS window

Kurt_Bremser — Tue, 26 Jul 2016 06:04:25 GMT

I guess you are simply causing network congestion. If your SAS server (sunsas) uses one interface to connect to both the client and the Oracle server, it will quickly be swamped by colliding packets when it tries to receive information from Oracle and send it to the SAS client concurrently.

Try to do a proc datasets on the Oracle library (remote on sunsas) and then look at the results.

topic Remote SAS library is not loading in Base SAS window in Administration and Deployment

Remote SAS library is not loading in Base SAS window

Re: Remote SAS library is not loading in Base SAS window