O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required