BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Looking for experiences with MP Connect.

More specifically with using libname SASESOCK "mypipe"; style of piping.
This requires use of an Open SAS Meta Data Server.
This is totally new to me, as I don't want to have to preconfigure pipes to use.

So, what options do I need to set where?
What do I need to know about setting up/using a SAS Metadata server for this?
any other details/gotcha's I should know about?
5 REPLIES 5
deleted_user
Not applicable
[pre]
ERROR: Unable to resolve pipe name, mypipe, in the SAS Meta Data Server. Error message from Name Server component of Meta Data
Server is:
Unable to bind to Domain Name Server. Check the values of META* options and check that the server is running.
[/pre]

I have specified all the options needed, I thought:

[pre]
options metaserver="sas_metaserver" metauser="&user" metapass="&password" metarepository="Foundation" metaport=8561 metaprotocol=bridge;

PROC METAOPERATE
SERVER="sas_metaserver"
PORT=8561
USERID="&user"
PASSWORD="&password"
PROTOCOL=BRIDGE
ACTION=STATUS;
RUN;

libname outLib sasesock "mypipe" timeout=20;
libname outlib list;

data outLib.Intermediate;
do i=1 to 5;
put 'Writing row ' i;
output;
end;
run;
quit;
[/pre]

The "PROC METAOPERATE" works just fine.
When I try to use "outlib" I get the above error.
So what am I missing?

The documentation for this use of SASESOCK is woefully lacking in how to make use of a metadata server for storing the autoassigned port.
DanielSantos
Barite | Level 11
Hi Chuck.

No need of Metadata Server for pipe parallelism, just need an available network port to use and SAS/CONNECT product licensed.

The port can be explicitly specified, or you could assign it a name through the SERVICES file.

Check this paper:
http://support.sas.com/rnd/papers/sugi30/pipeline.pdf

Be aware that this technique relies totally on your system multitasking capabilities.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt
DanielSantos
Barite | Level 11
OK forget it.

I figured out what you are trying to do.

Have you set the connection options previously?
[pre]
options metaserver="a123.us.company.com"
metaport=9999
metauser="metaid"
metapass="metapwd"
metaprotocol=bridge
metarepository="myrepos";
[/pre]
Also the documentation states, that you shouldn't have the same alias in the SERVICES file.

Cheers from Portugal.

Daniel Santos @ www.cgd.pt
deleted_user
Not applicable
I've had metarepository=default and metarepository=Foundation.

As you can see from the code, I am setting the options prior to their use.

The METAOPERATE works fine and returns what it is supposed to, so the server, port, user, pass and protocol are all set properly.
deleted_user
Not applicable
SAS Support got me going, finally.

It was about specifying the right mix of options:

[pre]
options metaserver='local_meta_server';
options metaport=8561;
options metaprotocol='BRIDGE';
options metauser="&user";
options metapass="&password";
[/pre]

I was also getting confused by the timing/ordering of the log messages due to the asynchronous rsubmit(s).

sas-innovate-2024.png

Today is the last day to save with the early bird rate! Register today for just $695 - $100 off the standard rate.

 

Plus, pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 834 views
  • 0 likes
  • 2 in conversation