SAS Certified Specialist Prep Guide
Data Science
Book Details
Book Title
SAS Certified Specialist Prep Guide: Base Programming Using SAS 9.4
Author
SAS
Publisher
SAS Institute
Publication Date
2019
ISBN
9781642951790
Number of Pages
434
Language
English
Format
File Size
5.85MB
Subject
Base SAS Programming
Table of Contents
- Contents
- How to Prepare for the Exam
- Requirements and Details
- Requirements
- Exam Objectives and Updates to This Book
- Take a Practice Exam
- Registering for the Exam
- Additional Resources for Learning SAS Programming
- Syntax Conventions
- Accessibility Features of the Prep Guide
- Overview
- Accessibility Documentation Help
- Documentation Format
- SAS Certified Specialist Prep Guide
- Setting Up Practice Data
- Accessing Your Practice Data
- Basic Concepts
- Getting Started
- The Basics of the SAS Language
- SAS Libraries
- Referencing SAS Files
- SAS Data Sets
- Chapter Quiz
- Accessing Your Data
- SAS Libraries
- Viewing SAS Libraries
- Chapter Quiz
- Creating SAS Data Sets
- Referencing an External Data File
- The IMPORT Procedure
- Reading and Verifying Data
- Using the Imported Data in a DATA Step
- Reading a Single SAS Data Set to Create Another
- Reading Microsoft Excel Data with the XLSX Engine
- Creating Excel Worksheets
- Writing Observations Explicitly
- Chapter Quiz
- Identifying and Correcting SAS Language Errors
- Error Messages
- Correcting Common Errors
- Chapter Quiz
- Creating Reports
- Creating a Basic Report
- Selecting Variables
- Identifying Observations
- Sorting Data
- Generating Column Totals
- Specifying Titles and Footnotes in Procedure Output
- Assigning Descriptive Labels
- Using Permanently Assigned Labels
- Chapter Quiz
- Understanding DATA Step Processing
- How SAS Processes Programs
- Compilation Phase
- Execution Phase
- Debugging a DATA Step
- Testing Your Programs
- Chapter Quiz
- BY-Group Processing
- Definitions
- Preprocessing Data
- FIRST. and LAST. DATA Step Variables
- Chapter Quiz
- Creating and Managing Variables
- Creating Variables
- Modifying Variables
- Specifying Lengths for Variables
- Subsetting Data
- Transposing Variables into Observations
- Using SAS Macro Variables
- Chapter Quiz
- Combining SAS Data Sets
- How to Prepare Your Data Sets
- Methods of Combining SAS Data Sets: The Basics
- One-to-One Reading: Details
- Concatenating: Details
- Match-Merging: Details
- Match-Merge Processing
- Renaming Variables
- Excluding Unmatched Observations
- Chapter Quiz
- Processing Data with DO Loops
- The Basics of DO Loops
- Constructing DO Loops
- Nesting DO Loops
- Iteratively Processing Observations from a Data Set
- Conditionally Executing DO Loops
- Chapter Quiz
- SAS Formats and Informats
- Applying SAS Formats and Informats
- The FORMAT Procedure
- Defining a Unique Format
- Associating User-Defined Formats with Variables
- Chapter Quiz
- SAS Date, Time, and Datetime Values
- SAS Date and Time Values
- Reading Dates and Times with Informats
- Example: Using Dates and Times in Calculations
- Displaying Date and Time Values with Formats
- Chapter Quiz
- Using Functions to Manipulate Data
- The Basics of SAS Functions
- SAS Functions Syntax
- Converting Data with Functions
- Manipulating SAS Date Values with Functions
- Modifying Character Values with Functions
- Modifying Numeric Values with Functions
- Nesting SAS Functions
- Chapter Quiz
- Producing Descriptive Statistics
- The MEANS Procedure
- The FREQ Procedure
- Chapter Quiz
- Creating Output
- The Output Delivery System (ODS)
- Creating HTML Output with ODS
- Creating PDF Output with ODS
- Creating RTF Output with ODS
- Creating EXCEL Output with ODS
- The EXPORT Procedure
- Chapter Quiz
- Workbook
- Practice Programming Scenarios
- Quiz Answer Keys and Scenario Solutions
- Chapter Quiz Answer Keys
- Programming Scenario Solutions
- Index