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;