Dictionary.Catalogs

/*
DICTIONARY.TABLES
--------------------
LIBNAME char(8) label='Library Name',
MEMNAME char(8) label='Member Name',
MEMTYPE char(8) label='Member Type',
MEMLABEL char(40) label='Dataset Label',
TYPEMEM char(8) label='Dataset Type',
CRDATE num format=DATETIME label='Date Created',
MODATE num format=DATETIME label='Date Modified',
NOBS num label='Number of Observations',
OBSLEN num label='Observation Length',
NVAR num label='Number of Variables',
PROTECT char(3) label='Type of Password Protection',
COMPRESS char(8) label='Compression Routine',
REUSE char(3) label='Reuse Space',
BUFSIZE num label='Bufsize',
DELOBS num label='Number of Deleted Observations',
INDXTYPE char(9) label='Type of Indexes'


DICTIONARY.CATALOGS
-----------------------
LIBNAME char(8) label='Library Name',
MEMNAME char(8) label='Member Name',
MEMTYPE char(8) label='Member Type',
OBJNAME char(8) label='Object Name',
OBJTYPE char(8) label='Object Type',
OBJDESC char(40) label='Object Description',
MODIFIED char(8) label='Date Modified',
ALIAS char(8) label='Object Alias'

DICTIONARY.COLUMNS
-------------------
LIBNAME char(8) label='Library Name',
MEMNAME char(8) label='Member Name',
MEMTYPE char(8) label='Member Type',
NAME char(8) label='Column Name',
TYPE char(4) label='Column Type',
LENGTH num label='Column Length',
NPOS num label='Column Position',
VARNUM num label='Column Number in Table',
LABEL char(40) label='Column Label',
FORMAT char(16) label='Column Format',
INFORMAT char(16) label='Column Informat',
IDXUSAGE char(9) label='Column Index Type'


DICTIONARY.EXTFILES
FILEREF char(8) label='Fileref',
XPATH char(80) label='Path Name',
XENGINE char(8) label='Engine Name'


DICTIONARY.INDEXES
LIBNAME char(8) label='Library Name',
MEMNAME char(8) label='Member Name',
MEMTYPE char(8) label='Member Type',
NAME char(8) label='Column Name',
IDXUSAGE char(9) label='Column Index Type',
INDXNAME char(8) label='Index Name',
INDXPOS num label='Pos. of Column in Concatenated Key',
NOMISS char(3) label='Nomiss Option',
UNIQUE char(3) label='Unique Option'

DICTIONARY.MEMBERS
LIBNAME char(8) label='Library Name',
MEMNAME char(8) label='Member Name',
MEMTYPE char(8) label='Member Type',
ENGINE char(8) label='Engine Name',
INDEX char(8) label='Indexes',
PATH char(80) label='Path Name'


DICTIONARY.OPTIONS
OPTNAME char(16) label='Session Option Name',
SETTING char(200) label='Session Option Setting',
OPTDESC char(80) label='Option Description'


DICTIONARY.VIEWS
LIBNAME char(8) label='Library Name',
MEMNAME char(8) label='Member Name',
MEMTYPE char(8) label='Member Type',
ENGINE char(8) label='Engine Name'
DICTIONARY.TITLES
TYPE char(1) label='Title Location',
NUMBER num label='Title Number',
TEXT char(200) label='Title Text'


DICTIONARY.MACROS
SCOPE char(9) label='Macro Scope',
NAME char(8) label='Macro Variable Name',
OFFSET num label='Offset into Macro Variable',
VALUE char(200) label='Macro Variable Value'


*/


/*create macro vars by proc SQL */
proc sql noprint;
select memlabel into :dslabel
from   dictionary.tables
where libname='SASHELP' and memname='RETAIL';
quit;