topic Re: Metadata Library Names in Developers

Metadata Library Names

SP_RANDE — Sat, 01 Sep 2007 04:51:49 GMT

Hello!

I have to retrieve all the metadata library names that were already defined under a metadata server. Each library is defined to its physical location and a few datasets already imported under each library.

How can I retrieve all Metadata library names into a macro variable or display using an sql would also be fine.

Any help is greatly appreciated!

Raja

Re: Metadata Library Names

Cynthia_sas — Sat, 01 Sep 2007 18:37:52 GMT

Hi:
I do not believe it is possible to -easily- get this information into a single macro variable or even multiple macro variables or to do an SQL query against the Metadata repository. Both DI Studio and SAS Management Console will show you the property information for the data libraries that have been defined to the Metadata repository. In addition, DIStudio provides a way that you can EXPORT library object information into an XML file format.

You might consider contacting Tech Support for more help. They would know whether there are any utility programs that a SAS Administrator could use to report on this kind of information.

cynthia

Re: Metadata Library Names

deleted_user — Mon, 03 Sep 2007 08:02:11 GMT

Hi Raja,
You could try this SAS code for a start:

options MetaServer="localhost"
MetaPort=8561
MetaUser="sasadm"
MetaPass="XXXXXX"
MetaRepository="Foundation"
MetaProtocol=BRIDGE;

/*file gets created under C:\WINDOWS\system32*/
filename xmlout 'SASLibrary_Base.xml' ;
filename inxmlb temp;

data _null_;
file inxmlb;
input;
put _infile_;
cards;

$METAREPOSITORY
SASLibrary

SAS
388

;;

PROC METADATA
IN=inxmlb
out = xmlout verbose;
run;

Here's more info:
http://support.sas.com/onlinedoc/913/getDoc/en/omags.hlp/a003159943.htm

Re: Metadata Library Names

Cynthia_sas — Mon, 03 Sep 2007 14:53:03 GMT

Hi:
I highly recommend that you contact a SAS Administrator at your site because this information is very specific to your installation:
[pre]
options MetaServer="localhost"
MetaPort=8561
MetaUser="sasadm"
MetaPass="XXXXXX"
MetaRepository="Foundation"
MetaProtocol=BRIDGE;
[/pre]

For example, your install people might not have used port 8561 for the Metadata server. They may have not have used a "SASADM" user-id for the administrator user-id or set a different user id with administrative privileges. Your Repository may not be called Foundation. Your server may not be on "localhost". And, last, but not least, you need to know the the right password for the user-id that must be used.

cynthia

Re: Metadata Library Names

SP_RANDE — Tue, 04 Sep 2007 03:36:34 GMT

I have the correct Metadata Server and User info that I can apply for these options.
Thank you for sending this and I wil try this out and see what I can get and update back here.

I appreciate your help!
Raja

Re: Metadata Library Names

deleted_user — Tue, 22 Dec 2009 14:26:54 GMT

Can a metadata server used in maintaining SAS earlier version servers can be used for latest SAS version 9.2

Re: Metadata Library Names

Vince_SAS — Tue, 22 Dec 2009 16:23:20 GMT

Any metadata servers prior to SAS 9.2 will need to upgraded in order to support SAS 9.2. There have been significant changes in SAS 9.2 to support additional functionality, improved performance, and simplified administration.

To understand what is involved in upgrading from a previous version, please visit our SAS 9.2 Migration site at:

http://support.sas.com/rnd/migration/index.html

Vince DelGobbo
SAS R&D