topic Re: Develop a macro to pull out information about libraries from a server in SAS Programming https://communities.sas.com/t5/SAS-Programming/Develop-a-macro-to-pull-out-information-about-libraries-from-a/m-p/158565#M30975 <HTML><HEAD></HEAD><BODY><P>Use PROC SQL and query DICTIONARY.LIBNAMES.</P><P>DICTIONARY.TABLES is a more neat choice than PROC CONTENTS if yo ask me.</P></BODY></HTML> Mon, 09 Feb 2015 15:39:14 GMT LinusH 2015-02-09T15:39:14Z Develop a macro to pull out information about libraries from a server https://communities.sas.com/t5/SAS-Programming/Develop-a-macro-to-pull-out-information-about-libraries-from-a/m-p/158564#M30974 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Please help me.</P></BODY></HTML> Mon, 09 Feb 2015 07:18:26 GMT https://communities.sas.com/t5/SAS-Programming/Develop-a-macro-to-pull-out-information-about-libraries-from-a/m-p/158564#M30974 Rabindra 2015-02-09T07:18:26Z Re: Develop a macro to pull out information about libraries from a server https://communities.sas.com/t5/SAS-Programming/Develop-a-macro-to-pull-out-information-about-libraries-from-a/m-p/158565#M30975 <HTML><HEAD></HEAD><BODY><P>Use PROC SQL and query DICTIONARY.LIBNAMES.</P><P>DICTIONARY.TABLES is a more neat choice than PROC CONTENTS if yo ask me.</P></BODY></HTML> Mon, 09 Feb 2015 15:39:14 GMT https://communities.sas.com/t5/SAS-Programming/Develop-a-macro-to-pull-out-information-about-libraries-from-a/m-p/158565#M30975 LinusH 2015-02-09T15:39:14Z Re: Develop a macro to pull out information about libraries from a server https://communities.sas.com/t5/SAS-Programming/Develop-a-macro-to-pull-out-information-about-libraries-from-a/m-p/158566#M30976 <HTML><HEAD></HEAD><BODY><P>Or SASHELP.VTABLES/VCOLUMNS which is pretty much the same thing.&nbsp; Not sure why you'd need a macro for this task?</P></BODY></HTML> Mon, 09 Feb 2015 15:59:35 GMT https://communities.sas.com/t5/SAS-Programming/Develop-a-macro-to-pull-out-information-about-libraries-from-a/m-p/158566#M30976 RW9 2015-02-09T15:59:35Z