topic SAS BASE CONENCTION TO METADATA SERVER in SAS Procedures

SAS BASE CONENCTION TO METADATA SERVER

sas_9 — Tue, 11 Dec 2012 16:37:27 GMT

hi all,

i am using sas 9.3. (foundation) i have also sas eg 5.1. i have created couple of base and odbc libraries from sas mc on sas server. sas eg is working great with metadata server and all but i wants to conenct sas base (Foundation 9.3) to metadata server (remote machine) so that i can access all the base libraries that i have created on server. I can connect odbc libraries by using "libname" statement, userid and psw. but when i wants to connect to base library by using libname statement its giving me error as follow.

libname sandip base 'd:\pdata\sandip';

ERROR: Libname SANDIP not available for use.

ERROR: Error in the LIBNAME statement.

***here, d:\pdata\sandip' is the physical path for library "sandip" on server***

****if i use sas base (foundation 9.3) on the server then it works fine***

***but not working from client/local machine***

Re: SAS BASE CONENCTION TO METADATA SERVER

sassharp — Tue, 11 Dec 2012 17:02:41 GMT

libname should be 8 characters long only

Re: SAS BASE CONENCTION TO METADATA SERVER

sas_9 — Tue, 11 Dec 2012 17:09:07 GMT

libname is "sandip"

thanks

Re: SAS BASE CONENCTION TO METADATA SERVER

sassharp — Tue, 11 Dec 2012 17:15:01 GMT

did you ASSIGN the library from metadata side?

When you right click on the library in EG you see assign. Choose assign.

Re: SAS BASE CONENCTION TO METADATA SERVER

sas_9 — Tue, 11 Dec 2012 17:44:20 GMT

i have all the library as "preassigned"

Re: SAS BASE CONENCTION TO METADATA SERVER

twocanbazza — Tue, 11 Dec 2012 23:28:08 GMT

because on your local machine d: is probably defined as something else, try using UNC ir \\servername\d$ or something like that...

also why do you want to access a server library from local?

Re: SAS BASE CONENCTION TO METADATA SERVER

SASKiwi — Tue, 11 Dec 2012 23:36:36 GMT

A couple of things to check out:

1) In Management Console ensure that the server being assigned to the library is your SAS Compute server, usually called SASApp (don't assign to your meta data server).

2) Confirm in the Authorisation tab of your library definition that your userid is in one of the user groups that has permission to read this library.

Re: SAS BASE CONENCTION TO METADATA SERVER

Ksharp — Wed, 12 Dec 2012 01:26:30 GMT

Your libname looks like not right.

LIBNAME MYLIB META library="Oracle Library" server="sasbi.demo.sas.com" port="8561" user="sasbi\sas" password=XXXXXXXXXX ;

Ksharp

Re: SAS BASE CONENCTION TO METADATA SERVER

Prit — Wed, 12 Dec 2012 06:05:04 GMT

There is separate licence available to access PC based files.

If you have that licence to access PC based file then you should able to connect to PC based files.

-Prit

Re: SAS BASE CONENCTION TO METADATA SERVER

twocanbazza — Wed, 12 Dec 2012 23:39:44 GMT

re reading your question " sas eg is working great with metadata server and all but i wants to conenct sas base (Foundation 9.3) to metadata server" your base sas needs to know about the metadata server etc,

You'll need something like

/* Create metadata macro variables */
%let metaPort = %nrquote(8561);
%let metaServer = %nrquote(servername);

/* Set metadata options */
options metaport = &metaPort
metaserver = "&metaServer";

Then you can do a libname using libname libref META library = ....;

Barry