12-11-2012 11:37 AM
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***
12-11-2012 06:28 PM
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?
12-11-2012 06:36 PM
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.
12-11-2012 08:26 PM
Your libname looks like not right.
LIBNAME MYLIB META library="Oracle Library" server="sasbi.demo.sas.com" port="8561" user="sasbi\sas" password=XXXXXXXXXX ;
12-12-2012 01:05 AM
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.
12-12-2012 06:39 PM
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 = ....;