adding rows 250
creating, from query expressions 243
creating, from query results 289
deleting 248
deleting rows 246, 247
embedding LIBNAME statements in
245
inserting rows 252
librefs and stored views 245
selecting columns 243, 253
selecting rows 253
sorting data retrieved by 244
source views 261
SQL procedure 217
storing DBMS connection information
245
updating 173, 245
updating column values 267
updating tables through 268
view definitions 247, 388
PROMPT option 227
PUT function
deploying inside a DBMS 145
mapping to SAS_PUT function 378
optimizing 144
reducing 144
reducing, based number of format
values 381
reducing, based on engine type 379
reducing, based on number of
observations in table 380
Q
qualifying column names 76
queries 5
adding text to output 27
ALL keyword in set operations 143
breaking into steps 143
combining with set operators 103
comparing execution time of two
queries 140
creating 138
creating tables from results 271
creating views from results 289
DBMS queries 324
DBMS tables 169
debugging 138
duplicate rows and performance 143
in-line view queries 296
in-line views 134
in-line views versus temporary tables
143
indexes and 142
inserting rows with 118
limiting iterations 139
performance improvement 142
remerged data and 383
restricting row processing 139
subqueries 96
validating 71
query expression component 343
query expressions 344
ALL keyword and 345
CORRESPONDING keyword and 345
creating PROC SQL tables from 243
creating PROC SQL views from 244
EXCEPT and 349
INTERSECT and 350
OUTER UNION and 345
set operators and 344
subqueries 354
UNION and 348
validating syntax 268
query results 5
concatenating 107
creating macro variables from 158
creating tables from 113
deleting duplicate rows 25
R
records
See rows
REDUCEPUT option 144
REDUCEPUT= option 227
REDUCEPUTOBS option 144
REDUCEPUTOBS= option 228
REDUCEPUTVALUES option 145
REDUCEPUTVALUES= option 228
referential integrity constraints 129
reflexive joins 83, 329
relational theory 3
relations 3
REMERGE option 229
remerging data 383
SQL procedure 363
remerging summary statistics 59
disabling remerge 146
renaming columns 125
REPORT procedure
formatting SQL output 165
reports
creating summary reports 194
from DICTONARY tables 281
RESET statement 252
resetting SQL procedure options 141
resetting options 141
retrieving rows 44
based on comparison 45
identifying columns with missing values
50
464 Index
Get SAS 9.4 SQL Procedure User's Guide, Fourth Edition, 4th 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.
