General form, MSGLEVEL=
option:
OPTIONS MSGLEVEL=N | I;
N
displays notes, warnings,
and error messages only. This is the default.
I
displays additional
notes pertaining to index usage, merge processing, and sort utilities
along with standard notes, warnings, and error messages.
|
options msglevel=i;
proc sql;
select *
from marchflights
where flightnumber='182';
proc sql; select * from marchflights where flightnumber in ('182','202'),
INFO: Index daily not used. Sorting into index order may help. INFO: Index daily not used. Increasing bufno to 8 may help. |
General form, IDXWHERE=
option:
IDXWHERE=YES | NO;
YES
tells SAS to choose
the best index to optimize a WHERE expression, and to disregard the
possibility that a sequential search of the table might be more resource-efficient.
NO
tells SAS to ignore
all indexes and satisfy the conditions of a WHERE expression with
a sequential search of the table.
|
options msglevel=i; proc sql; select * from marchflights where flightnumber='182';
proc sql;
select *
from marchflights (idxwhere=no)
where flightnumber='182';
General form, IDXNAME=
option:
IDXNAME=index-name;
index-name
specifies the name
of the index that should be used for processing.
|
proc sql; create index Date on work.marchflights(Date);
proc sql;
select *
from marchflights
where date='01MAR2000'd;
proc sql;
select *
from marchflights (idxname=daily)
where flightnumber='182';