topic Re: Parallel Processing with rsubmit in SAS Programming

Parallel Processing with rsubmit

WMachado — Fri, 14 Feb 2020 11:57:11 GMT

Hello, I'm trying to run two processes in parallel (this is working), but sas tries to contain all the Libref server, which generates error. Is there any way to solve this problem? follow the code below.

options autosignon sascmd='!sascmd -nosyntaxcheck';
options threads cpucount=4;

%LET AUX = "LIBNAME";


%let _timer_start = %sysfunc(datetime());

rsubmit job1 wait=no /*log=keep*/ sysrputsync=yes connectpersist=no/*remote=job1*/;
%sysrput wk1 = %sysfunc(pathname(work));
	LIBNAME histi &AUX.;


--------------------------------------------------------

CODE 1

-----------------------------------------------------------

endrsubmit;

rsubmit job2 wait=no /*log=keep*/ sysrputsync=yes /*remote=job2*/;
%sysrput wk2 = %sysfunc(pathname(work));

	LIBNAME histi &AUX.;


--------------------------------------------------------

CODE 2

-----------------------------------------------------------

endrsubmit;

endrsubmit;
waitfor _all_;
listtask _all_;

libname work1 "&wk1.";
libname work2 "&wk2.";

data _null_;
	dur = datetime() - &_timer_start;
	put 30*'-' / ' DURAÇAO TOTAL:' dur time13.2 / 30*'-';
run;

signoff job1;
signoff job2;


ERROR: Libref TT1 failed to assign from logical server.
ERROR: Libref TT2 failed to assign from logical server.
ERROR: Libref TT3 failed to assign from logical server.

Re: Parallel Processing with rsubmit

yabwon — Fri, 14 Feb 2020 12:10:03 GMT

Hi,

Could you share the log?

Did you try :

1) %SYSLPUT for AUX macrovariable

2) Access=Readonly in library definition

All the best

Bart

Re: Parallel Processing with rsubmit

WMachado — Fri, 14 Feb 2020 12:39:32 GMT

the log i can't share unfortunately, but the error below, apperas for diferente libraries.

ERROR: User does not have appropriate authorization level for library RIPCRC_P.

ERROR: User does not have appropriate authorization level for library RICINT_D.

1) %SYSLPU I tried to use but without succes.

2) Sorry but how I would use Access?

thank you for your help.

Re: Parallel Processing with rsubmit

yabwon — Fri, 14 Feb 2020 12:55:23 GMT

Hi,

About error, check out this discussion:

https://communities.sas.com/t5/SAS-Stored-Processes/ERROR-User-does-not-have-appropriate-authorization-level-for/td-p/317663

maybe your process doesn't have proper access rights to the location.

About `access-readonly` I ment:

libname A "/location/of/data" access=readonly;

All the best

Bart

Re: Parallel Processing with rsubmit

WMachado — Fri, 14 Feb 2020 13:08:08 GMT

Hi,

I don't really have access to that library. But I'm not trying to access it, apparently SAS is trying to access all the predefined libraries on the server.

Re: Parallel Processing with rsubmit

yabwon — Fri, 14 Feb 2020 13:15:55 GMT

Maybe check out the SASCMD= option, to modify remote session setup?

https://documentation.sas.com/?docsetId=connref&docsetTarget=p0rfjby2hywt4cn1nt38unscvui8.htm&docsetVersion=9.4&locale=en

All the best

Bart