SAS: dictionary.catalogs

Describe

proc sql;
  describe table dictionary.catalogs;
quit;

/*
create table DICTIONARY.CATALOGS
  (
   libname char(8) label='Library Name',
   memname char(32) label='Member Name',
   memtype char(8) label='Member Type',
   objname char(32) label='Object Name',
   objtype char(8) label='Object Type',
   objdesc char(256) label='Object Description',
   created num format=DATETIME informat=DATETIME label='Date Created',
   modified num format=DATETIME informat=DATETIME label='Date Modified',
   alias char(32) label='Object Alias',
   level num label='Library Concatenation Level'
  );
  */

Show available macros

proc sql;

/* Why oh why is such a simple query soooo slooooow? */

   select
     libname,
     objname  as macro_name,
     objdesc,
     created,
     modified
/*   alias  ,
     level   */
   from
     dictionary.catalogs;
   where
/*   libname = 'WORK'     and     */
     memname = 'SASMAC1'  and  /* */
     memtype = 'CATALOG'  and
     objtype = 'MACRO';

quit;

Distinct »object« types

proc sql flow=100;
  select
    distinct
    objtype
  from
    dictionary.catalogs
  group by
    objtype;
quit;
/*
AMETHOD
CLASS
CLASSPKG
CSV
DATAFORM
DEV
DEVMAP
DICTNARY
EDPARMS
EIS
ENGINE
FILEFMT
FOLDER
FONT
FONTLIST
FORM
FORMAT
FORMATC
FRAME
GIF
HELP
HTML
IMAGE
IMOD
INFMT
INFMTC
INTRFACE
INVEST
JPEG
KEYMAP
KEYS
LAYOUT
LIST
LOG
MACRO
MENU
OUTPUT
PCL
PDF
PMENU
PROGRAM
PSL
RANGE
RESOURCE
RTF
SCL
SCREEN
SLIST
SOURCE
SYSTEM
TEMPLATE
TOOLBOX
TOOLSET
TRANTAB
XML
*/

See also