Book description
Carpenter's Guide to Innovative SAS Techniques offers advanced SAS programmers an all-in-one programming reference that includes advanced topics not easily found outside the depths of SAS documentation or more advanced training classes. Art Carpenter has written fifteen chapters of advanced tips and techniques, including topics on data summary, data analysis, and data reporting. Special emphasis is placed on DATA step techniques that solve complex data problems. There are numerous examples that illustrate advanced techniques that take advantage of formats, interface with the macro language, and utilize the Output Delivery System. Additional topics include operating system interfaces, table lookup techniques, and the creation of customized reports.
Table of contents
- Copyright
- Dedication
- Contents
- About This Book
- Acknowledgments
- About the Author
- Chapter 1 Moving, Copying, Importing, and Exporting Data
- Chapter 2 Working with Your Data
-
Chapter 3 Just In the DATA Step
-
3.1 Working across Observations
- 3.1.1 BY-Group ProcessingâUsing FIRST. and LAST. Processing
- 3.1.2 Transposing to ARRAYs
- 3.1.3 Using the LAG Function
- 3.1.4 Look-Ahead Using a MERGE Statement
- 3.1.5 Look-Ahead Using a Double SET Statement
- 3.1.6 Look-Back Using a Double SET Statement
- 3.1.7 Building a FIFO Stack
- 3.1.8 A Bit on the SUM Statement
- 3.2 Calculating a Personâs Age
-
3.3 Using DATA Step Component Objects
- 3.3.1 Declaring (Instantiating) the Object
- 3.3.2 Using Methods with an Object
- 3.3.3 Simple Sort Using the HASH Object
- 3.3.4 Stepping through a Hash Table
- 3.3.5 Breaking Up a Data Set into Multiple Data Sets
- 3.3.6 Hash Tables That Reference Hash Tables
- 3.3.7 Using a Hash Table to Update a Master Data Set
- 3.4 Doing More with the INTNX and INTCK Functions
- 3.5 Variable Conversions
- 3.6 DATA Step Functions
- 3.7 Joins and Merges
- 3.8 More on the SET Statement
- 3.9 Doing More with DO Loops
- 3.10 More on Arrays
-
3.1 Working across Observations
- Chapter 4 Sorting the Data
- Chapter 5 Working with Data Sets
-
Chapter 6 Table Lookup Techniques
- 6.1 A Series of IF StatementsâThe Logical Lookup
- 6.2 IF -THEN/ELSE Lookup Statements
- 6.3 DATA Step Merges and SQL Joins
- 6.4 Merge Using Double SET Statements
- 6.5 Using Formats
- 6.6 Using Indexes
- 6.7 Key Indexing (Direct Addressing)âUsing Arrays to Form a Simple Hash
- 6.8 Using the HASH Object
- 7.1 Using Multiple CLASS Statements and CLASS Statement Options
- 7.2 Letting SAS Name the Output Variables
- 7.3 Statistic Specification on the OUTPUT Statement
- 7.4 Identifying the Extremes
- 7.5 Understanding the _TYPE_ Variable
- 7.6 Using the CHARTYPE Option
- 7.7 Controlling Summary Subsets Using the WAYS Statement
- 7.8 Controlling Summary Subsets Using the TYPES ⨠Statement
- 7.9 Controlling Subsets Using the CLASSDATA= and EXCLUSIVE Options
- 7.10 Using the COMPLETETYPES Option
- 7.11 Identifying Summary Subsets Using the LEVELS and WAYS Options
- 7.12 CLASS Statement vs. BY Statement
-
Chapter 8 Other Reporting and Analysis Procedures
- 8.1 Expanding PROC TABULATE
- 8.2 Expanding PROC UNIVARIATE
- 8.3 Doing More with PROC FREQ
-
8.4 Using PROC REPORT to Better Advantage
- 8.4.1 PROC REPORT vs. PROC TABULATE
- 8.4.2 Naming Report Items (Variables) in the Compute Block
- 8.4.3 Understanding Compute Block Execution
- 8.4.4 Using a Dummy Column to Consolidate Compute Blocks
- 8.4.5 Consolidating Columns
- 8.4.6 Using the STYLE= Option with LINES
- 8.4.7 Setting Style Attributes with the CALL DEFINE Routine
- 8.4.8 Dates within Dates
- 8.4.9 Aligning Decimal Points
- 8.4.10 Conditionally Executing the LINE Statement
- 8.5 Using PROC PRINT
- Chapter 9 SAS/GRAPH Elements You Should KnowâEven if You Donât Use SAS/GRAPH
- Chapter 10 Presentation GraphicsâMore than Just SAS/GRAPH6
- Chapter 11 Output Delivery System
-
Chapter 12 Taking Advantage of Formats
- 12.1 Using Preloaded Formats to Modify Report Contents
- 12.2 Doing More with Picture Formats
- 12.3 Multilabel (MLF) Formats
- 12.4 Controlling Order Using the NOTSORTED Option
- 12.5 Extending the Use of Format Translations
- 12.6 ANYDATE Informats
- 12.7 Building Formats from Data Sets
- 12.8 Using the PVALUE Format
- 12.9 Format Libraries
-
Chapter 13 Interfacing with the Macro Language
- 13.1 Avoiding Macro Variable CollisionsâMake Your Macro Variables %Local
- 13.2 Using the SYMPUTX Routine
- 13.3 Generalized ProgramsâVariations on a Theme
- 13.4 Utilizing Macro Libraries
- 13.5 Metadata-Driven Programs
- 13.6 Hard CodingâJust Donât Do It
- 13.7 Writing Macro Functions
- 13.8 Macro Information Sources
- 13.9 Macro Security and Protection
- 13.10 Using the Macro Language IN Operator
- 13.11 Making Use of the MFILE System Option
- 13.12 A Bit on Macro Quoting
-
Chapter 14 Operating System Interface and Environmental Control
- 14.1 System Options
- 14.2 Using an AUTOEXEC Program
- 14.3 Using the Configuration File
-
14.4 In the Display Manager
- 14.4.1 Showing Column Names in ViewTable
- 14.4.2 Using the DM Statement
- 14.4.3 Enhanced Editor Options and Shortcuts
- 14.4.4 Macro Abbreviations for the Enhanced Editor
- 14.4.5 Adding Tools to the Application Tool Bar
- 14.4.6 Adding Tools to Pull-Down and Pop-up Menus
- 14.4.7 Adding Tools to the KEYS List
- 14.5 Using SAS to Write and Send E-mails
- 14.6 Recovering Physical Location Information
- Chapter 15 Miscellaneous Topics
- Appendix A Topical Index
- Appendix B Usage Index
- References
- Index
- Accelerate Your SAS Knowledge with SAS Books
Product information
- Title: Carpenter's Guide to Innovative SAS Techniques
- Author(s):
- Release date: March 2012
- Publisher(s): SAS Institute
- ISBN: 9781612902029
You might also like
book
Carpenter's Complete Guide to the SAS REPORT Procedure
Art Carpenter demystifies the powerful REPORT procedure and shows you how to incorporate this highly flexible …
book
Producing High-Quality Figures Using SAS/GRAPH® and ODS Graphics Procedures
This book demonstrates how to create commonly used figures and plots with SAS/GRAPH and ODS Graphics …
book
Base SAS 9.4 Procedures Guide, Fifth Edition, 5th Edition
Contains the complete reference for all Base SAS procedures. Provides information about what each procedure does …
book
SAS 9.4 Language Reference, 6th Edition
Provides conceptual information for the Base SAS language. Major topics include SAS keywords and naming conventions, …