BTRIM function 317
CALCULATED 317
CASE expression 318
COALESCE function 320
column-definition 320
column-modifier 321
column-name 323
CONNECTION TO 324
CONTAINS condition 324
EXISTS condition 325
IN condition 325
IS condition 326
joined-table 327
LIKE condition 341
LOWER function 343
query-expression 343
sql-expression 351
SUBSTRING function 359
summary-function 360
table-expression 368
UPPER function 369
SQL procedure 3, 216
See also SQL components
ANSI standard and 387
coding conventions 217
collating sequence 388
column modifiers 388
combinations of column values 303
combining two tables 278
compared with DATA step 5
counting missing values with a macro
312
creating macro variables 157
creating queries 138
creating tables and inserting data 269
creating tables from query results 271
creating views from query results 289
cumulative time for 140
data set options with 156
data types and dates 320
debugging queries 138
DICTIONARY tables 149
example tables 7
formatting output 165
functions supported by 389
identifiers and naming conventions 390
indexes 237
joining three tables 292
joining two tables 276, 300
macro facility with 157
macro variables set by 162
matching case rows and control rows
309
missing values 312, 326
ODS with 174
orthogonal expressions 388
outer joins 283
PROC SQL tables 216
querying in-line views 296
reporting from DICTIONARY tables
281
reserved words 387
resetting options 141, 252
retrieving values 298
statistical functions 389
syntax 218
syntax checking 139
task tables 220, 221
terminology 4, 216
three-valued logic 390
timing individual statements 140
undo policy 383
updating PROC SQL tables 273
user privileges 390
using tables in other procedures 208
views 217
SQL Procedure Pass-Through Facility 171
connecting to a DBMS 171
example 172
return codes 172
sql-expression component 351
correlated subqueries and 357
functions and 352
operators and order of evaluation 352
query expressions and 354
subqueries and efficiency 358
truncated string comparison operators
and 354
USER and 352
SQL, embedded 390
SQLCONSTDATETIME system option
373
SQLEXITCODE macro variable 163
SQLGENERATION= system option 374
SQLIPONEATTEMPT system option
377
SQLMAPPUTTO= system option 378
SQLOBS macro variable 163
SQLOOPS macro variable 139, 163
SQLRC macro variable 163
SQLREDUCEPUT= system option 144,
379
SQLREDUCEPUTOBS= system option
144, 380
SQLREDUCEPUTVALUES= system
option 145, 381
SQLREMERGE system option 383
SQLUNDOPOLICY 383
SQLUNDOPOLICY= system option 163,
383
SQLXMSG macro variable 164
SQLXOPENERRS macro variable 163
464 Index

Get SAS 9.4 SQL Procedure User's Guide, Third Edition, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.