SAS Utility Proc 2 SQL.pptVIP

SAS Dictionary How to View SAS DICTIONARY Tables Each DICTIONARY table has an associated PROC SQL view in the SASHELP library. There are two ways to access the DICTIONARY tables: Access through procedures and data STEPS syntax using views provided by SAS in the SASHELP library. Read directly using PROC SQL. SAS Dictionary List of DICTIONARY Tables and SASHELP Views SAS Dictionary Example proc sql; create table table as select memname, memtype, nobs, nvar, crdate from dictionary.tables where libname = A; quit; SAS Dictionary Example proc sql; create table column as select * from d