/*****************************************************************************************************************

SAS file name: metadata
File location: 
_________________________________________________________________________________________________________________

Purpose: To demonstrate how to extract meta data in sas with the Dictionary Tables and SASHELP Views
Author: Peter Clemmensen
Creation Date: 06/05/2019

This program supports the example page "Read SAS Metadata with Dictionary Tables and SASHELP Views" on SASnrd.com

*****************************************************************************************************************/

/* Dictionary Tables */
proc sql;
   describe table dictionary.columns;
quit;

/* Dictionary.Columns */
proc sql;
   select *
   from dictionary.columns
   where libname='SASHELP'
     and memname='CLASS';
quit;

/* Dictionary.Tables */
proc sql;
   create table DicTables as
   select *
   from dictionary.tables
   where libname='SASHELP'
     and memtype='DATA';
quit;

/* SASHELP Views */
proc contents data=sashelp.vcolumn;
run;

data ViewColumns;
   set sashelp.vcolumn;
   where libname='SASHELP' and memname='CLASS';
run;

data ViewTables;
   set sashelp.vtable;
   where libname='SASHELP'
     and memtype='DATA';
run;