Book description
New and experienced SAS users who want to prepare for the Base Programming for SAS 9 exam will find the SAS Certification Prep Guide: Base Programming for SAS 9 to be an invaluable, convenient, and comprehensive resource that covers all of the objectives tested on the exam. 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. You will also become familiar with the enhancements and new functionality that are available in SAS 9. Each chapter includes a quiz on the chapter's contents. This guide provides you with a solid study resource as well as a go-to reference for your library.Table of contents
- Cover Page
- Copyright Page
- Contents
- About This Book
- Chapter 1: Base Programming
- Chapter 2: Referencing Files and Setting Options
- Chapter 3: Editing and Debugging SAS Programs
-
Chapter 4: Creating List Reports
- Overview
- Creating a Basic Report
- Selecting Variables
- Identifying Observations
- Sorting Data
- Generating Column Totals
- Double Spacing LISTING Output
- Specifying Titles and Footnotes
- Assigning Descriptive Labels
- Formatting Data Values
- Using Permanently Assigned Labels and Formats
- Additional Features
- Chapter Summary
- Chapter Quiz
-
Chapter 5: Creating SAS Data Sets from External Files
- Overview
- Raw Data Files
- Steps to Create a SAS Data Set from a Raw Data File
- Referencing a SAS Library
- Referencing a Raw Data File
- Writing a DATA Step Program
- Submitting the DATA Step Program
- Creating and Modifying Variables
- Subsetting Data
- Reading Instream Data
- Creating a Raw Data File
- Additional Features
- Reading Microsoft Excel Data
- LIBNAME Statement Options
- Creating Excel Worksheets
- The IMPORT Wizard
- Chapter Summary
- Chapter Quiz
- Chapter 6: Understanding DATA Step Processing
- Chapter 7: Creating and Applying User-Defined Formats
-
Chapter 8: Producing Descriptive Statistics
- Overview
- Objectives
- 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 Summary
- Chapter Quiz
- Chapter 9: Producing HTML Output
- Chapter 10: Creating and Managing Variables
- Chapter 11: Reading SAS Data Sets
- Chapter 12: Combining SAS Data Sets
- Chapter 13: Transforming Data with SAS Functions
- Chapter 14: Generating Data with DO Loops
- Chapter 15: Processing Variables with Arrays
- Chapter 16: Reading Raw Data in Fixed Fields
- Chapter 17: Reading Free-Format Data
- Chapter 18: Reading Date and Time Values
- Chapter 19: Creating a Single Observation from Multiple Records
- Chapter 20: Creating Multiple Observations from a Single Record
- Chapter 21: Reading Hierarchical Files
-
Appendix 1: Quiz Answer Keys
- Chapter 1: Base Programming
- Chapter 2: Referencing Files and Setting Options
- Chapter 3: Editing and Debugging SAS Programs
- Chapter 4: Creating List Reports
- Chapter 5: Creating SAS Data Sets from External Files
- Chapter 6: Understanding DATA Step Processing
- Chapter 7: Creating and Applying User-Defined Formats
- Chapter 8: Producing Descriptive Statistics
- Chapter 9: Producing HTML Output
- Chapter 10: Creating and Managing Variables
- Chapter 11: Reading SAS Data Sets
- Chapter 12: Combining SAS Data Sets
- Chapter 13: Transforming Data with SAS Functions
- Chapter 14: Generating Data with DO Loops
- Chapter 15: Processing Variables with Arrays
- Chapter 16: Reading Raw Data in Fixed Fields
- Chapter 17: Reading Free-Format Data
- Chapter 18: Reading Date and Time Values
- Chapter 19: Creating a Single Observation from Multiple Records
- Chapter 20: Creating Multiple Observations from a Single Record
- Chapter 21: Reading Hierarchical Files
- Glossary
- Index
Product information
- Title: SAS Certification Prep Guide: Base Programming for SAS 9, Third Edition
- Author(s):
- Release date: July 2011
- Publisher(s): SAS Institute
- ISBN: 9781607645641
You might also like
book
SAS Certification Prep Guide
Must-have study guide for the SAS® Certified Statistical Business Analyst Using SAS®9: Regression and Modeling exam! …
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: Advanced Programming for SAS®9, Third Edition
Prepares you to take the Advanced Programming for SAS 9 exam. Major topics include SQL processing …
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 …