Step-by-Step Programming with Base SAS 9.4, Second Edition, 2nd Edition

finding first or last observation 189

FIRST. variable, description 197

FIRST. variable, finding first

observation 190

in descending order 188

LAST. variable, description 197

LAST. variable, finding last observation

190

SORT procedure, description 197

SORT procedure, grouping observations

186

observations, selecting

See observations, subsetting

observations, sorting 192

See also observations, grouping

case sensitivity 195

collating sequences, ASCII 196

collating sequences, EBCDIC 196

collating sequences, magnitude of

letters 163

deleting duplicates 193

example 192

NODUPRECS option, deleting

duplicate records 193

NODUPRECS option, description 197

SORT procedure, description 197

SORT procedure, sorting observations

192

observations, subsetting 169, 185

See also DATA statement

See also DELETE statement

See also DROP statement

See also DROP= option

See also FIRSTOBS= option

See also IF statement

See also KEEP statement

See also KEEP= option

See also OBS= option

See also observations, sorting

See also SET statement

all conditions true (AND) 156

alternative actions 151

character comparisons, case sensitivity

161

character comparisons, types of 161

character groups, selecting 162, 163,

164

comparison operators 154

complex comparisons 158

construct conditions 154

deleting conditionally 115, 171

efficiency 101

ELSE statement 151

IF-THEN statement 149

multiple comparisons 155

mutually exclusive conditions 152

negative operators 157

numeric comparisons, abbreviating 159

one condition true (OR) 156

options versus statements 98

pointing to first record 95, 103

pointing to last record 96, 103

simple conditions 150, 155, 173

to SAS data sets 175

observations, writing to SAS data sets 175

See also OUTPUT statement

multiple times to one or more data sets

179

to multiple data sets, common mistake

176

to multiple data sets, example 175

to separate data sets 206, 207

ODS 644

data, definition 10, 646

features of 615

table templates 646

ODS _ALL_ CLOSE statement 681

ODS destinations

definition 10, 646

opening 647

ODS destinations, closing 647

ODS _ALL_ CLOSE statement 681

ODS HTML CLOSE statement 681

ODS LISTING CLOSE statement 681

ODS OUTPUT CLOSE statement 681

ODS PRINTER CLOSE statement 681

ODS RTF CLOSE statement 681

ODS EXCLUDE statement

description 680

excluding ODS output objects 663

ODS HTML CLOSE statement 681

ODS HTML statement 681

description 641

ODS LISTING CLOSE statement 681

ODS LISTING statement 681

description 641

ODS output 647

definition 11, 647

formats, list of 9

formats, selecting 678

HTML, for Web browsers 648

PostScript output, high-resolution

printers 656

PowerPoint output, for Microsoft

PowerPoint 658

RTF output, for Microsoft Word 658

SAS data sets, creating 665

storing links to 647

ODS OUTPUT CLOSE statement 681

ODS output objects 646

definition 10, 646

excluding 663

Index 875