SAS users can quickly and conveniently obtain useful information abouttheir SAS session with a number of read-only SAS DICTIONARY tables orSASHELP views. At any time during a SAS session, information aboutcurrently defined system options, libnames, tables, columns and theirattributes, formats, indexes, and more can be accessed and captured
ALL INFORMATION IS DYNAMIC IN YOUR SAS SESSION.
PROC SQL;
SELECT UNIQUE MEMNAME
FROM DICTIONARY.DICTIONARIES;
QUIT;
THE SAME INFORMATION IS ALSO AVAILABE IN SASHELP.VDCTNRY.
PROC PRINT DATA= SASHELP.VDCTNRY;
RUN;
PROC SQL NOPRINT;
SELECT STRIP(NAME) INTO: NAMELIST SEPARATED BY ' '
FROM DICTIONARY.COLUMNS
WHERE LIBNAME='SASHELP' AND MEMNAME='CLASS';
QUIT;
%PUT >>>>&NAMELIST<<<<;
PROC SQL NOPRINT;
SELECT STRIP(NAME) INTO: NAMELIST SEPARATED BY ' '
FROM SASHELP.VCOLUMN
WHERE LIBNAME='SASHELP' AND MEMNAME='CLASS';
QUIT;
%PUT >>>>&NAMELIST<<<<;