Index 335
Index
A
ACCDESC= option, PROC ACCESS statement
(relational databases) 298
ACCDESC statement, DBLOAD procedure (rela-
tional databases) 317
access descriptors 309
ACCESS= option, SAS/ACCESS LIBNAME
statement 69
ACCESS procedure 4
how it works 51
naming behaviors 9
ACCESS procedure, relational databases 297
examples 311
options 298
overview 295
statements 296
ACCESS view descriptors 277
accessing DBMS data 3
naming behavior 10
repeatedly 30
ALL option, REPLACE statement
(CV2VIEW) 279
APPEND option, PROC DBLOAD statement (re-
lational databases) 315
APPEND procedure 259
appending data to tables 259
ASSIGN statement, ACCESS procedure (rela-
tional databases) 299
AUTHID= data set option 138
AUTHID= option, SAS/ACCESS LIBNAME
statement 69
authorization IDs 69, 138
AUTOCOMMIT= data set option 138
AUTOCOMMIT= option, SAS/ACCESS LIB-
NAME statement 70
automatic macro variables 219
autopartitioning 46
trace information for 44
B
BL_BADFILE= data set option 139
BL_CODEPAGE= data set option 140
BL_CONTROL= data set option 141
BL_COPY_LOCATION= data set option 142
BL_DATAFILE= data set option 142
BL_DB2DEVT_PERM= data set option 143
BL_DB2DEVT_TEMP= data set option 143
BL_DB2DISC= data set option 144
BL_DB2ERR= data set option 144
BL_DB2IN= data set option 145
BL_DB2LDCT1= data set option 145
BL_DB2LDCT2= data set option 146
BL_DB2LDCT3= data set option 146
BL_DB2LDEXT= data set option 147
BL_DB2MAP= data set option 147
BL_DB2PRINT= data set option 148
BL_DB2PRNLOG= data set option 148
BL_DB2REC= data set option 149
BL_DB2RECSP= data set option 149
BL_DB2RSTRT= data set option 150
BL_DB2SPC_PERM= data set option 151
BL_DB2SPC_TEMP= data set option 151
BL_DB2TBLXST= data set option 151
BL_DB2UTID= data set option 152
BL_DELETE_DATAFILE= data set option 153
BL_DIRECT_PATH= data set option 153
BL_DISCARDFILE= data set option 154
BL_INDEXING_MODE= data set option 155
BL_KEEPIDENTITY= data set option 156
BL_KEEPIDENTITY= option, SAS/ACCESS
LIBNAME statement 71
BL_KEEPNULLS= data set option 156
BL_KEEPNULLS= option, SAS/ACCESS LIB-
NAME statement 72
BL_LOAD_METHOD= data set option 157
BL_LOAD_REPLACE= data set option 158
BL_LOG= data set option 158
BL_LOG= option, SAS/ACCESS LIBNAME
statement 72
BL_METHOD= data set option 159
BL_OPTIONS= data set option 160
BL_OPTIONS= option, SAS/ACCESS LIB-
NAME statement 73
BL_PRESERVE_BLANKS= data set option 161
BL_RECOVERABLE= data set option 161
BL_REMOTE_FILE= data set option 162
BL_SERVER_DATAFILE= data set option 163
BL_SQLLDR_PATH= data set option 164
BL_WARNING_COUNT= data set option 164
buffering bulk rows 165
bulk loading
BULKLOAD= data set option 165
BULKLOAD= LIBNAME option 73, 74, 166
NULL values 72
SYBASE 165
BULK_BUFFER= data set option 165
BULKLOAD= data set option 165
BULKLOAD= option, SAS/ACCESS LIBNAME
statement 73, 74, 166
BY statement
data ordering with threaded reads 47
performance considerations 31
C
calculating statistics 259
CELLPROP= option, SAS/ACCESS LIBNAME
statement 76, 77, 168
charting data 258
clearing librefs 66
CLI LOAD option 142
CLI LOAD option 155, 158, 159, 161
column names
converting to/from variable names 10, 11
disallowed characters 88, 174
preserving 13, 112
variable labels as 178
COMMAND_TIMEOUT= data set option 168
COMMAND_TIMEOUT= option, SAS/ACCESS
LIBNAME statement 77
COMMIT= statement, DBLOAD procedure (rela-
tional databases) 317
commit statements 170
connect exits, customizing 26
CONNECT statement, SQL procedure 229
CONNECTION= option, CONNECT state-
ment 229
CONNECTION= option, LIBNAME state-
ment 25
CONNECTION= option, SAS/ACCESS LIB-
NAME statement 78
connection options, SAS/ACCESS LIBNAME
statement 65
CONNECTION TO component, SQL SELECT
statement 235
CONNECTION_GROUP= option, CONNECT
statement 230
CONNECTION_GROUP= option, SAS/ACCESS
LIBNAME statement 81
connections
sharing 81
timing of 97
CONTENTS procedure 256
CREATE statement, ACCESS procedure (rela-
tional databases) 299
