Base SAS 9.1 Procedures Guide, Volumes 1, 2, 3 and 4

D

DANISH option

PROC SORT statement 1021

DATA= argument

PROC EXPORT statement 402

DATA COLUMNS window

REPORT procedure 932

data components

definition 40

Data Control Blocks (DCBs) 219, 290

data libraries

copying entire library 327

copying files 323

deleting files 330

exchanging filenames 334

importing 220

printing directories of 273, 319

processing all data sets in 30

renaming files 318

saving files from deletion 351

USER data library 17

DATA= option

APPEND statement (DATASETS) 310

CONTENTS statement (DATASETS) 320

PROC CALENDAR statement 86

PROC CHART statement 183

PROC COMPARE statement 230

PROC MEANS statement 529

PROC OPTLOAD statement 618

PROC PLOT statement 625

PROC PRINT statement 723

PROC PRTDEF statement 806

PROC RANK statement 832

PROC REPORT statement 889

PROC SORT statement 1022

PROC STANDARD statement 1180

PROC TABULATE statement 1203

PROC TIMEPLOT statement 1304

PROC TRANSPOSE statement 1328

DATA SELECTION window

REPORT procedure 932

data set options 18

SQL procedure with 1128

data sets

aging 385

appending 310

appending compressed data sets 312

appending indexed data sets 312

appending password-protected data sets 312

concatenating 383

content descriptions 319

contents of 273

copying between hosts 277

creating formats from 472

describing 381

exporting 292

input data sets 19

loading system options from 617

modifying 378

naming 16

permanent 16

printing all data sets in library 782

printing formatted values for 25

processing all data sets in a library 30

renaming variables 348

repairing 349

saving system option settings in 619

standardizing variables 1177

temporary 16

transporting 276, 329

transporting password-protected 290

USER data library and 17

writing printer attributes to 822

data sets, comparing

base data set 224

comparison data set 224

comparison summary 244

variables in different data sets 259

variables in same data set 238, 262

DATA step views

SQL procedure 1044

data summaries 1122, 1260

data summarization tools 1191

DATABASE= statement

EXPORT procedure 407

IMPORT procedure 511

DATAFILE= argument

PROC IMPORT statement 502

DATAROW= statement

IMPORT procedure 507

DATASETS 304

DATASETS procedure 304

concepts 353

directory listings 360

ending 355

error handling 354

examples 372

execution of statements 353

forcing RUN- group processing 355

generation data sets 358

member types 357

ODS and 365, 386

output 301

output data sets 366

overview 300

password errors 355

passwords with 355

procedure output 360

restricting member types 356

results 360

RUN-group processing 353

syntax 304

task tables 304, 319, 344

DATATYPE= option

PICTURE statement (FORMAT) 439

date formats 468

DATECOPY option

PROC CIMPORT statement 215

PROC CPORT statement 284

PROC SORT statement 1022

COPY statement (DATASETS) 326

DATETIME option

PROC CALENDAR statement 86

DAYLENGTH= option

PROC CALENDAR statement 86

DBMS

SORT procedure with 1027

DBMS connections

ending 1067

LIBNAME statement for 1129

Pass-Through Facility for 1129

sending DBMS statements to 1068

SQL procedure 1057

storing in views 1064

DBMS= option

PROC EXPORT statement 403

PROC IMPORT statement 503

DBMS queries 1093

DBMS tables

exporting to 407

importing 510

DBPWD= statement

EXPORT procedure 407

IMPORT procedure 512

DBSASLABEL= statement

IMPORT procedure 507, 512

DCBs (Data Control Blocks) 219, 290

DDNAME= argument

PROC FSLIST statement 490

DDNAME= option

PROC DATASETS statement 307

debugging

registry debugging 849

DEBUGOFF option

PROC REGISTRY statement 849

DEBUGON option

PROC REGISTRY statement 849

DECSEP= option

PICTURE statement (FORMAT) 440

DEFAULT= option

FORMAT procedure 451

RADIOBOX statement (PMENU) 691

DEFINE option

PROC OPTIONS statement 611

DEFINE statement

REPORT procedure 912

DEFINITION window

REPORT procedure 933

DELETE option

PROC PRTDEF statement 806

DELETE statement

CATALOG procedure 160

DATASETS procedure 330

SQL procedure 1065

delimited files

exporting 406, 409

importing 506, 514

DELIMITER= statement

EXPORT procedure 406

IMPORT procedure 507

denominator definitions 1283

density function 1363

DESC option

PROC PMENU statement 683

DESCENDING option

BY statement 58

BY statement (CALENDAR) 92

BY statement (CHART) 186

BY statement (COMPARE) 235

BY statement (MEANS) 535

BY statement (PLOT) 628

BY statement (PRINT) 732

BY statement (RANK) 835

BY statement (REPORT) 905

BY statement (SORT) 1026

BY statement (STANDARD) 1182

BY statement (TABULATE) 1210

BY statement (TIMEPLOT) 1305

BY statement (TRANSPOSE) 1330

CHART procedure 191

CLASS statement (MEANS) 536

CLASS statement (TABULATE) 1211

DEFINE statement (REPORT) 916

ID statement (COMPARE) 236

PROC RANK statement 832

DESCENDTYPES option

PROC MEANS statement 529

DESCRIBE statement

SQL procedure 1066

DESCRIPTION= argument

MODIFY statement (CATALOG) 162

descriptive statistics 558, 1191

computing with class variables 560

keywords and formulas 1356

table of 31

destination-independent input 43

detail reports 863

detail rows 863

DETAILS option

CONTENTS statement (DATASETS) 321

PROC DATASETS statement 305

deviation from the mean 1369

device drivers

system fonts 425

dialog boxes 685

check boxes in 684

collecting user input 701

color for 695

input fields 694

radio buttons in 692

searching multiple values 703

text for 694

DIALOG statement

PMENU procedure 685

DICTIONARY tables 1130

performance and 1132

reporting from 1150

retrieving information about 1131

uses for 1132

difference 242

report of differences 255

DIG3SEP= option

PICTURE statement (FORMAT) 440

digit selectors 442

dimension expressions 1222

elements in 1222

operators in 1223

style elements in 1224

directives 442

DIRECTORY option

CONTENTS statement (DATASETS) 321

DISCONNECT statement

SQL procedure 1067

DISCRETE option

CHART procedure 191

DISPLAY 393

DISPLAY option

DEFINE statement (REPORT) 916

DISPLAY PAGE window

REPORT procedure 938

DISPLAY procedure 393

example 394

overview 393

syntax 393

display variables 869, 916

distribution 1363

DMOPTLOAD command 617

DMOPTSAVE command 619

DOCUMENT destination 44

definition 40

DOL option

BREAK statement (REPORT) 902

RBREAK statement (REPORT) 924

DOUBLE option

PROC PRINT statement 723

PROC SQL statement 1049

double overlining 902, 924

double underlining 902, 925

DQUOTE= option

PROC SQL statement 1049

DROP statement

SQL procedure 1068

DTC= option

MODIFY statement (DATASETS) 345

DUL option

RBREAK statement (REPORT) 902, 925

DUPOUT= option

PROC SORT statement 1022

DUR statement

CALENDAR procedure 94

Категории