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<<<<;