SAS
Base SAS and 3
concepts 10
SAS/ACCESS LIBNAME statement 569
embedding in PROC SQL views 570
SAS/ACCESS software
definition 569
SAS/ACCESS views 546
passwords with 593
SAS ARM interface 226, 228
SAS catalogs
See catalogs
SAS data files
See data files
SAS data libraries
See data libraries
SAS data sets
See data sets
SAS data views 5, 481
See also data views
as DATA step output 13
input to SAS programs 12
SAS Explorer window
list of available styles 186
SAS formatted destinations 181, 182
SAS language 4
components of 4
data sets 5
DBMS files 6
elements 6, 25
external files 5
files 4
macro facility 6
SAS processing 11
DATA step 13
inputdata sources 12
PROC steps 14
SAS registry
See registry
SAS regular expression (RX) functionsand CALL routines 45
SAS Scalable Performance DataEngine 603
SAS sessions 7
batch mode 9
customizing 9
customizing windowing environment 10
default system option settings 9
executing statements automatically 9
interactive line mode 8
noninteractive line mode 8
starting 7
types of 7
windowing environment 7
SAS statements
See statements
SAS utilities
for data libraries 477
SAS windowing environment 7, 283, 307
assigning passwords with 590
customizing 10
drop-down menus 285
Explorer window 291
features 284
help 287, 288
keyboard equivalents, z/OS 284
Keys window 304
Log window 299
New Library window 302
Output window 300
pop-up menus 286
Program Editor window 298
Properties window 303
Results window 301
toolbars 287
window commands 288
windows 288, 290
SAS XML LIBNAME engine 605
SASFILE statement
I/O optimization and 219
SASHELP library 476
registry files in 236
SASUSER library 476
registry files in 236
SASUSER registry
backing up 239
Sasuser.Profile catalog 563
scientific notation 90
numeric constants in 113
SCL
creating integrity constraints 513
enabling ARM macro execution 66
search time
reducing for executables 220
selection lists 190
destinations for output objects 191
sequential access
combining data sets 394
engines 600
sequential data libraries 476
SET statement
concatenating data sets 402
interleaving data sets 405
one-to-one reading 409
SMTP e-mail 619
statements for controlling 620
system options for 619
sorting column values 315
sorting indexed data files 536
sorting observations
for BY- group processing 379
special missing values 106
special SAS name lists 88
SQL
concatenating data sets 404
SQL procedure
creating indexes 526
creating integrity constraints 512
list of available styles 186
SQL Procedure Pass-Through Facility 571
statements 69
changing DATA step execution sequence 338
combining data sets with 398
DATA step statements 69
declarative 69
default executionin DATA step 337
executable 69
executing automatically 9
global, definition 70
options compared with system options 76
step boundaries 340
word spacing in 17
statistics
performance statistics 213
stored compiled programs 4, 547
CPU performance and 220
creating 549
examples 549, 553, 554
executing 550
global statements for execution 552
printing source code 552
processing 548
quality control application 554
redirecting output 552
restrictionsand requirements 548
uses for 547
vs. DATA step views 542, 554
style attributes 184
definition 186
style definitions
definition of 185
procedures with 187
SAS-supplied 186
style elements
definition 185
subsetting IF statement
vs. WHERE expression 211
syntax check mode 156
enabling 157
%SYSFUNC function
specifying formats 28
system libraries 474
SASHELP 476
SASUSER 476
USER 475
WORK 474
system options 71
altering log contents with 166
ARM 226, 228
changing settings 73
compared with data set options 76
compared with statement options 76
customizing log appearance with 166
default settings 9, 71
determining how value was set 72
determining settings in effect 71
duration of settings 74
for error handling 158
getting descriptive information about 73
interaction with data set options 26, 75
order of precedence 75
restricted options 72
syntax 71
Universal Printing 273
system performance 213
calculating data set size 221
CPU performance 220
memory usage 220
optimizing I/O 215
performance statistics 214