Programing whith MP connexion

[mansour_ib_sas]

Hello,

I want to use the mp connection technique to optimize the processing time.

everything works except the libname.

when I point the libname to a local windows folder, the process works.

when I point to a server folder I get this error message:

ERROR: Libref mib non attribué.

I use this programm:

%macro test();
%let srv_c=server port;
%let user_c = **** ; 
%let pwd_c =  **** ;

options comamid=tcp remote=srv_c;
signon user="&user_c" password="&pwd_c" ;

rsubmit ;							
libname libora oracle PATH="****" SCHEMA="***"  USER=*** PASSWORD="***" access=readonly defer=yes ;   			
libname mib "/server/data/users/mib" ;
endrsubmit;

goptions reset = all device  = ACTXIMG;
option autosignon=yes ;	

OPTIONS SASCMD='"C:\Program Files\SASHome\SASFoundation\9.4\sas.exe"';

libname mib 'c:/data';

rsubmit process=task1 wait=no;

libname mib "/server/data/users/mib" ;

/*This work*/
libname mib 'c:\data';
/*This not work*/
libname mib '/server/data/user/mib';


/*Creation table enc_6po*/
 
proc sql;

connect to oracle
(PATH="****"       USER= *** PASSWORD="****" ); 

 create table mib.table as select *

from connection to oracle
(
select  distinct         *

	from oralib.table
)
;disconnect from oracle; 

quit; 

endrsubmit task1 ;

signoff task1;


%mend test;


%test;

can you help me please?

Thank you

[s_lassen]

I am not sure, but the problem may be that you are using a Unix path convention under Windows. Normally, Windows paths are written with a backslash, and when you refer to a network path in Windows, you will normally use a double backslash first, e.g.:

libname mib '\\server\data\user\mib';

[mansour_ib_sas]

it does not work

[Kurt_Bremser]

So you are using SAS/CONNECT to work from one SAS process on one Windows machine to another SAS process on another Windows machine?

If you try to use a network resource, it might just be that this network mount is not available on the machine you rsubmit to.

[mansour_ib_sas]

With not libname

NOTE: Table WORK._TEST created, with 15 rows and 10 columns.

but, no dataset in work.

Where is it?

[Kurt_Bremser]

---

@mansour_ib_sas wrote:

With not libname

NOTE: Table WORK._TEST created, with 15 rows and 10 columns.

but, no dataset in work.

Where is it?

---

Keep in mind you have two SAS processes here that communicate through SAS/CONNECT, so you have two log streams and two WORK directories.

Something in the WORK in the remote session is not visible locally.

[mansour_ib_sas]

Ok

now i put this in session rsumit:

%let work_path=%sysfunc(pathname(work));

%put &work_path ;

no dataset in path display