ACCESS DICTIONARY TABLES IN YOUR SAS SESSION SAS

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

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

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏1 回帖

关键词：Dictionary session access tables Acces