SAS Certified Professional Prep Guide

Description

The official guide by the SAS Global Certification Program, SAS Certified Professional Prep Guide: Advanced Programming Using SAS 9.4 prepares you to take the new SAS 9.4 Advanced Programming Performance-Based Exam.

New in this edition is a workbook whose sample scenarios require you to write code to solve problems and answer questions. Answers to the chapter quizzes and solutions to 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 SQL processing, SAS macro language processing, and advanced SAS programming techniques.

All exam topics are covered in the following chapters:

SQL Processing with SAS

• PROC SQL Fundamentals
  
• Creating and Managing Tables
  
• Joining Tables Using PROC SQL
  
• Joining Tables Using Set Operators
  
• Using Subqueries
  
• Advanced SQL Techniques
  

SAS Macro Language Processing

• Creating and Using Macro Variables
  
• Storing and Processing Text
  
• Working with Macro Programs
  
• Advanced Macro Techniques
  

Advanced SAS Programming Techniques

• Defining and Processing Arrays
  
• Processing Data Using Hash Objects
  
• Using SAS Utility Procedures
  
• Using Advanced Functions
  

Practice Programming Scenarios (Workbook)

Sujets

• AdvancED
• SAS

Informations

• Publié par: SAS Institute
• Date de parution: 18 octobre 2019
• Nombre de lectures: 1
• EAN13: 9781642954692
• Langue: English

Extrait

The correct bibliographic citation for this manual is as follows: SAS Institute Inc. 2019 . SAS® Certified Professional Prep Guide: Advanced Programming Using SAS® 9.4 Cary , NC: SAS Institute Inc.
SAS® Certified Professional Prep Guide: Advanced Programming Using SAS® 9.4
Copyright © 2019, SAS Institute Inc., Cary, NC, USA
ISBN 978-1-64295-467-8 (Paperback)
ISBN 978-1-64295-469-2 (Epub)
ISBN 978-1-64295-470-8 (Mobi)
ISBN 978-1-64295-468-5 (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
October 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:certprpg
Last updated: October 16, 2019
SAS® Certified Professional Prep Guide: Advanced Programming Using SAS® 9.4

Title Page Copyright Using Sample Data Accessibility Features of the Prep Guide How to Prepare for the Exam Part 1: SQL Processing with SAS Chapter 1: PROC SQL Fundamentals PROC SQL Basics The PROC SQL SELECT Statement The FROM Clause The WHERE Clause The GROUP BY Clause The HAVING Clause The ORDER BY Clause PROC SQL Options Validating Query Syntax Quiz End Notes Chapter 2: Creating and Managing Tables The CREATE TABLE Statement Using the LIKE Clause Using the AS Keyword The INSERT Statement The DESCRIBE TABLE Statement Using Dictionary Tables Chapter Quiz Chapter 3: Joining Tables Using PROC SQL Understanding Joins Generating a Cartesian Product Using Inner Joins Using Natural Joins Using Outer Joins Comparing SQL Joins and DATA Step Match-Merges Quiz Chapter 4: Joining Tables Using Set Operators Understanding Set Operators Using the EXCEPT Set Operator Using the INTERSECT Set Operator Using the UNION Set Operator Using the OUTER UNION Set Operator Quiz Chapter 5: Using Subqueries Subsetting Data Using Subqueries Creating and Managing Views Using PROC SQL Quiz Chapter 6: Advanced SQL Techniques Creating Data-Driven Macro Variables with PROC SQL Accessing DBMS Data with SAS/ACCESS The FedSQL Procedure Quiz Part 2: SAS Macro Language Processing Chapter 7: Creating and Using Macro Variables Introducing Macro Variables The SAS Macro Facility Using Macro Variables Troubleshooting Macro Variable References Delimiting Macro Variable References Quiz Chapter 8: Storing and Processing Text Processing Text with Macro Functions Using SAS Macro Functions to Manipulate Character Strings Using SAS Functions with Macro Variables Using SAS Macro Functions to Mask Special Characters Creating Macro Variables during PROC SQL Step Execution Creating Macro Variables during DATA Step Execution Referencing Macro Variables Indirectly Quiz Chapter 9: Working with Macro Programs Defining and Calling a Macro Passing Information into a Macro Using Parameters Controlling Variable Scope Debugging Macros Conditional Processing Iterative Processing Quiz Chapter 10: Advanced Macro Techniques Storing Macro Definitions in External Files Understanding Session Compiled Macros Using the Autocall Facility Data-Driven Macro Calls Quiz Part 3: Advanced SAS Programming Techniques Chapter 11: Defining and Processing Arrays Defining and Referencing One-Dimensional Arrays Expanding Your Use of One-Dimensional Arrays Defining and Referencing Two-Dimensional Arrays Quiz Chapter 12: Processing Data Using Hash Objects Declaring Hash Objects Defining Hash Objects Finding Key Values in a Hash Object Writing a Hash Object to a Table Hash Object Processing Using Hash Iterator Objects Quiz Chapter 13: Using SAS Utility Procedures Creating Picture Formats with the FORMAT Procedure Creating Functions with PROC FCMP Quiz Chapter 14: Using Advanced Functions Using a Variety of Advanced Functions Performing Pattern Matching with Perl Regular Expressions Quiz Part 4: Workbook Chapter 15: Practice Programming Scenarios Differences between the Workbook and Certification Exam Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Scenario 6 Scenario 7 Scenario 8 Scenario 9 Scenario 10 Part 5: Solutions Chapter 16: Chapter Quiz Answer Keys Chapter 1: PROC SQL Fundamentals Chapter 2: Creating and Managing Tables Chapter 3: Joining Tables Using PROC SQL Chapter 4: Joining Tables Using Set Operators Chapter 5: Using Subqueries Chapter 6: Advanced SQL Techniques Chapter 7: Creating and Using Macro Variables Chapter 8: Storing and Processing Text Chapter 9: Working with Macro Programs Chapter 10: Advanced Macro Techniques Chapter 11: Defining and Processing Arrays Chapter 12: Processing Data Using Hash Objects Chapter 13: Using SAS Utility Procedures Chapter 14: Using Advanced Functions Chapter 17: Programming Scenario Solutions Scenario 1 Scenario 2 Scenario 3 Scenario 4 Scenario 5 Scenario 6 Scenario 7 Scenario 8 Scenario 9 Scenario 10 Recommended Reading Index Additional Resources
Using Sample Data

Setting Up Practice Data for SAS OnDemand for Academics
To set up your sample data program in SAS OnDemand:


Navigate to https://github.com/sassoftware/sas-cert-prep-data.
Click the professional-prep-guide directory.
Open the cre8data.sas program and click Raw . Right-click anywhere on the screen and select Save As . Save the cre8data.sas program to a location that is accessible to SAS.
Open the cre8premdata.sas program and click Raw . Right-click anywhere on the screen and select Save As . Save the cre8premdata.sas program to the same location as cre8data.sas .
Log on to SAS OnDemand for Academics and open SAS Studio.
Right-click the Files (Home) folder, and then select New → Folder .
Name the new folder certadv and click Save .
Right-click the certadv folder and select Upload Files .
Click Choose Files and navigate to the certadv folder within the practice-data folder on your local machine.
Select all program files and click Open . All available programs are listed under Select Files . Click Upload .
Open and edit the cre8data.sas program.
In the Path macro variable, replace /folders/myfolders with the path to the certadv folder. Right-click the certadv folder in SAS Studio and click Properties . Copy the path in the Location box and paste it into your %LET statement.
Save and then run the cre8data.sas program.
Your practice data is now created and ready for you to use.
Note: When you end your SAS session, the Path macro variable in the cre8data.sas program is reset. To avoid having to rerun cre8data.sas every time, run the libname.sas program from your sample data folder to restore the libraries.

Setting Up Practice Data in Other SAS Environments
To complete examples in this book, you must have access to the SAS windowing environment, SAS Enterprise Guide, or SAS Studio (or SAS University Edition). To access the sample data files and create your practice data:


Navigate to https://github.com/sassoftware/sas-cert-prep-data.
Click the professional-prep-guide directory.
Open the cre8data.sas program and click Raw . Right-click anywhere on the screen and select Save As . Save the cre8data.sas program to a location that is accessible to SAS. It is recommended that you create a new folder named Certadv in the location that is accessible to SAS and save the cre8data.sas program in the Certadv folder. The librefs that are associated with this book use Certadv as the libref name.
Open the cre8premdata.sas program and click Raw . Right-click anywhere on the screen and select Save As . Save the cre8premdata.sas program to the same location as cre8data.sas .
Open the cre8data.sas program in the SAS environment of your choice. SAS windowing environment: Click File→ Open Program , and then navigate to the Certadv folder in the practice-data folder. SAS Studio: In the Navigation pane, expand Files and Folders and then navigate to the Certadv folder within the practice-data folder. SAS Enterprise Guide: In the Servers list, expand Servers → Local → Files , and then navigate to the Cer