topic Programing whith MP connexion in SAS Programming

Programing whith MP connexion

mansour_ib_sas — Fri, 02 Nov 2018 10:09:29 GMT

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

Re: Programing whith MP connexion

s_lassen — Fri, 02 Nov 2018 11:23:36 GMT

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';

Re: Programing whith MP connexion

mansour_ib_sas — Fri, 02 Nov 2018 11:47:55 GMT

it does not work

Re: Programing whith MP connexion

Kurt_Bremser — Fri, 02 Nov 2018 12:30:02 GMT

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.

Re: Programing whith MP connexion

mansour_ib_sas — Fri, 02 Nov 2018 13:37:21 GMT

With not libname

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

but, no dataset in work.

Where is it?

Re: Programing whith MP connexion

Kurt_Bremser — Fri, 02 Nov 2018 13:49:25 GMT

@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.

Re: Programing whith MP connexion

mansour_ib_sas — Fri, 02 Nov 2018 14:03:24 GMT

now i put this in session rsumit:

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

%put &work_path ;

no dataset in path display