SAS 9.1 SQL Query Window: Users Guide

O

operators 36

changing WHERE expressions with 36

comparison operators 18

logical operators 20

ORACLE access mode options 86

Order By Columns

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