Book description
Prepares you to take the Advanced Programming for SAS 9 exam. Major topics include SQL processing with SAS, the SAS macro language, advanced SAS programming techniques, and optimizing SAS programs. You will also become familiar with the enhancements and new functionality that are available in SAS 9.
Table of contents
- Cover Page
- Title Page
- Copyright Page
- About This Book
-
Part 1: SQL Processing with SAS
- Chapter 1: Performing Queries Using PROC SQL
-
Chapter 2: Performing Advanced Queries Using PROC SQL
- Overview
- Viewing SELECT Statement Syntax
- Displaying All Columns
- Limiting the Number of Rows Displayed
- Eliminating Duplicate Rows from Output
- Subsetting Rows by Using Conditional Operators
- Subsetting Rows by Using Calculated Values
- Enhancing Query Output
- Summarizing and Grouping Data
- Subsetting Data by Using Subqueries
- Subsetting Data by Using Noncorrelated Subqueries
- Subsetting Data by Using Correlated Subqueries
- Validating Query Syntax
- Additional Features
- Summary
- Quiz
- Chapter 3: Combining Tables Horizontally Using PROC SQL
- Chapter 4: Combining Tables Vertically Using PROC SQL
-
Chapter 5: Creating and Managing Tables Using PROC SQL
- Overview
- Understanding Methods of Creating Tables
- Creating an Empty Table by Defining Columns
- Displaying the Structure of a Table
- Creating an Empty Table That Is like Another Table
- Creating a Table from a Query Result
- Inserting Rows of Data into a Table
- Creating a Table That Has Integrity Constraints
- Handling Errors in Row Insertions
- Displaying Integrity Constraints for a Table
- Updating Values in Existing Table Rows
- Deleting Rows in a Table
- Altering Columns in a Table
- Dropping Tables
- Summary
- Quiz
- Chapter 6: Creating and Managing Indexes Using PROC SQL
- Chapter 7: Creating and Managing Views Using PROC SQL
- Chapter 8: Managing Processing Using PROC SQL
-
Part 2: SAS Macro Language
-
Chapter 9: Introducing Macro Variables
- Overview
- Basic Concepts
- Using Automatic Macro Variables
- Using User-Defined Macro Variables
- Processing Macro Variables
- Displaying Macro Variable Values in the SAS Log
- Using Macro Functions to Mask Special Characters
- Using Macro Functions to Manipulate Character Strings
- Using SAS Functions with Macro Variables
- Combining Macro Variable References with Text
- Summary
- Quiz
-
Chapter 10: Processing Macro Variables at Execution Time
- Overview
- Creating a Macro Variable During DATA Step Execution
- Creating Multiple Macro Variables During DATA Step Execution
- Referencing Macro Variables Indirectly
- Obtaining Macro Variable Values During DATA Step Execution
- Creating Macro Variables During PROC SQL Step Execution
- Working with PROC SQL Views
- Using Macro Variables in SCL Programs
- Summary
- Quiz
- Chapter 11: Creating and Using Macro Programs
- Chapter 12: Storing Macro Programs
-
Chapter 9: Introducing Macro Variables
-
Part 3: Advanced SAS Programming Techniques
-
Chapter 13: Creating Samples and Indexes
- Overview
- Creating a Systematic Sample from a Known Number of Observations
- Creating a Systematic Sample from an Unknown Number of Observations
- Creating a Random Sample with Replacement
- Creating a Random Sample without Replacement
- Using Indexes
- Creating Indexes in the DATA Step
- Managing Indexes with PROC DATASETS
- Managing Indexes with PROC SQL
- Documenting and Maintaining Indexes
- Summary
- Quiz
- Chapter 14: Combining Data Vertically
-
Chapter 15: Combining Data Horizontally
- Overview
- Reviewing Terminology
- Working with Lookup Values Outside of SAS Data Sets
- Combining Data with the DATA Step Match-Merge
- Using PROC SQL to Join Data
- Comparing DATA Step Match-Merges and PROC SQL Joins
- Combining Summary Data and Detail Data
- Using an Index to Combine Data
- Using a Transactional Data Set
- Summary
- Quiz
- Chapter 16: Using Lookup Tables to Match Data
- Chapter 17: Formatting Data
-
Chapter 18: Modifying SAS Data Sets and Tracking Changes
- Overview
- Using the MODIFY Statement
- Modifying All Observations in a SAS Data Set
- Modifying Observations Using a Transaction Data Set
- Modifying Observations Located by an Index
- Controlling the Update Process
- Understanding Integrity Constraints
- Placing Integrity Constraints on a Data Set
- Documenting Integrity Constraints
- Removing Integrity Constraints
- Understanding Audit Trails
- Initiating and Reading Audit Trails
- Controlling Data in the Audit Trail
- Controlling the Audit Trail
- Understanding Generation Data Sets
- Initiating Generation Data Sets
- Processing Generation Data Sets
- Summary
- Quiz
-
Chapter 13: Creating Samples and Indexes
-
Part 4: Optimizing SAS Programs
- Chapter 19: Introduction to Efficient SAS Programming
- Chapter 20: Controlling Memory Usage
- Chapter 21: Controlling Data Storage Space
- Chapter 22: Using Best Practices
- Chapter 23: Selecting Efficient Sorting Strategies
-
Chapter 24: Querying Data Efficiently
- Overview
- Using an Index for Efficient WHERE Processing
- Identifying Available Indexes
- Identifying Conditions That Can Be Optimized
- Estimating the Number of Observations
- Comparing Probable Resource Usage
- Deciding Whether to Create an Index
- Comparing Procedures That Produce Detail Reports
- Comparing Tools for Summarizing Data
- Summary
- Quiz
-
Part 5: Quiz Answer Keys
-
Appendix 1: Quiz Answer Keys
- Chapter 1: Performing Queries Using PROC SQL
- Chapter 2: Performing Advanced Queries Using PROC SQL
- Chapter 3: Combining Tables Horizontally Using PROC SQL
- Chapter 4: Combining Tables Vertically Using PROC SQL
- Chapter 5: Creating and Managing Tables Using PROC SQL
- Chapter 6: Creating and Managing Indexes Using PROC SQL
- Chapter 7: Creating and Managing Views Using PROC SQL
- Chapter 8: Managing Processing Using PROC SQL
- Chapter 9: Introducing Macro Variables
- Chapter 10: Processing Macro Variables at Execution Time
- Chapter 11: Creating and Using Macro Programs
- Chapter 12: Storing Macro Programs
- Chapter 13: Creating Samples and Indexes
- Chapter 14: Combining Data Vertically
- Chapter 15: Combining Data Horizontally
- Chapter 16: Using Lookup Tables to Match Data
- Chapter 17: Formatting Data
- Chapter 18: Modifying SAS Data Sets and Tracking Changes
- Chapter 19: Introduction to Efficient SAS Programming
- Chapter 20: Controlling Memory Usage
- Chapter 21: Controlling Data Storage Space
- Chapter 22: Using Best Practices
- Chapter 23: Selecting Efficient Sorting Strategies
- Chapter 24: Querying Data Efficiently
-
Appendix 1: Quiz Answer Keys
- Index
- Footnote
Product information
- Title: SAS® Certification Prep Guide: Advanced Programming for SAS®9, Third Edition
- Author(s):
- Release date: July 2011
- Publisher(s): SAS Institute
- ISBN: 9781607649250
You might also like
book
SAS® Certification Prep Guide: Advanced Programming for SAS®9 Second Edition
The SAS Certification Prep Guide: Advanced Programming for SAS 9, Second Edition, prepares you to take …
book
SAS® Certification Prep Guide: Base Programming for SAS®9
Prepare for the SAS Base Programming for SAS®9 certification exam with the official guide by the …
book
SAS® Certification Prep Guide: Base Programming for SAS®9 Second Edition
New and experienced SAS users who want to prepare for the Base Programming for SAS 9 …
book
SAS 9.4 Intelligence Platform: Overview, Second Edition, 2nd Edition
Provides a point of entry for understanding the basics of the SAS Intelligence Platform. It discusses …