SAS 9.1 SQL Query Window: Users Guide

C

calculated columns 25

building 25

column expressions 25

correcting mistakes 26

format for 27

labels for 27

viewing output 28

column expressions

in calculated columns 25

outer joins and 69

columns

See also calculated columns

alias names 15

applying functions to column values 5

automatic lookup 58

Available Columns list 88

computed columns 4

embedded blanks in column names 89

format of 16

Group By Columns 55

grouping automatically 47

labels for 15

lookup values 84

moving 23

ordering by 71

selecting 4, 15

sorting output by 22

summary functions for 4

Columns item (View menu) 4

comparison operators 18

computed columns 4

Configure Remote Session 74

constant values 19

counting data 47

Create Table from Query Results item (File menu) 4

Create View of Query item (File menu) 4

customizing sessions 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

setting profiles for 73