Develop a macro to pull out information about libraries from a server

[Rabindra]

I am looking to develop a macro program to pull the memtype information from the server automatically. If I use Proc contents procdure so every time I have to enter the libref name, I am looking for a program that will look into the server name and pull out list of libraries along with the libref, schema details and path.

Please help me.

[LinusH]

Use PROC SQL and query DICTIONARY.LIBNAMES.

DICTIONARY.TABLES is a more neat choice than PROC CONTENTS if yo ask me.

[RW9]

Or SASHELP.VTABLES/VCOLUMNS which is pretty much the same thing.  Not sure why you'd need a macro for this task?