DATA Step, Macro, Functions and more

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

Reply
New Contributor
Posts: 2

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

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.

Super User
Posts: 5,427

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

Use PROC SQL and query DICTIONARY.LIBNAMES.

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

Data never sleeps
Super User
Super User
Posts: 7,945

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

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

Ask a Question
Discussion stats
  • 2 replies
  • 177 views
  • 0 likes
  • 3 in conversation