PROC SQL: Beyond the Basics Using SAS, Second Edition

Index

A

ADD clause 210–211

addition (+) operator 38–40

ad-hoc queries 280

_AGGR option 342

aggregate functions

creating macro variables with 152–153

specifying 257–258

ALL keyword 268

ALTER TABLE statement 193–202, 207, 210–211, 214–219, 338–340

Ambiguous reference, column error 347

AND operator 36–38

ANSI (American National Standards Institute) 7–8

APPEND procedure 276

arithmetic data 29–32

arithmetic operators 38–40

AS keyword 32–34

_ASGN option 342

asterisk (*) wildcard 59

automatic macro variables, controlling processing with 156–158

automatic sorting 353

AVG function 59

B

BEST option 353

BETWEEN predicate 63–65

B-tree 223

bugs 324

bulk loading data from Microsoft Excel 186–191

Burlew, Michele M.

Output Delivery System: The Basics and Beyond ...