Home Page Icon
Home Page
Table of Contents for
Title Page
Close
Title Page
by SAS Institute
SAS Certification Prep Guide, 4th Edition
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
Determine What SAS Solution or Environment You Are Using
Determine Whether You Have Write Access
SAS Windowing Environment
SAS Studio and SAS University Edition
SAS Enterprise Guide
Chapter 2: Basic Concepts
Getting Started
The Basics of the SAS Language
SAS Libraries
Referencing SAS Files
SAS Data Sets
Chapter Quiz
Chapter 3: Setting Up Your SAS Session
SAS Libraries
Viewing SAS Libraries
Specifying Results Formats
Setting System Options
Chapter Quiz
Chapter 4: Identifying and Correcting Errors
Error Messages
Correcting Common Errors
Chapter Quiz
Chapter 5: Creating List Reports
Creating a Basic Report
Selecting Variables
Identifying Observations
Sorting Data
Generating Column Totals
Double Spacing LISTING Output
Specifying Titles and Footnotes in Procedure Output
Assigning Descriptive Labels
Formatting Data Values
Using Permanently Assigned Labels and Formats
Chapter Quiz
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
How SAS Processes Programs
Compilation Phase
Execution Phase
Debugging a DATA Step
Testing Your Programs
Chapter Quiz
Chapter 8: Creating and Applying User-Defined Formats
The FORMAT Procedure
Defining a Unique Format
Associating User-Defined Formats with Variables
Chapter Quiz
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
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
Chapter Quiz
Chapter 11: Creating and Managing Variables
Creating and Modifying Variables
Assigning Values Conditionally
Specifying Lengths for Variables
Subsetting Data
Assigning Permanent Labels and Formats
Assigning Values Conditionally Using SELECT Groups
Grouping Statements Using DO Groups
Chapter Quiz
Chapter 12: Reading SAS Data Sets
Reading a Single Data Set to Create Another
Manipulating Data
Using BY-Group Processing
Writing Observations Explicitly
Detecting the End of a Data Set
Chapter Quiz
Chapter 13: 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
Appending: Details
Interleaving: Details
Match-Merging: Details
Match-Merge Processing
Renaming Variables
Excluding Unmatched Observations
Selecting Variables
Chapter Quiz
Chapter 14: 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
Chapter 15: 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
Using Conditional Clauses with the Iterative DO Statement
Chapter Quiz
Chapter 16: Processing Data with Arrays
The Basics of SAS Arrays
Creating One-Dimensional Arrays
Expanding Your Use of Arrays
Chapter Quiz
Chapter 17: Reading Raw Data in Fixed Fields
Identifying the Type of Numeric Data
Using Formatted Input
Using Informats
Using Record Formats
Chapter Quiz
Chapter 18: Reading and Creating Raw Data in Free-Format
Free-Format Data
Reading Standard Data with List Input
Specifying the Length of Character Variables
Reading Free-Format Data with Non-Blank Delimiters and Missing Values
Reading Nonstandard Data with List Input
Creating Free-Format Data
Write a Comma-Delimited File Using Formats
Chapter Quiz
Chapter 19: SAS Date and Time Values
Reading Dates and Times with Informats
Using Dates and Times in Calculations
Displaying Date and Time Values with Formats
Chapter Quiz
Chapter 20: Creating a Single Observation from Multiple Raw Data Records
A Word About Creating a Single Observation
Using Line Pointer Controls
Reading Multiple Records Sequentially
Reading Multiple Records Non-Sequentially
Combining Line Pointer Controls
Chapter Quiz
Chapter 21: Creating Multiple Observations from a Single Raw Data Record
A Word About Creating Multiple Observations
Reading Repeating Blocks of Data
Reading the Same Number of Repeating Fields
Reading a Varying Number of Repeating Fields
Chapter Quiz
Chapter 22: Conditioning Raw Data Files
A Word About Conditioning Raw Data Files
Creating One Observation per Detail Record
Creating One Observation per Header Record
Processing a DATA Step That Creates One Observation per Header Record
Chapter Quiz
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
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Copyright
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset