Architecting, installing and maintaining your SAS environment

Remote SAS library is not loading in Base SAS window

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Remote SAS library is not loading in Base SAS window

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;

 

 

 


Accepted Solutions
Solution
‎07-26-2016 07:23 AM
Super User
Posts: 7,866

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

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎07-26-2016 07:23 AM
Super User
Posts: 7,866

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

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 228 views
  • 2 likes
  • 2 in conversation