学步园

*得到库信息;
proc sql;
   select * from dictionary.dictionaries;
quit;
*获取查询表名;
proc sql;
   select unique memname from dictionary.dictionaries;
quit;
*or;
proc sql;
   select memname from dictionary.members;
quit;
*将获取的表名信息存表;
proc sql;
   create table dmembers as
   select memname from dictionary.members;
quit;
*描述查询库内工具的信息;
proc sql;
   describe table dictionary.columns;
quit;

proc sql;
   describe table dictionary.tables;
quit;

proc sql;
   describe table dictionary.members;
quit;

更多信息可见“The SAS® Magical Dictionary Tour”文章。