Cover image for Professional SAS programming secrets : updated with new features of releases 6.08-6.10
Title:
Professional SAS programming secrets : updated with new features of releases 6.08-6.10
Author:
Aster, Rick.
Personal Author:
Publication Information:
New York : McGraw-Hill, [1997]

©1997
Physical Description:
587 pages : illustrations ; 24 cm + 1 computer disk (3 1/2 in.).
General Note:
Includes index.
Language:
English
Title Subject:
Added Author:
ISBN:
9780079130952
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Item Holds
Searching...
QA276.4 .A84 1997 Book and Software Set Central Closed Stacks
Searching...

On Order

Summary

Summary

Quick solutions, techniques, & strategies for getting the most out of the SAS System make this the perfect resource for busy SAS users & programmers. Now updated for versions 6.08-6.10, this best-selling toolkit provides all of the book's routines on a handy, ready-to-use disk. Rick Aster & Rhena Seidman share clever, little-known programming tips & secrets they've perfected during years of SAS programming & consulting. The right & wrong ways to do things, ways to facilitate complicated tasks, & the tricks of SAS pros can all be found in this book, with a programmer's perspective no other book provides.


Table of Contents

Tables and illustrationsp. 11
Introductionp. 13
Part 1 For programmersp. 17
1 Getting startedp. 19
Originsp. 19
What kind of language is SAS?p. 21
A simple SAS programp. 24
How to read a SAS programp. 28
One way to write SAS programsp. 43
2 The factsp. 45
The parse/execute cyclep. 45
Compilingp. 48
The observation loopp. 50
Data in memoryp. 60
Variable attributesp. 61
SAS data librariesp. 65
Missingp. 69
Options and defaultsp. 72
3 Programs on callp. 79
Supervisorp. 79
Procsp. 80
Enginesp. 86
Functionsp. 88
CALL routinesp. 104
Informatsp. 105
Formatsp. 108
Creating formats and informats using the FORMAT procp. 112
Part 2 The rulesp. 121
4 Control flowp. 123
Conditional executionp. 123
Extending the observation loopp. 126
DO loopp. 134
Multiple conditional execution with SELECTp. 138
Transferring controlp. 141
5 I/Op. 145
Storagep. 146
External devicesp. 147
I/O modesp. 147
I/O for text filesp. 148
I/O for SAS datasetsp. 149
Input from text filesp. 150
Input from SAS datasetsp. 161
Output to text filesp. 168
Output to SAS datasetsp. 178
Editing text filesp. 181
Copying text filesp. 182
Print filesp. 185
6 Expressionsp. 197
Constantsp. 197
Variablesp. 202
Arraysp. 203
Assignment statementp. 207
Sum statementp. 208
Operatorsp. 209
Functionsp. 217
Type conversionsp. 218
7 Macrolanguagep. 221
Macrolanguage objectsp. 221
The macro processorp. 228
Uses for macrolanguagep. 231
Quasi-structured programmingp. 232
8 Groups and sortingp. 237
Sortingp. 237
Groupsp. 243
Identification codesp. 248
Matchingp. 251
Crossingp. 253
Sequence numbersp. 255
SAS dataset indexesp. 256
9 Operating on SAS datasetsp. 259
Creatingp. 259
Copyingp. 260
Deletingp. 264
Renamingp. 265
Describingp. 266
Variablesp. 267
SQL table operationsp. 267
Part 3 Techniquesp. 269
10 File formatsp. 271
Delimited fieldsp. 271
Hierarchical filesp. 274
Binary filesp. 276
Text filesp. 277
Data formatsp. 280
11 Reportsp. 287
Designp. 287
Tablesp. 289
Procs with table outputp. 292
Programming table outputp. 298
Formatted cell datasetsp. 320
Prosep. 325
12 Flexcodep. 329
Program parametersp. 329
Data in SAS statementsp. 331
Meta-control flowp. 333
Writing other languagesp. 336
13 Numbersp. 339
Roundingp. 339
Testing numbersp. 341
Numeric effectsp. 343
Missing values in numeric expressionsp. 344
Logicp. 346
Timep. 353
14 Data typesp. 373
Working with character stringsp. 373
Codesp. 384
Custom data typesp. 386
Byte variablesp. 387
Integersp. 388
Structuresp. 390
Pseudo-arraysp. 392
Other data typesp. 394
15 Table lookupp. 403
SELECTp. 404
Booleanp. 406
Arrayp. 406
Pseudo-arrayp. 409
Macroarrayp. 410
Functionp. 411
Value formatp. 412
Table in storagep. 414
Selecting a lookup methodp. 422
16 Efficiencyp. 425
Saving stepsp. 425
Simplifyingp. 432
Compressingp. 434
The right procsp. 436
Fasterp. 437
Memoryp. 442
Storagep. 443
Hardwarep. 444
Going nowherep. 445
Part 4 Workingp. 449
17 Applicationsp. 451
Database programmingp. 451
Statisticsp. 456
Computer system managementp. 466
Word processing toolsp. 467
18 User interfacep. 473
Users and programsp. 473
Windowsp. 474
Line modep. 489
19 Power toolsp. 493
Hardwarep. 493
Softwarep. 498
Computer securityp. 500
Sources of informationp. 502
20 Projectsp. 507
Designp. 507
Codingp. 508
Debuggingp. 509
Documentationp. 511
Testingp. 511
Maintenancep. 512
21 Languagesp. 513
Porting SAS programsp. 513
Moving datap. 516
Older SAS versionsp. 517
Other languagesp. 520
SAS system programmingp. 530
22 Classic problemsp. 533
Prime number sievep. 533
Lifep. 535
Global distancesp. 538
BASIC interpreterp. 540
Updatep. 553
Glossaryp. 565
Indexp. 575
About the authorsp. 588