topic Re: SAS Multiprocessing/inherit meta library error in SAS Programming

SAS Multiprocessing/inherit meta library error

SAS_user — Thu, 18 Jun 2009 11:48:22 GMT

Hello,

I started Multiprocessing. Its very intresting.
But i can't inheritlib which is meta. (its the same when library is SPDS or BASE)
Any idea how i can workaround or fix this.

Here is my code.
/* library temp */

NOTE: Libref TEMP was successfully assigned as follows:
Engine: META
Physical Name:

The code is:

signon _01 sascmd="!sascmd" inheritlib=(Work=locwork MacroLib=MacroLib temp=temp );

After i signon i get this eror:
ERROR 22-7: Invalid option name LIBRARY.

But after rsubmit it use library "temp" without erros:

data x;
set temp.F1DN;
run;

NOTE: There were 743 observations read from the data set TEMP.F1DN.
NOTE: The data set WORK.X has 743 observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.23 seconds
cpu time 0.03 seconds

Re: SAS Multiprocessing/inherit meta library error

DanielSantos — Thu, 18 Jun 2009 14:02:47 GMT

Could you please share more of your code (lib assignments, signon and rsubmit script), because I don't see anything wrong about it.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

Re: SAS Multiprocessing/inherit meta library error

SAS_user — Thu, 18 Jun 2009 15:12:06 GMT

/* Here is Code */
******************************************;
options source;

libname testine
meta
library = testine;

signon _01 sascmd="!sascmd" inheritlib=(Work=locwork testine =testine);

data _null_;
call sleep(10,1);
run;

rsubmit _01 wait=no macvar=JOB01 signonwait=y persist=n;
data _null_;
set testine.Conf_action_types(obs = 10);
run;
endrsubmit;

data _null_;
call sleep (20,1);
run;

******************************************;
LOG
******************************************;
1 The SAS System 18:07 Thursday, June 18, 2009

NOTE: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead.
NOTE: All registry changes will be lost at the end of the session.

WARNING: Unable to copy SASUSER registry to WORK registry. Because of this, you will not see registry customizations during this session.
NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead.
NOTE: All profile changes will be lost at the end of the session.
NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
Licensed to #######, Site 0088197007.
NOTE: This session is executing on the HP-UX B.11.31 platform.

NOTE: Running on HP Model ia64 Serial Number 3427677858.

NOTE: SAS 9.1.3 Service Pack 4

You are running SAS 9. Some SAS 8 files will be automatically converted
by the V9 engine; others are incompatible. Please see
http://support.sas.com/rnd/migration/planning/platform/64bit.html

PROC MIGRATE will preserve current SAS file attributes and is
recommended for converting all your SAS libraries from any
SAS 8 release to SAS 9. For details and examples, please see
http://support.sas.com/rnd/migration/index.html

This message is contained in the SAS news file, and is presented upon
initialization. Edit the file "news" in the "misc/base" directory to
display site-specific news and information in the program log.
The command line option "-nonews" will prevent this display.

NOTE: SAS initialization used:
real time 0.25 seconds
cpu time 0.11 seconds

3
4 libname testine
5 meta
6 library = testine;
NOTE: Libref TESTINE was successfully assigned as follows:
Engine: META
Physical Name:
7
8 signon _01 sascmd="!sascmd" inheritlib=(Work=locwork testine =testine);
NOTE: Remote signon to _01 commencing (SAS Release 9.01.01M3P020206).
NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead.
NOTE: All profile changes will be lost at the end of the session.
NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
Licensed to #######, Site 0088197007.
NOTE: This session is executing on the HP-UX B.11.31 platform.

NOTE: Running on HP Model ia64 Serial Number 3427677858.

NOTE: SAS 9.1.3 Service Pack 4

You are running SAS 9. Some SAS 8 files will be automatically converted
by the V9 engine; others are incompatible. Please see
http://support.sas.com/rnd/migration/planning/platform/64bit.html

PROC MIGRATE will preserve current SAS file attributes and is
recommended for converting all your SAS libraries from any
SAS 8 release to SAS 9. For details and examples, please see
http://support.sas.com/rnd/migration/index.html

This message is contained in the SAS news file, and is presented upon
initialization. Edit the file "news" in the "misc/base" directory to
display site-specific news and information in the program log.
The command line option "-nonews" will prevent this display.

NOTE: SAS initialization used:
real time 0.12 seconds
cpu time 0.11 seconds

ERROR 22-7: Invalid option name LIBRARY.
NOTE: Remote signon to _01 complete.
9
10 data _null_;
11 call sleep(10,1);
12 run;

NOTE: DATA statement used (Total process time):
real time 10.15 seconds
cpu time 0.00 seconds

13
14 rsubmit _01 wait=no macvar=JOB01 signonwait=y persist=n;
2 The SAS System 18:07 Thursday, June 18, 2009

NOTE: Background remote submit to _01 in progress.
15
16 data _null_;
17 call sleep (20,1);
18 run;

NOTE: Remote submit to _01 commencing.

NOTE: There were 10 observations read from the data set TESTINE.CONF_ACTION_TYPES.
NOTE: DATA statement used (Total process time):
real time 0.08 seconds
cpu time 0.02 seconds

NOTE: Remote submit to _01 complete.
NOTE: Remote signoff from _01 commencing.
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 10.53 seconds
cpu time 0.14 seconds

NOTE: Remote signoff from _01 complete.
NOTE: DATA statement used (Total process time):
real time 20.01 seconds
cpu time 0.02 seconds

ERROR: Errors printed on page 1.

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 31.12 seconds
cpu time 0.27 seconds

Re: SAS Multiprocessing/inherit meta library error

DanielSantos — Thu, 18 Jun 2009 15:57:15 GMT

I suspect you're having trouble, because you're trying to inherit a "special" library (metadata engine) which is by definition a remote lib in the metadata server. So you're trying to remotely access a remote library.

For example, inheritlib will not work if you try to remote signon form another remote session (but will work fine if from within a local session).

Try to remove the testine from your script, and see if the problem persists.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt

Re: SAS Multiprocessing/inherit meta library error

SAS_user — Thu, 18 Jun 2009 18:46:19 GMT

Thank You for your answer Daniel.

But if you look at my post more closely, You would see, that i use inherited library
and I use it successfully.

Here is code:
rsubmit _01 wait=no macvar=JOB01 signonwait=y persist=n;
data _null_;
set testine.Conf_action_types(obs = 10);
run;
endrsubmit;

and here is the log output:
NOTE: Remote submit to _01 commencing.

NOTE: There were 10 observations read from the data set TESTINE.CONF_ACTION_TYPES.
NOTE: DATA statement used (Total process time):
real time 0.08 seconds
cpu time 0.02 seconds

NOTE: Remote submit to _01 complete.
NOTE: Remote signoff from _01 commencing.
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 10.53 seconds
cpu time 0.14 seconds

NOTE: Remote signoff from _01 complete.

Re: SAS Multiprocessing/inherit meta library error

sbb — Thu, 18 Jun 2009 19:15:22 GMT

It's time to consider opening a SAS track (support issue) for your problem, providing detailed SAS code and SAS log information, to investigate/resolve your problem further.

Scott Barry
SBBWorks, Inc.

Re: SAS Multiprocessing/inherit meta library error

SAS_user — Fri, 19 Jun 2009 06:49:10 GMT

How can i do that?

Re: SAS Multiprocessing/inherit meta library error

DanielSantos — Fri, 19 Jun 2009 08:32:31 GMT

> Thank You for your answer Daniel.
>
> But if you look at my post more closely, You would
> see, that i use inherited library
> and I use it successfully.
>
> Here is code:
> rsubmit _01 wait=no macvar=JOB01 signonwait=y
> persist=n;
> data _null_;
> set testine.Conf_action_types(obs = 10);
> run;
> endrsubmit;
>
> and here is the log output:
> NOTE: Remote submit to _01 commencing.
>
> NOTE: There were 10 observations read from the
> data set TESTINE.CONF_ACTION_TYPES.
> NOTE: DATA statement used (Total process time):
> real time 0.08 seconds
> cpu time 0.02 seconds
>
>
> NOTE: Remote submit to _01 complete.
> NOTE: Remote signoff from _01 commencing.
> NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC
> USA 27513-2414
> NOTE: The SAS System used:
> real time 10.53 seconds
> cpu time 0.14 seconds
>
> NOTE: Remote signoff from _01 complete.

Yes, but this doesn't mean it's officially supported.
There are many SAS features available that are not yet fully supported.

You probably won't get that error if you remove the testine.

Scott is right, you should open a track to clarify this situation (if metalibs can be inherited or not, and if positive, why do you get this error).

Check the FAQ's for Tracks here:
http://support.sas.com/techsup/opentrackshelp.html

Cheers from Portugal.

Daniel Santos @ www.cgd.pt