Sticky-note

The SELECT clause selects the MEMNAME and MEMTYPE columns. The FROM clause specifies DICTIONARY.MEMBERS as the table to select from. The WHERE clause subsets the output to include only those rows that have a libref of PROCLIB in the LIBNAME column.

   title 'SAS Files in the PROCLIB Library';
   select memname, memtype
      from dictionary.members
      where libname='PROCLIB';