Book description
Prepare for the SAS Base Programming for SAS 9 exam with the official guide by the SAS Global Certification Program.
New and experienced SAS users who want to prepare for the SAS Base Programming for SAS 9 exam will find this guide to be an invaluable, convenient, and comprehensive resource that covers all of the objectives tested on the exam. Now in its fourth edition, the guide has been extensively updated, and revised to streamline explanations.
Major topics include importing and exporting raw data files, creating and modifying SAS data sets, and identifying and correcting data syntax and programming logic errors. The chapter quizzes have been thoroughly updated and full solutions are included at the back of the book. In addition, links are provided to the exam objectives, practice exams, and other helpful resources, such as the updated Base SAS glossary and an expanded collection of practice data sets.
Content updates are available here.Table of contents
- Title Page
- Copyright
- Accessibility Features of the SAS Certification Prep Guide
- How to Prepare for the SAS Base Programming for SAS®9 Exam
- Chapter 1: Setting Up Practice Data
- Chapter 2: Basic Concepts
- Chapter 3: Setting Up Your SAS Session
- Chapter 4: Identifying and Correcting Errors
- Chapter 5: Creating List Reports
-
Chapter 6: Creating SAS Data Sets from External Files
- Raw Data Files
- Creating a SAS Data Set from a Raw Data File
- Referencing a Raw Data File
- DATA Step Statements for Reading Data
- Reading and Verifying the Data
- Creating and Modifying Variables
- Subsetting Data
- Reading Instream Data
- Creating a Raw Data File
- Reading Microsoft Excel Data
- LIBNAME Statement Options
- Creating Excel Worksheets
- The IMPORT Procedure
- Chapter Quiz
- Chapter 7: Understanding DATA Step Processing
- Chapter 8: Creating and Applying User-Defined Formats
-
Chapter 9: Producing Descriptive Statistics
- Computing Statistics Using PROC MEANS
- Selecting Statistics
- Limiting Decimal Places
- Specifying Variables in PROC MEANS
- Group Processing Using the CLASS Statement
- Group Processing Using the BY Statement
- Creating a Summarized Data Set Using PROC MEANS
- Creating a Summarized Data Set Using PROC SUMMARY
- Producing Frequency Tables Using PROC FREQ
- Specifying Variables in PROC FREQ
- Creating Two-Way Tables
- Creating N-Way Tables
- Creating Tables in List Format
- Chapter Quiz
- Chapter 10: Creating Output with ODS
- Chapter 11: Creating and Managing Variables
- Chapter 12: Reading SAS Data Sets
- Chapter 13: Combining SAS Data Sets
- Chapter 14: Using Functions to Manipulate Data
- Chapter 15: Processing Data with DO Loops
- Chapter 16: Processing Data with Arrays
- Chapter 17: Reading Raw Data in Fixed Fields
- Chapter 18: Reading and Creating Raw Data in Free-Format
- Chapter 19: SAS Date and Time Values
- Chapter 20: Creating a Single Observation from Multiple Raw Data Records
- Chapter 21: Creating Multiple Observations from a Single Raw Data Record
- Chapter 22: Conditioning Raw Data Files
-
Appendix 1: Quiz Answer Keys
- Chapter 2: Basic Concepts
- Chapter 3: Setting Up Your SAS Session
- Chapter 4: Identifying and Correcting Errors
- Chapter 5: Creating List Reports
- Chapter 6: Creating SAS Data Sets from External Files
- Chapter 7: Understanding DATA Step Processing
- Chapter 8: Creating and Applying User-Defined Formats
- Chapter 9: Producing Descriptive Statistics
- Chapter 10: Creating Output with ODS
- Chapter 11: Creating and Managing Variables
- Chapter 12: Reading SAS Data Sets
- Chapter 13: Combining SAS Data Sets
- Chapter 14: Using Functions to Manipulate Data
- Chapter 15: Processing Data with DO Loops
- Chapter 16: Processing Data with Arrays
- Chapter 17: Reading Raw Data in Fixed Fields
- Chapter 18: Reading and Creating Raw Data in Free-Format
- Chapter 19: SAS Date and Time Values
- Chapter 20: Creating a Single Observation from Multiple Raw Data Records
- Chapter 21: Creating Multiple Observations from a Single Raw Data Record
- Chapter 22: Conditioning Raw Data Files
- Index
- Additional Resources
Product information
- Title: SAS Certification Prep Guide, 4th Edition
- Author(s):
- Release date: January 2018
- Publisher(s): SAS Institute
- ISBN: 9781635264685
You might also like
book
SAS Certification Prep Guide, 4th Edition
Businesses rely on career professionals with strong SAS knowledge and skills. Set yourself apart from the …
book
SAS Certification Prep Guide, 5th Edition
Prepare for the SAS Base Programming for SAS 9 exam with the official guide by the …
book
SAS Certified Professional Prep Guide
The official guide by the SAS Global Certification Program, SAS Certified Professional Prep Guide: Advanced Programming …
book
SAS Certification Prep Guide
Must-have study guide for the SAS® Certified Statistical Business Analyst Using SAS®9: Regression and Modeling exam! …