02-09-2015 02:18 AM
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.
02-09-2015 10:39 AM
Use PROC SQL and query DICTIONARY.LIBNAMES.
DICTIONARY.TABLES is a more neat choice than PROC CONTENTS if yo ask me.
02-09-2015 10:59 AM
Or SASHELP.VTABLES/VCOLUMNS which is pretty much the same thing. Not sure why you'd need a macro for this task?