BookmarkSubscribeRSS Feed
WMachado
Calcite | Level 5

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.

 

 

5 REPLIES 5
yabwon
Onyx | Level 15

Hi,

 

Could you share the log?

 

Did you try :

1)  %SYSLPUT for AUX macrovariable

2) Access=Readonly in library definition

?

 

All the best

Bart

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



WMachado
Calcite | Level 5

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.

yabwon
Onyx | Level 15

Hi,

 

About error, check out this discussion:

https://communities.sas.com/t5/SAS-Stored-Processes/ERROR-User-does-not-have-appropriate-authorizati...

 

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

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



WMachado
Calcite | Level 5

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.

 

yabwon
Onyx | Level 15

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

https://documentation.sas.com/?docsetId=connref&docsetTarget=p0rfjby2hywt4cn1nt38unscvui8.htm&docset...

 

All the best

Bart

_______________
Polish SAS Users Group: www.polsug.com and communities.sas.com/polsug

"SAS Packages: the way to share" at SGF2020 Proceedings (the latest version), GitHub Repository, and YouTube Video.
Hands-on-Workshop: "Share your code with SAS Packages"
"My First SAS Package: A How-To" at SGF2021 Proceedings

SAS Ballot Ideas: one: SPF in SAS, two, and three
SAS Documentation



sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 535 views
  • 0 likes
  • 2 in conversation