HAVING condition
reviewing results of 58
subsetting groups of data with 56
Having Condition for
HAVING EXPRESSION window 57
HAVING expressions 5
headings
deleting from summary
include= argument 2
informats
for column format 16
inner joins
definition 31
selecting 5
INOBS= option (SQL) 81
invoking SQL Query Window 2
for examples 11
Join Type item (View menu) 5
joining tables 30
automatic Group By, more than one table 49
automatic joins 77
choosing join type 31
full joins 67
inner joins 5, 31
left joins 66
outer joins 31, 66
right joins 66
selecting join type 5
setting join criteria 31
types of joins 30
viewing output 32
Keep Profile in Menu 81
labels
for calculated
for columns 15
left joins 66
List/Include Saved Queries item (File menu) 4
logical operators 20
lookup tables 60
adding rows to 60
creating 63
empty lookup tables 59
reading 60
lookup values 84
LOOPS= option (SQL) 81
File 3
pop-up 7
Profile 7
Profile item in 81
Tools 5
View 4
mirror image tables 88
missing values 82
Move Columns window 23
operators 36
changing WHERE expressions with 36
comparison operators 18
logical operators 20
ORACLE access mode options 86
Order By
column expressions for outer joins 71
sorting output 22
Order By item (View menu) 5
outer joins 66
column expressions and 69
creating 68
definition 31
full joins 67
left joins 66
ordering by columns 71
query views 67
right joins 66
selecting 5
types of 66
viewing output 71
OUTOBS= option (SQL) 81
output
duplicate rows in query output 4
for automatic lookup 62
for calculated columns 28
for joins 32
for outer joins 71
from REPORT procedure 40
modifying query output 38
sorting 5, 22
page
Password Protect 80
pop-up menu 7
preference settings 73
Access Mode 75
Automatic Join 77
Automatic Lookup 80
Configure Remote Session 74
Data Restrictions 80
Exit Confirmation 82
Keep Profile in Menu 81
Password Protect 80
Restrict Input Rows to Query 81
Set SQL Options 81
preferences
current settings 7
setting 7
updating 7
PREVIEW window
displaying queries in 6
Preview Window item (Tools menu) 6
PROC SQL views 4
profile= argument 2
Profile menu 7
Set Preferences 7
Show Current Preferences 7
Update Preferences 7
profiles
automatic join data set for 80
changing, for examples 11
creating 7, 63
current preferences 7
for preference settings 73
passwords for 80
Profile item in
switching 6, 82
updating preference settings 7
queries
alias
automatic Group By as part of 50
column format 16
creating tables from query results 4, 29
creating WHERE expressions 17
deleting from SQL Query Window 6
displaying in PREVIEW window 6
duplicate rows in output 4
examples of simple queries 14
including saved queries 35, 89
including stored queries 2
initial table in 2
labels for columns 15
listing saved queries 4, 35
modifying output 38
PROC SQL views 4
removing tables from 5
report design for 5
resetting 6
restricting input rows 81
running 5, 20
running immediately 5
saving 3, 32
saving, several queries 33
saving, to include later 33
selecting a table 14
selecting columns 15
switching profiles 6
syntax of 4, 6, 67
query views
creating 67