Dictionary table
|
Sashelp view
|
Contains
|
---|---|---|
Catalogs
|
Vcatalg
|
information about catalog
entries
|
Columns
|
Vcolumn
|
detailed information
about variables and their attributes
|
Extfiles
|
Vextfl
|
currently assigned filerefs
|
Indexes
|
Vindex
|
information about indexes
defined for data files
|
Macros
|
Vmacro
|
information about both
user and system defined macro variables
|
Members
|
VmemberVsaccesVscatlgVslibVstableVstabvwVsview
|
general information
about data library members
|
Options
|
Voption
|
current settings of
SAS system options
|
Tables
|
Vtable
|
detailed information
about data sets
|
Titles
|
Vtitle
|
text assigned to titles
and footnotes
|
Views
|
Vview
|
general information
about data views
|
proc sql; describe table dictionary.tables;
create table DICTIONARY.TABLES ( libname char(8) label='Library Name', memname char(32) label='Member Name', memtype char(8) label='Member Type', memlabel char(256) label='Dataset Label', typemem char(8) label='Dataset Type', crdate num format=DATETIME informat=DATETIME label='Date Created', ...); |
proc sql; select memname format=$20., nobs, nvar, crdate from dictionary.tables where libname='SASUSER';Partial output is shown below.
nobs
value
for ALL is missing because it is a view, not a table.
proc sql; describe table dictionary.columns;
create table DICTIONARY.COLUMNS ( libname char(8) label='Library Name', memname char(32) label='Member Name', memtype char(8) label='Member Type', name char(32) label='Column Name', type char(4) label='Column Type', length num label='Column Length', ...); |
proc sql; select memname from dictionary.columns where libname='SASUSER' and name='EmpID';
proc print data=sashelp.vcolumn; var memname; where libname='SASUSER' and name='EmpID'; run;