فهرست مطالب

• 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