Help using Base SAS procedures

SAS BASE CONENCTION TO METADATA SERVER

Reply
Regular Contributor
Posts: 220

SAS BASE CONENCTION TO METADATA SERVER

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***


Frequent Contributor
Posts: 110

Re: SAS BASE CONENCTION TO METADATA SERVER

libname should be 8 characters long only

Regular Contributor
Posts: 220

Re: SAS BASE CONENCTION TO METADATA SERVER

libname is "sandip"

thanks

Frequent Contributor
Posts: 110

Re: SAS BASE CONENCTION TO METADATA SERVER

did you ASSIGN the library from metadata side?

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

Regular Contributor
Posts: 220

Re: SAS BASE CONENCTION TO METADATA SERVER

i have all the library as "preassigned"

Super Contributor
Posts: 356

Re: SAS BASE CONENCTION TO METADATA SERVER

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?

Super User
Posts: 3,100

Re: SAS BASE CONENCTION TO METADATA SERVER

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.

Super User
Posts: 9,656

Re: SAS BASE CONENCTION TO METADATA SERVER

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

Occasional Contributor
Posts: 5

Re: SAS BASE CONENCTION TO METADATA SERVER

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

Super Contributor
Posts: 356

Re: SAS BASE CONENCTION TO METADATA SERVER

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 serveryour 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


Ask a Question
Discussion stats
  • 9 replies
  • 485 views
  • 0 likes
  • 6 in conversation