Book description
Prepare for the SAS Base Programming for SAS®9 certification exam with the official guide by the SAS® Certified Professional Program. New and experienced SAS users who want to prepare for the SAS Base Programming for SAS®9 certification exam will find this guide 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. Includes a free CD-ROM with tutorials, practice data, and sample programs to further reinforce and test your SAS skills.
Table of contents
- Copyright
- About This Book
- 1. Basic Concepts
- 2. Referencing Files and Setting Options
- 3. Editing and Debugging SAS Programs
-
4. Creating List Reports
- Overview
- Types of Reports
- Creating a Basic Report
- Identifying Observations
- Selecting 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
- Summary
- Practice
- Quiz
-
5. Creating SAS Data Sets from Raw Data
- Overview
- Raw Data Files
- Steps to Create a SAS Data Set
- 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
- Steps to Create a Raw Data File
- Additional Features
- Summary
- Practice
- Quiz
- 6. Understanding DATA Step Processing
- 7. Creating and Applying User-Defined Formats
- 8. Creating Enhanced List and Summary Reports
-
9. Producing Descriptive Statistics
- Overview
- Computing Statistics for Numeric Variables
- Producing Frequency Tables
-
Summary
-
Text Summary
- Purpose of PROC MEANS
- Specifying 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
- The FREQ Procedure
- Specifying Variables
- Creating Two-Way Tables
- Creating N-Way Tables
- Creating Tables in List Format
- Suppressing Table Information
- Points to Remember
-
Text Summary
- Practice
- Quiz
- 10. Producing HTML Output
- 11. Creating and Managing Variables
- 12. Reading SAS Data Sets
- 13. Combining SAS Data Sets
-
14. Transforming Data with SAS Functions
- Overview
- Understanding SAS Functions
- General Form of SAS Functions
-
Converting Data with Functions
- Introduction to Converting Data
- Potential Problems of Omitting INPUT or PUT
- Automatic Character-to-Numeric Conversion
- When Automatic Conversion Occurs
- Restriction for WHERE Expressions
- Explicit Character-to-Numeric Conversion
- Automatic Numeric-to-Character Conversion
- Explicit Numeric-to-Character Conversion
- Manipulating SAS Date Values with Functions
- Modifying Character Values with Functions
- Modifying Numeric Values with Functions
- Nesting SAS Functions
-
Summary
-
Text Summary
- Using SAS Functions
- Automatic Character-to-Numeric Conversion
- Explicit Character-to-Numeric Conversion
- Automatic Numeric-to-Character Conversion
- Explicit Numeric-to-Character Conversion
- SAS Date and Time Values
- YEAR, QTR, MONTH, and DAY Functions
- WEEKDAY Function
- MDY Function
- DATE and TODAY Functions
- INTCK Function
- INTNX Function
- DATDIF and YRDIF Functions
- SCAN Function
- SUBSTR Function
- SCAN Function versus SUBSTR Function
- TRIM Function
- CATX Function
- INDEX Function
- FIND Function
- UPCASE Function
- LOWCASE Function
- PROPCASE Function
- TRANWRD Function
- INT Function
- ROUND Function
- Nesting SAS Functions
- Points to Remember
-
Text Summary
- Practice
- Quiz
-
15. Generating Data with DO Loops
- Overview
- Constructing DO Loops
- Nesting DO Loops
- Iteratively Processing Data That Is Read from a Data Set
- Conditionally Executing DO Loops
- Using Conditional Clauses with the Iterative DO Statement
- Creating Samples
-
Summary
-
Text Summary
- Purpose of DO Loops
- Syntax of Iterative DO Loops
- DO Loop Execution
- Counting DO Loop Iterations
- Decrementing DO Loops
- Specifying a Series of Items
- Nesting DO Loops
- Iteratively Processing Data That Is Read from a Data Set
- Conditionally Executing DO Loops
- Using Conditional Clauses within Iterative DO Statements
- Creating Samples
- Points to Remember
-
Text Summary
- Practice
- Quiz
-
16. Processing Variables with Arrays
- Overview
- Creating One-Dimensional Arrays
- Expanding Your Use of Arrays
- Additional Features
-
Summary
-
Text Summary
- Purpose of SAS Arrays
- Defining an Array
- Variable Lists as Array Elements
- Referencing Elements of an Array
- The DIM Function
- Creating Variables with the ARRAY Statement
- Assigning Initial Values to Arrays
- Creating Temporary Array Elements
- Multidimensional Arrays
- Referencing Elements of a Two-Dimensional Array
- Rotating Data Sets
- Points to Remember
-
Text Summary
- Practice
- Quiz
- 17. Reading Raw Data in Fixed Fields
- 18. Reading Free-Format Data
- 19. Reading Date and Time Values
- 20. Creating a Single Observation from Multiple Records
- 21. Creating Multiple Observations from a Single Record
- 22. Reading Hierarchical Files
-
Quiz Answer Keys
- Chapter 1: Basic Concepts Answer Key
- Chapter 2: Referencing Files and Setting Options Answer Key
- Chapter 3: Editing and Debugging SAS Programs Answer Key
- Chapter 4: Creating List Reports Answer Key
- Chapter 5: Creating SAS Data Sets from Raw Data Answer Key
- Chapter 6: Understanding DATA Step Processing Answer Key
- Chapter 7: Creating and Applying User-Defined Formats Answer Key
- Chapter 8: Creating Enhanced List and Summary Reports Answer Key
- Chapter 9: Producing Descriptive Statistics Answer Key
- Chapter 10: Producing HTML Output Answer Key
- Chapter 11: Creating and Managing Variables Answer Key
- Chapter 12: Reading SAS Data Sets Answer Key
- Chapter 13: Combining SAS Data Sets Answer Key
- Chapter 14: Transforming Data with SAS Functions Answer Key
- Chapter 15: Generating Data with DO Loops Answer Key
- Chapter 16: Processing Variables with Arrays Answer Key
- Chapter 17: Reading Raw Data in Fixed Fields Answer Key
- Chapter 18: Reading Free-Format Data Answer Key
- Chapter 19: Reading Date and Time Values Answer Key
- Chapter 20: Creating a Single Observation from Multiple Records Answer Key
- Chapter 21: Creating Multiple Observations from a Single Record Answer Key
- Chapter 22: Reading Hierarchical Files Answer Key
- Glossary
Product information
- Title: SAS® Certification Prep Guide: Base Programming for SAS®9
- Author(s):
- Release date: March 2006
- Publisher(s): SAS Institute
- ISBN: 9781590479223
You might also like
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 …
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 9.4 SQL Procedure User's Guide, Fourth Edition, 4th Edition
Describes the basics of using the SQL procedure and provides comprehensive reference information. The usage information …