SAS 9.1 SQL Query Window: Users Guide

Q

queries

alias names for columns 15

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