About This Book

Purpose

The SAS Certification Prep Guide: Advanced Programming for SAS®9 prepares you to take the SAS Advanced Programming exam for SAS®9. New and experienced SAS users who want to prepare for this exam will find this guide to be an invaluable, convenient, and comprehensive resource that covers all of the topics tested on the exam.

Major topics include SQL processing with SAS, the SAS macro language, advanced SAS programming techniques, and optimizing SAS programs. You will also become familiar with the enhancements and new functionality that are available in SAS®9.

The book includes quizzes that enable you to test your understanding of material in each chapter. Additionally, solutions to all quizzes are included at the back of the book.

Audience

The SAS Certification Prep Guide: Advanced Programming for SAS®9 is for new or experienced SAS programmers who want to prepare for the SAS Advanced Programming exam for SAS®9.

Prerequisites

Candidates must earn the SAS Certified Base Programmer for SAS®9 credential before taking the SAS Advanced Programming exam for SAS®9. The SAS Certification Prep Guide: Base Programming for SAS®9 covers all of the objectives tested on the SAS Base Programming exam for SAS®9, including importing and exporting raw data files, creating and modifying SAS data sets, and identifying and correcting data syntax and programming logic errors.

If you want to test yourself to see if you have the necessary prerequisite base programming knowledge, go to http://support.sas.com/basepractice.

How to Create Practice Data

If you are using the SAS 9.1 windowing environment, you can practice what you learn in this book by using sample data in the actual SAS®9 environment. To set up practice data in SAS, select Help

How to Create Practice Data

If you are using SAS Learning Edition 4.1, you can practice what you learn in this book by using the SAS windowing environment (the programming approach to SAS) to create the data under the Help menu.

  1. On your desktop, right-click My Computer and select Explore from the pop-up menu.

  2. Navigate to the directory where you installed SAS Learning Edition.

  3. Right-click sas.exe and select Send To and then select Desktop.

  4. A SAS icon now appears on your desktop.

  5. Anytime you want to start the SAS windowing environment, double-click the SAS icon on your desktop.

Syntax Conventions

This is an example of how the general form of SAS code is shown in the book:

For example, in the general form above,

SELECT, FROM, WHERE, GROUP BY, and ORDER BY are in uppercase because they must be spelled as shown

column-1, table-1, view-1, and expression are in italics because each represents a value that you supply

<,...column-n> is enclosed in angle brackets because it is optional syntax

table-1 and view-1

are separated by a vertical bar ( | )to indicate that they are mutually exclusive.

The general forms of SAS statements and commands that are shown in this book include only the syntax that you need to know to prepare for the certification exam. For complete syntax, see the appropriate SAS reference guide.

SAS Certification Practice Exam: Advanced Programming for SAS®9

The SAS Certification Practice Exam: Advanced Programming for SAS®9 was designed to help you prepare for the SAS Advanced Programming for SAS®9 exam. This practice exam was constructed to test the same knowledge and skills as the official certification exam. You can access this exam under the SAS Certification category at http://support.sas.com/advpractice. There is a fee for this practice exam.

SAS Advanced Programming for SAS®9 Exam

For information about how to register for the official SAS Advanced Programming for SAS®9 exam, see the SAS Global Certification Program Web site at http://support.sas.com/advpractice.

Additional Resources

Other resources might be helpful when learning SAS programming. You can refer to them as needed to enhance your understanding of the material covered in this book. You can access SAS help, documentation, and other resources from your SAS software or on the Web.

From SAS Software

Help

SAS 9: Select Help

Additional Resources

SAS Enterprise Guide: Select Help

Additional Resources

Enterprise Guide Help.

Documentation

SAS 9: Select Help

Additional Resources

SAS Enterprise Guide: Access online documentation on the Web (see On the Web below).

On the Web

Bookstore

http://support.sas.com/publishing/

Training

http://support.sas.com/training/

Certification

http://support.sas.com/certify/

SAS Learning Edition

http://support.sas.com//learn/le/

SAS Global Academic Program

http://support.sas.com/learn/ap

SAS OnDemand

http://support.sas.com/ondemand/

Or

Knowledge Base

http://support.sas.com/resources/

Support

http://support.sas.com/techsup/

Learning Center

http://support.sas.com/learn/

Community

http://support.sas.com/community/

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset