SAS 9.1 SQL Query Window: Users Guide

R

ranges 63

remote sessions

configuring 74

signing on to remote host 75

Report Options item (Tools menu) 6

REPORT procedure

designing query reports 5

modifying query output 38

producing output with 40

summary reports 45

reports

beginning page number 6

customized report definitions 44

designing 5, 38

modifying format of 40

moving selected items 41

options for 6

output, producing wth REPORT procedure 40

saving 44

subtitles 6

summary reports 45

suppressing ID number 41

titles 6

viewing report statements 43

width of 40

Reset item (Tools menu) 6

Restrict Input Rows to Query 81

right joins 66

rows

adding to lookup tables 60

counting automatically 47

grouping automatically 47

removing duplicates 56

removing duplicates from query output 4

restricting input rows in queries 81

Run Query item (Tools menu) 5

run-time prompt 20