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.
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.
I highly recommend that you contact a SAS Administrator at your site because this information is very specific to your installation:
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.
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: