Index_D

D

D-floating format 93

damaged files 607

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 537

creating with DATA step 342

definition 489

encryption 594

generation data sets 499

indexes 518

input to SAS programs 12

integrity constraints 505

recovering 608

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 570

syntax 25

with input data sets 25

with output data sets 25

data sets 5, 481

assigning passwords to 589

automatic naming convention 485

calculating size 221

combining 389, 391

concatenating 395, 402

copying to Excel 312

copying with Explorer window 293

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, 411

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 589

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 354

output 13

processing BY groups in 383

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 541

additional output files 543

creating 541

definition 541

examples 543

merging data for reports 543

passwords 593

performance 542

restrictions and requirements 542

uses for 542

vs. PROC SQL views 545

vs. stored compiled programs 542, 554

data values 5, 334, 358

data views 481, 539

benefits of 540

creating with DATA step 342

DATA step views 541

PROC SQL views 545

SAS/ACCESS views 546

vs. data files 489

when to use 541

DATASETS procedure

creating indexes 526

creating integrity constraints 511

date constants 113

date intervals 137

boundaries of 141

by category 138

multiunit 142

multi week 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

date time constants 113

date time intervals 137

boundaries of 141

by category 138

multiunit 142

multi week 143

shifted intervals 144

single-unit 142

syntax 138

date time 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 573

DBMS files 6

debugging 147

logic errors 159

declarative statements 69

default Base SAS engine 602

default data sets 485

depreciation functions 41

descriptive statistic functions 41

descriptor information 332

for data sets 481

destination-independent input 181

DICTIONARY tables 557

performance 559

viewing 557

viewing subset of 559

viewing summary of 558

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 523

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