in-line views versus 143
terminology 4
text
adding to output 27
THREADS option 230
three-valued logic 390
TIME function
replacing references to 146
timing procedure statements 140
TODAY function
replacing references to 146
truncated string comparison operators 53,
354
U
UBUFSIZE= option 231
undo policy
SQL procedure 383
UNDO_POLICY= option 163, 230
union joins 89, 335
UNION operator 348
combining queries 103, 104
UNIQUE keyword 127, 237
unique values
aggregate functions with 61
counting 61
counting all rows 62
counting nonmissing values 62
in columns 25
UPDATE statement 267
updating tables
conditionally 200
errors 122
updating values 120
with values from another table 203
updating views 132, 173
UPPER function 369
USER literal 352
user-defined macro variables 157
V
VALIDATE statement 268
syntax checking with 139
validating queries 71
VALUES clause
inserting rows with 117
variables
See also columns
SQL procedure 216
view definitions 247
ORDER BY clause in 388
views 5, 131
creating 131
deleting 134
describing 132
DICTIONARY tables and 149
embedding libnames in 133
in-line 134, 262, 296, 388
of DBMS tables 170
omitting ORDER BY clause when
creating 143
PROC SQL views in SAS 136
SAS data views 149
Sashelp views 149, 151
SQL procedure 217
tips for using 135
updating 132
updating PROC SQL and SAS/
ACCESS views 173
W
WARNRECURS option 231
weighted averages 178
WHERE clause 21, 262
filtering grouped data, versus HAVING
clause 70
MEAN function with 57
missing values with 54
retrieving rows conditionally 44
summarizing data 57
WHERE expressions
joins with 143
width
changing column width 125
468 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.