SAS 9.1 SQL Query Window: Users Guide

S

sample data library 10

SAS data sets

storing system table information in 88

Save Query item (File menu) 3

session customization

See customizing sessions

Set Preferences item (Profile menu) 7

Set SQL Options 81

Show Current Preferences item (Profile menu) 7

Show Query item (Tools menu) 6

slider bars 63

demonstration of 64

sorting output 5, 22

by columns 22

moving columns 23

viewing output 24

SORTSEQ= option (SQL) 81

SQL options

setting 81

SQL Query Window

deleting queries from 6

introduction 1

invoking 2

invoking, for examples 11

Structured Query Language (SQL)

definition 1

subsetting data 4

WHERE expressions for 17

with HAVING condition 56

subtitles for reports 6

summarizing data 52

grouping by columns 55

removing duplicate rows 56

summary functions 52

summary functions 52

applying to column values 5

summary reports 45

deleting headings 45

saved report definitions 45

summarizing information 46

Switch Access Mode item (Tools menu) 6

Switch to New Profile item (Tools menu) 6

system tables information

storing in SAS data sets 88