sas中的sql(8)sql选项解析,数据字典

proc sql outobs=5;
select flightnumber, destination
from sasuser.internationalflights;
reset number;
select flightnumber, destination
from sasuser.internationalflights
where boarded gt 200;
quit;

proc sql number;
select name, address, city, state, zipcode
from sasuser.frequentflyers;
reset nonumber;
select name, address, city, state, zipcode
from sasuser.frequentflyers
where pointsearned gt 7000
and pointsused lt 3000;
quit;

proc sql;
    describe table dictionary.tables;
quit;

/*这里是一部分关于表的描述信息*/
create table DICTIONARY.TABLES
  (
   libname char(8) label=‘Library Name‘,
   memname char(32) label=‘Member Name‘,
   memtype char(8) label=‘Member Type‘,
   dbms_memtype char(32) label=‘DBMS Member Type‘,
   memlabel char(256) label=‘Data Set Label‘,
   typemem char(8) label=‘Data Set Type‘,
   crdate num format=DATETIME informat=DATETIME label=‘Date Created‘,
   modate num format=DATETIME informat=DATETIME label=‘Date Modified‘,
   nobs num label=‘Number of Physical Observations‘,
   obslen num label=‘Observation Length‘,
   nvar num label=‘Number of Variables‘,
   protect char(3) label=‘Type of Password Protection‘,
   compress char(8) label=‘Compression Routine‘,
   encrypt char(8) label=‘Encryption‘,
   .......
);

/*我们选择库SASUSER中的所有表，以及他们的观测值数量，变量数，和建表日期等变量*/
proc sql;
select memname format=$20., nobs, nvar, crdate
from dictionary.tables
where libname=‘SASUSER‘;

/*查询SASUSER库中含有列EmpID的所有表名*/
proc sql;
select memname
from dictionary.columns
where libname=‘SASUSER‘
and name=‘EmpID‘;