O'Reilly logo

SAS 9.4 SQL Procedure User's Guide, Fourth Edition, 4th Edition by SAS Institute

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

rows that satisfy a condition 44
satisfying multiple conditions 47
with a WHERE clause with missing
values 54
with BETWEEN-AND operators 51
with IN operator 50
with IS MISSING operator 50
with LIKE operator 52
with other conditional operators 49
with simple WHERE clause 44
with truncated string comparison
operators 53
return codes
Pass-Through Facility 172
returning a SUBSTRING 359
right outer joins 85
ROLLBACK statement 390
rows 4
See also retrieving rows
adding to tables or views 250
combining data from multiple rows into
single row 59
counting 62, 362
counting duplicates 187
deleting 123, 246, 247
deleting duplicates 25
duplicates 143
including all 89
including all combinations of 87
inserting 116, 252
inserting with queries 118
inserting with SET clause 116
inserting with VALUES clause 117
joins and 328
matching 89
nonmatching 84, 85
ordering 265
producing from first or second query
108
restricting row processing 139
returned by subqueries 325
selecting 253, 316
selecting all 86
SQL procedure 216
updating all rows with same expression
120
updating rows with different
expressions 121
S
SAS data files
See tables
SAS data views
DICTIONARY tables 149
SQL procedure 217
SAS System information 149
SAS_PUT() function
mapping PUT function to 378
SAS/ACCESS
accessing a DBMS 167
LIBNAME statement 168
SAS/ACCESS views
SQL procedure 217
updating 173
Sashelp views 149
retrieving information about 151
searching for patterns 309, 341, 342
SELECT * statement
expanding with FEEDBACK option
140
SELECT clause 20, 253
SELECT statement 20, 253
See also WHERE clause
FROM clause 20
GROUP BY clause 21
HAVING clause 21
ORDER BY clause 21
ordering clauses 22
SELECT clause 20
self-joins 83
SET clause
inserting rows with 116
set membership 325
set operators 344, 389
ALL keyword 143
combining queries with 103
simple indexes 238
single-value subqueries 96
sort order 37, 39
customized 197
sorting data 37
by calculated column 40
by column 38
by column position 41
by multiple columns 38
by unselected columns 42
columns with missing values 43
grouping and sorting 66
sorting data retrieved by views 244
sorting sequence 43
SORTMSG option 229
SORTSEQ= option 229
SOUNDS-LIKE operator 298
source data
generating SQL for in-database
processing of 374
SQL 3
generating for in-database processing of
source data 374
SQL components 315
BETWEEN condition 316
Index 465

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required