Chapter 8 - Managing Processing Using PROC SQL
Querying a Table Using PROC SQL Options
proc sql outobs=5;
select flightnumber, destination
from sasuser.internationalflights;
reset number;
select flightnumber, destination
from sasuser.internationalflights
where boarded gt 200;
quit;
Describing and Querying a Dictionary Table
proc sql;
describe table dictionary.columns;
select memname
from dictionary.columns
where libname='SASUSER'
and name='EmpID';
quit;
describe table dictionary.columns 기출 문제 확인!!
Dictionary table contains
1. information about SAS libraries.
2. information about SAS data sets.
3. information about SAS macros.
Dictionary tables are
1. created each time they are referenced in a SAS program.
2. updated automatically.
3. limited to Read-Only access.
Dictionary tables can be accessed by running a PROC SQL query against the table, using the Dictionary libref.
Though SAS librefs are usually limited to eight characters, Dictionary is an automatically assigned, reserved word. You can also access a Dictionary table by referring to the PROC SQL view of the table that is stored in the Sashelp library
