SAS Institute. SAS Certified Specialist Prep Guide: Base Programming Using SAS 9.4

Cary: SAS Institute, 2019. — 484 p.How to Prepare for the Exam
Accessibility Features of the Prep Guide
PART 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
Quiz
Accessing Your Data
SAS Libraries
Viewing SAS Libraries
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
Quiz
Identifying and Correcting SAS Language Errors
Error Messages
Correcting Common Errors
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
Quiz
Understanding DATA Step Processing
How SAS Processes Programs
Compilation Phase
Execution Phase
Debugging a DATA Step
Testing Your Programs
Quiz
BY-Group Processing
Definitions
Preprocessing Data
FIRST and LAST DATA Step Variables
Quiz
Creating and Managing Variables
Creating Variables
Modifying Variables
Specifying Lengths for Variables
Subsetting Data
Transposing Variables into Observations
Using SAS Macro Variables
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
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
Quiz
SAS Formats and Informats
Applying SAS Formats and Informats
The FORMAT Procedure
Defining a Unique Format
Associating User-Defined Formats with Variables
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
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
Quiz
Producing Descriptive Statistics
The MEANS Procedure
The FREQ Procedure
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
Quiz
PART Workbook
Practice Programming Scenarios
Quiz Answer Keys and Scenario Solutions
Appendix
Quiz Answer Keys
Basic Concepts
Accessing Your Data
Creating SAS Data Sets
Identifying and Correcting SAS Language Errors
Creating Reports
Understanding DATA Step Processing
BY-Group Processing
Creating and Managing Variables
Combining SAS Data Sets
Processing Data with DO Loops
SAS Formats and Informats
SAS Date, Time, and Datetime Values
Using Functions to Manipulate Data
Producing Descriptive Statistics
Creating Output
Programming Scenario Solutions