SAS code to get all the table name under the library

Issue:

SAS Admins were usually asked how many libraries do we have? What are the tables under the library? Here is the code to get all the table name under the library.

Solution:

Say I have a library named as Oracle Scoring and its libref is orascore then my code will be

PROC SQL;
     SELECT *
     FROM sashelp.vmember
     WHERE libname = "orascore "
  ;
QUIT;

In above code you need to just replace orascore with the libref of your library in your environment. 

If you want to search for the table with specific pattern then you can use below code

PROC SQL;
     SELECT *
     FROM sashelp.vmember
     WHERE libname = "orascore " and memname like "pattern"
  ;
QUIT;