SAS Certified Specialist Prep Guide

Description

The SAS^® Certified Specialist Prep Guide: Base Programming Using SAS^® 9.4 prepares you to take the new SAS 9.4 Base Programming -- Performance-Based Exam. This is the official guide by the SAS Global Certification Program.

This prep guide is for both new and experienced SAS users, and it covers all the objectives that are tested on the exam.

New in this edition is a workbook whose sample scenarios require you to write code to solve problems and answer questions. Answers for the chapter quizzes and solutions for the sample scenarios in the workbook are included. You will also find links to exam objectives, practice exams, and other resources such as the Base SAS^® glossary and a list of practice data sets. Major topics include importing data, creating and modifying SAS data sets, and identifying and correcting both data syntax and programming logic errors.
All exam topics are covered in these chapters:

• Setting Up Practice Data
  
• Basic Concepts
  
• Accessing Your Data
  
• Creating SAS Data Sets
  
• Identifying and Correcting SAS Language Errors
  
• Creating Reports
  
• Understanding DATA Step Processing
  
• BY-Group Processing
  
• Creating and Managing Variables
  
• Combining SAS Data Sets
  
• Processing Data with DO Loops
  
• SAS Formats and Informats
  
• SAS Date, Time, and Datetime Values
  
• Using Functions to Manipulate Data
  
• Producing Descriptive Statistics
  
• Creating Output
  
• Practice Programming Scenarios (Workbook)
  

Sujets

• Descriptive statistics
• SAS
• Base

Informations

• Publié par: SAS Institute
• Date de parution: 11 février 2019
• Nombre de lectures: 30
• EAN13: 9781642951769
• Langue: English
• Poids de l'ouvrage: 1 Mo

Extrait

The correct bibliographic citation for this manual is as follows: SAS Institute Inc. 2019 . SAS® Certified Specialist Prep Guide: Base Programming Using SAS® 9.4 Cary , NC: SAS Institute Inc.
SAS® Certified Specialist Prep Guide: Base Programming Using SAS® 9.4
Copyright © 2019, SAS Institute Inc., Cary, NC, USA
ISBN 978-1-64295-179-0 (Hard copy)
ISBN 978-1-64295-176-9 (Epub)
ISBN 978-1-64295-177-6 (Mobi)
ISBN 978-1-64295-178-3 (PDF)
All Rights Reserved. Produced in the United States of America.
For a hard copy book: No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, or otherwise, without the prior written permission of the publisher, SAS Institute Inc.
For a web download or e-book: Your use of this publication shall be governed by the terms established by the vendor at the time you acquire this publication.
The scanning, uploading, and distribution of this book via the Internet or any other means without the permission of the publisher is illegal and punishable by law. Please purchase only authorized electronic editions and do not participate in or encourage electronic piracy of copyrighted materials. Your support of others' rights is appreciated.
U.S. Government License Rights; Restricted Rights: The Software and its documentation is commercial computer software developed at private expense and is provided with RESTRICTED RIGHTS to the United States Government. Use, duplication, or disclosure of the Software by the United States Government is subject to the license terms of this Agreement pursuant to, as applicable, FAR 12.212, DFAR 227.7202-1(a), DFAR 227.7202-3(a), and DFAR 227.7202-4, and, to the extent required under U.S. federal law, the minimum restricted rights as set out in FAR 52.227-19 (DEC 2007). If FAR 52.227-19 is applicable, this provision serves as notice under clause (c) thereof and no other notice is required to be affixed to the Software or documentation. The Government’s rights in Software and documentation shall be only those set forth in this Agreement.
SAS Institute Inc., SAS Campus Drive, Cary, NC 27513-2414
February 2019

SAS® and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.

Other brand and product names are trademarks of their respective companies.
P1:certsppg
Last updated: February 6, 2019
SAS® Certified Specialist Prep Guide: Base Programming Using SAS® 9.4

Title Page Copyright Accessibility Features of the Prep Guide How to Prepare for the Exam
Part 1: SAS Certified Specialist Prep Guide Chapter 1: Setting Up Practice Data Accessing Your Practice Data Chapter 2: Basic Concepts Getting Started The Basics of the SAS Language SAS Libraries Referencing SAS Files SAS Data Sets Chapter Quiz Chapter 3: Accessing Your Data SAS Libraries Viewing SAS Libraries Chapter Quiz Chapter 4: 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 Chapter 5: Identifying and Correcting SAS Language Errors Error Messages Correcting Common Errors Chapter Quiz Chapter 6: 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 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: BY-Group Processing Definitions Preprocessing Data FIRST. and LAST. DATA Step Variables Chapter Quiz Chapter 9: Creating and Managing Variables Creating Variables Modifying Variables Specifying Lengths for Variables Subsetting Data Transposing Variables into Observations Using SAS Macro Variables Chapter Quiz Chapter 10: 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 Chapter 11: 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 Chapter 12: SAS Formats and Informats Applying SAS Formats and Informats The FORMAT Procedure Defining a Unique Format Associating User-Defined Formats with Variables Chapter Quiz Chapter 13: 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 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: Producing Descriptive Statistics The MEANS Procedure The FREQ Procedure Chapter Quiz Chapter 16: 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
Part 2: Workbook Chapter 17: Practice Programming Scenarios Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Scenario 6 Scenario 7 Scenario 8 Scenario 9 Scenario 10
Part 3: Quiz Answer Keys and Scenario Solutions Appendix 1: Chapter Quiz Answer Keys Chapter 2: Basic Concepts Chapter 3: Accessing Your Data Chapter 4: Creating SAS Data Sets Chapter 5: Identifying and Correcting SAS Language Errors Chapter 6: Creating Reports Chapter 7: Understanding DATA Step Processing Chapter 8: BY-Group Processing Chapter 9: Creating and Managing Variables Chapter 10: Combining SAS Data Sets Chapter 11: Processing Data with DO Loops Chapter 12: SAS Formats and Informats Chapter 13: SAS Date, Time, and Datetime Values Chapter 14: Using Functions to Manipulate Data Chapter 15: Producing Descriptive Statistics Chapter 16: Creating Output Appendix 2: Programming Scenario Solutions Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Scenario 6 Scenario 7 Scenario 8 Scenario 9 Scenario 10 Index Additional Resources
Accessibility Features of the Prep Guide

Overview

The SAS Certified Specialist Prep Guide: Base Programming Using SAS 9.4 is a test preparation document that uses the following environments and products:


SAS windowing environment

SAS Enterprise Guide

SAS Studio or SAS University Edition


Accessibility Documentation Help

The following table contains accessibility information for the listed products:

Product or Environment
Where to Find Accessibility Documentation
Base SAS (Microsoft Windows, UNIX, and z/OS )
support.sas.com/baseaccess
SAS Enterprise Guide
support.sas.com/documentation/onlinedoc/guide/index.html
SAS Studio
support.sas.com/studioaccess

Documentation Format

Contact [e-mail] if you need this document in an alternative digital format.
Last updated: February 6, 2019
How to Prepare for the Exam

Requirements and Details

Requirements

To complete examples in this book, you must have access to SAS windowing environment, SAS Enterprise Guide, or SAS Studio.

Exam Objectives and Updates to This Book

The current exam objectives and a list of any updates to this book are available at www.sas.com/certify . Exam objectives are subject to change.

Take a Practice Exam

Practice exams are available for purchase through SAS and Pearson VUE. For more information about practice exams, see www.sas.com/base_programmer_cert .

Registering for the Exam

To register for the SAS 9.4 Base Programming – Performance-Based Exam, see the SAS Global Certification website at www.sas.com/certify .

Additional Resources for Learning SAS Programming


From SAS Software
Help



SAS ® 9: Select Help > SAS Help and Documentation .

SAS Enterprise Guide: Select Help > SAS Enterprise Guide Help .

SAS Studio: Select the Help icon .
Documentation



SAS ® 9: Select Help > SAS Help and Documentation .

SAS Enterprise Guide: Access online documentation on the web.

SAS Studio: Select the Help icon and then click Help .

On the Web
Base SAS Glossary
support.sas.com/baseglossary
Bookstore
www.sas.com/books
Certification
www.sas.com/certify
Communities
communities.sas.com
Knowledge Base
support.sas.com/notes
Learning Center
www.sas.com and click Learn . Then select Get Started with SAS .
SAS Documentation
support.sas.com/documentation
documentation.sas.com
SAS Global Academic Program
www.sas.com and click Learn . Then select For Students and Educators .
SAS OnDemand
support.sas.com/ondemand/
Syntax Quick Reference Guide
support.sas.com/content/dam/SAS/support/en/books/dat