SAS 9.1.3 Language Reference: Concepts, Third Edition, Volumes 1 and 2
D
D-floating format 93
damaged files 611
data components
definition 178
data conversions 38
data errors 154
format modifiers for reporting 156
data files 5, 481, 489
as DATA step output 13
audit trails 491
compressing 538
creating with DATA step 342
definition 489
encryption 598
generation data sets 499
indexes 518
input to SAS programs 12
integrity constraints 505
recovering 612
vs. data views 489
data libraries 4, 467
accessing permanent files without libref 478
copying files 307
definition 467
file types in 468
library concatenation 471
library directories 478
library engines 469
library names 469
librefs 469
logical names 469
management tools 477
managing with operating environment commands 479
permanent 473
physical names 469
SAS system libraries 474
sequential libraries 476
temporary 473
utilities for 477
viewing files 307
data relationships 391
many-to-many 393
many-to-one 392
one-to-many 392
one-to-one 392
data set names 482
how and when assigned 483
one-level 484
parts of 483
two-level 484
where to use 482
data set options 25
compared with system options 76
controlling index usage 531
interaction with system options 26, 75
SAS/ACCESS librefs with 574
syntax 25
with input data sets 25
with output data sets 25
data sets 5, 481
assigning passwords to 593
automatic naming convention 485
calculating size 221
combining 389, 391
concatenating 395, 402
copying to Excel 312
copying with Explorer window 294
creating for I/O optimization 217
default data sets 485
definition 481
descriptor information for 481
editing 486
generation data sets 499
importing data into 321
input to SAS programs 12
interleaving 395, 405
labeling columns 313
management tools 485
match-merging 397, 416
missing values when reading 105
modifying 389
moving columns 313
names for 482
null data sets 484
one-to-one merging 396, 412
one-to-one reading 396, 409
reading 346, 389, 390
SAS files and 4
saving as HTML 312
saving hash object data in 444
sorted data sets 485
sorting column values 315
updating 397, 420
viewing 310, 486
writing observations to 335
DATA step 6, 329
assigning passwords 593
changing default execution sequence 338
checking for missing values 108
concepts 10
creating data files 342
creating data views 342
creating HTML reports 352
generating data from programming statements 346
identifying BY groups 380
input data 343
ODS and 355
output 13
processing BY groups in 382
reading from data sets 346
reading raw data 343
report writing with 347
SAS processing and 13
setting values to missing 107
DATA step Component Interface 437
DATA step debugger 4, 159
DATA step objects 437
hash iterator object 445
hash object 438
DATA step processing 330
altering flow for given observation 339
compilation phase 332
concatenating data sets 402
default execution for statements 337
execution phase 332
flow of action 330
interleaving data sets 406
match-merging 417
one-to-one merging 412
one-to-one reading 410
sample DATA step 333
step boundaries 340
troubleshooting execution 341
updating data sets 421
DATA step statements 69
declarative 69
executable 69
DATA step views 543
additional output files 545
creating 543
definition 543
examples 545
merging data for reports 545
passwords 597
performance 545
restrictions and requirements 544
uses for 544
vs. PROC SQL views 548
vs. stored compiled programs 544, 558
data values 5, 334, 358
data views 481, 541
benefits of 542
creating with DATA step 342
DATA step views 543
PROC SQL views 547
SAS/ACCESS views 548
vs. data files 489
when to use 543
DATASETS procedure
creating indexes 526
creating integrity constraints 512
date constants 113
date intervals 137
boundaries of 141
by category 138
multiunit 142
multiweek 143
shifted intervals 144
single-unit 142
syntax 138
date values 127
as recognizable dates 136
calculating 137
formats/informats and 131
integrity of 130
reading 137
tools by task 131
writing 137
year 2000
and 128
year digits 128, 129
datetime constants 113
datetime intervals 137
boundaries of 141
by category 138
multiunit 142
multiweek 143
shifted intervals 144
single-unit 142
syntax 138
datetime values 128
as recognizable dates and times 136
formats/informats and 131
integrity of 130
tools by task 131
year 2000
and 128
year digits 128, 129
DBLOAD procedure 577
DBMS files 6
debugging 147
logic errors 159
declarative statements 69
default Base SAS engine 606
default data sets 485
depreciation functions 41
descriptive statistic functions 41
descriptor information 332
for data sets 481
destination-independent input 181
DICTIONARY tables 561
performance 563
viewing 561
viewing subset of 563
viewing summary of 562
DIM function
determining number of array elements 456
vs. HBOUND function 460
direct access
combining data sets 394
directory of library members 478
disk space
index requirements for 524
DO loops 453
nested 457
processing selected array elements 453
DO UNTIL expressions 456
DO WHILE expressions 456
DOCUMENT destination 182
definition 178
drop-down menus 285
DROP statement
I/O optimization and 216
dropping variables 88
examples 90
input or output data sets for 88
order of application 89
statements vs. data set options 88
duration integer 137, 140