Bookstore
     
Training Console
  |  
800-727-0025

Base SAS

Title Level Training Formats
SAS Programming 1: Essentials
This course is for users who want to learn how to write SAS programs. It is the entry point to learning SAS programming and is a prerequisite to many other SAS courses. If you do not plan to write SAS programs and you prefer a point-and-click interface, you should attend the SAS Enterprise Guide 1: Querying and Reporting course.

2 Fundamental Classroom Live Web Classroom e-Learning
SAS Certification Practice Exam: Base Programming for SAS 9
This practice exam tests the same knowledge and skills as the SAS Base Programming for SAS 9 certification exam. The format of the questions on both exams is identical, and all topics on the practice exam are proportionally weighted to match the Certification exam.

You should be aware of the following differences between this practice exam and the official Certification exam:

  • The practice exam contains 50 questions. The number of questions and the time limit for the SAS Base Programming for SAS 9 certification exam may change from time to time. Please refer to the SAS Global Certification Web site for the most current information.
  • The practice exam is delivered to you in one continuous HTML page. The Certification exam questions are delivered one per screen.
  • There is no timer in the practice exam. To best simulate the designed pace of the Certification exam, you should allow 85 minutes for the practice exam.
Successful performance on the practice exam does not guarantee successful performance on the Certification exam.

1 Beginner e-Learning
SAS Certification Practice Exam: Advanced Programming for SAS 9
This practice exam tests the same knowledge and skills as the SAS Advanced Programming for SAS 9 certification exam. The format of the questions on both exams is identical, and all topics on the practice exam are proportionally weighted to match the Certification exam.

You should be aware of the following differences between this practice exam and the official Certification exam:

  • The practice exam contains 50 questions. The number of questions and the time limit for the SAS Advanced Programming for SAS 9 certification exam may change from time to time. Please refer to the SAS Global Certification Web site for the most current information.
  • The practice exam is delivered to you in one continuous HTML page. The Certification exam questions are delivered one per screen.
  • There is no timer in the practice exam. To best simulate the designed pace of the Certification exam, you should allow 85 minutes for the practice exam.

Successful performance on the practice exam does not guarantee successful performance on the Certification exam.

1 Beginner e-Learning
SAS Programming 2: Data Manipulation Techniques
This course is for those who need to learn data manipulation techniques using SAS DATA and procedure steps to access, transform, and summarize SAS data sets. The course builds on the concepts that are presented in the SAS Programming 1: Essentials course and is not recommended for beginning SAS software users.

3 Intermediate Classroom Live Web Classroom e-Learning
SAS SQL 1: Essentials
This course teaches you how to process SAS data using Structured Query Language (SQL).

3 Intermediate Classroom Live Web Classroom e-Learning
SAS Macro Language 1: Essentials
This course focuses on the components of the SAS macro facility and how to design, write, and debug macro systems. Emphasis is placed on understanding how programs with macro code are processed.

4 Expert Classroom Live Web Classroom e-Learning
SAS Programming 3: Advanced Techniques and Efficiencies
This course is for SAS programmers who prepare data for analysis. The comparisons of manipulation techniques and resource cost benefits are designed to help programmers choose the most appropriate technique for their data situation.

4 Expert Classroom Live Web Classroom e-Learning
Statistics 1: Introduction to ANOVA, Regression, and Logistic Regression
This course is for SAS software users who perform statistical analyses using SAS/STAT software. The focus is on t-tests, ANOVA, linear regression, and logistic regression. This course (or equivalent knowledge) is a prerequisite to many of the courses in the statistical analysis curriculum.

2 Fundamental Classroom Live Web Classroom e-Learning
Data Preparation for Data Mining
This course introduces programming techniques used by analysts to transform raw data into a form suitable for predictive modeling. This course uses SAS programming extensively.

4 Expert Classroom
SAS Programming 1 e-Lectures: Additional Topics
This SAS e-Lecture series bundles three lectures that build upon the skills that you developed in SAS Programming 1: Essentials. The three lectures included in the bundle are
  • Using Mixed Processing Methods to Read Raw Data Files
  • Batch Processing Using SAS under z/OS
  • Understanding the ExcelXP Tagset.

2 Fundamental e-Learning
SAS SQL 1 e-Lectures: Additional Topics
This SAS e-Lecture series bundles four lectures that build upon the skills that you developed in the SAS SQL 1: Essentials course. The four lectures included in the bundle are
  • Indexing SAS Data Sets for WHERE Optimization 1: Index Qualification and Data Profiling
  • Indexing SAS Data Sets for WHERE Optimization 2: Index Application and Performance
  • Beyond SQL Essentials: The Need for Speed when Accessing SAS Data
  • Beyond SQL Essentials: The Need for Speed when Accessing RDBMS Data.

3 Intermediate e-Learning
SAS Programming 2 e-Lectures: Additional Topics
This SAS e-Lecture series bundles three lectures that build on the skills that you developed in the SAS Programming 2: Data Manipulation Techniques course. The three lectures included in the bundle are
  • Creating Raw Data Files Using SAS
  • Using the OVER Options in the INFILE and FILE Statements
  • The FORMAT Procedure: Creating Custom Informats and Date Formats and Other Special Techniques.

3 Intermediate e-Learning
SAS Programming 3 e-Lectures: Additional Topics
This SAS e-Lecture series bundles four lectures that build upon the skills that you developed in the SAS Programming 3: Advanced Techniques and Efficiencies course. The four lectures included in the bundle are
  • Creating and Using Audit Trails
  • Getting Started with the MODIFY Statement
  • Creating User-Defined Functions
  • Creating Integrity Constraints.

4 Expert e-Learning
SAS Macro 1 e-Lectures: Additional Topics
This SAS e-Lecture series bundles three lectures that build upon the skills developed in the SAS Macro Language 1: Essentials course. The three lectures included in the bundle are
  • The Ins and Outs of Macro Quoting Functions
  • Executing SAS Functions with the SYSFUNC Macro Function
  • Understanding Multiple Ampersands in the SAS Macro Language.

4 Expert e-Learning
SAS Report Writing 1: Essentials
This course teaches you how to create detailed tabular, summary, and listing reports. You also learn how to send report output to the major Output Delivery System (ODS) destinations.

3 Intermediate Classroom Live Web Classroom
SAS Report Writing 1 e-Lectures: Additional Topics
This SAS e-Lecture series bundles three lectures that build upon the skills developed in the SAS Report Writing 1: Essentials course. The three lectures included in the bundle are
  • Creating DATA Step Reports with the LISTING Destination
  • Creating DATA Step Reports with the Output Delivery System
  • Creating Output Data Sets with the FREQUENCY and MEANS Procedures.

3 Intermediate e-Learning
SAS Macro Language 2: Advanced Techniques
This course covers macro quoting functions, macro storage, and macro techniques for advanced data access, table lookup operations, advanced parameter validation, and macro windows.

4 Expert Classroom Live Web Classroom e-Learning
The Power of CALL EXECUTE
This e-lecture shows how to use a powerful macro tool: CALL EXECUTE. The lecture reviews the basics of CALL EXECUTE and discusses some of the reasons to use it, as well as demonstrates situations when it isn't appropriate and why.

4 Expert e-Learning
SAS Programming Introduction: Basic Concepts
This course teaches you how to write simple SAS programs. The course is a subset of the SAS Programming 1: Essentials course. If you do not plan to write SAS programs and prefer a point-and-click interface to SAS, you should attend the SAS Enterprise Guide 1: Querying and Reporting course.

1 Beginner Classroom Live Web Classroom
Administrative Healthcare Data and SAS Business Knowledge Series
This industry-specific course focuses on the payer side of the industry: the origin, content, management, and use of administrative healthcare data. Students will become acquainted with the providers, payers, and users of the U.S. healthcare system. This course is not a hands-on programming course, but rather, it explores the business of medical claims data, health plan members, and service providers. As a supplement to this course, programmers should consider also registering for Administrative Healthcare Data and SAS : Hands-On Programming Workshop, a one-day course that focuses on programming methods and techniques that are useful in the healthcare industry. The two courses are offered on contiguous days.

2 Fundamental Classroom
SAS Functions by Example Business Knowledge Series
Ever spent valuable time writing complex code only to later find a function that would have done the job for you? Discover the plethora of practical SAS functions that you haven't seen in other SAS programming courses, and start resolving your everyday programming problems more quickly and efficiently.

3 Intermediate Classroom
Data Cleaning Techniques Business Knowledge Series
This course teaches you how to detect errors in raw data source files as well as showing you how to identify and correct errors in character and numeric SAS data. You will learn a variety of techniques for detecting problems with more complex data structures, such as data sets requiring multiple observations per subject, or requiring entries for a single subject across multiple data sets. More than simply teaching techniques for detecting and fixing data errors, this is also an excellent SAS programming course. Novice and veteran SAS programmers alike will garner new and valuable programming tips and tricks.

Knowledge of the SAS macro language is not a prerequisite, but you will learn to run macros that perform a variety of data cleaning functions. As an example, the AUTO_OUTLIERS macro automatically reports on outliers in numeric data using a concept called "trimmed statistics."

The class closes with a demonstration of an innovative process that leverages integrity constraints and audit trails to detect and programmatically clean dirty data before it even gets into your analysis data set. After class, you'll have access to every program and macro used during class, as well as a personal copy of Cody's Data Cleaning Techniques, Second Edition.

3 Intermediate Classroom Live Web Classroom
Exporting SAS Data Sets and Creating ODS Files for Microsoft Excel
This course presents the most effective techniques for exporting SAS tables or procedure output from Base SAS into Excel spreadsheets. The course uses examples to show the basics of the SAS Excel LIBNAME engine, the EXPORT procedure, and ODS to create CSV, HTML, and XML files that can be opened by Excel.

3 Intermediate Classroom Live Web Classroom
SAS Certification Review: Base Programming for SAS 9
This course provides a review of the majority of topics in the SAS Base Programming Exam for SAS 9. It addresses the five exam content areas: Accessing Data, Creating Data Structures, Managing Data, Generating Reports, and Handling Errors.

3 Intermediate Classroom Live Web Classroom
Building and Solving Optimization Models with SAS/OR
This course focuses on formulating and solving mathematical optimization models using the OPTMODEL procedure, from inputting data to interpreting output and generating reports. The course covers linear, integer, mixed integer, and nonlinear programming problems, with an emphasis on model formulation and construction.

3 Intermediate Classroom Live Web Classroom
Building and Solving Optimization Models with SAS/OR
This course focuses on formulating and solving mathematical optimization models using the OPTMODEL procedure, from inputting data to interpreting output and generating reports. The course covers linear, integer, mixed integer, and nonlinear programming problems, with an emphasis on model formulation and construction.

3 Intermediate Classroom Live Web Classroom
Introduction to Statistical Concepts Free
This course covers basic statistical concepts that are critical for understanding and using statistical methods. This course explains what statistics is and why it is important to understand the characteristics of your data.

The information in this course is a prerequisite for many other statistical courses SAS Education offers. The course is appropriate for Base SAS and SAS Enterprise Guide users. Data, practices, and a Case Study are included.

1 Beginner e-Learning
Administrative Healthcare Data and SAS : Hands-On Programming Workshop Business Knowledge Series
This hands-on workshop is open to SAS programmers who attended the Administrative Healthcare Data and SAS course. This workshop explores programming methods and techniques that are useful in the management of administrative healthcare data.

2 Fundamental Classroom
Creating Reports and Graphs with SAS Enterprise Guide
This course is intended for experienced SAS Enterprise Guide users who want to create customized reports and graphs. You learn how to use point-and-click tasks and wizards in SAS Enterprise Guide to generate detail and summary reports. You also learn how to enhance reports by using task options and modifying the generated SAS code. In addition, the course illustrates how to create and customize bar charts, map charts, histograms, box plots, scatter plots, line plots, and bar-line charts using SAS Enterprise Guide tasks and wizards.

2 Fundamental Classroom Live Web Classroom e-Learning
Introduction to SAS and Hadoop
This course teaches you how to use SAS programming methods to read, write, and manipulate Hadoop data. Base SAS methods that are covered include reading and writing raw data with the DATA step and managing the Hadoop file system and executing Map-Reduce and Pig code from SAS via the HADOOP procedure. In addition, the SAS/ACCESS Interface to Hadoop methods that allow LIBNAME access and SQL pass-through techniques to read and write Hadoop HIVE or Cloudera Impala tables structures is part of this course. Although not covered in any detail, a brief overview of additional SAS and Hadoop technologies, including DS2, high-performance analytics, SAS LASR Server, and in- memory Statistics, as well as the computing infrastructure and data access methods that support these, is also part of this course. This course is included in the Expert Exchange on Hadoop: Using SAS/ACCESS service offering to configure SAS/ACCESS Interface to Hadoop or SAS/ACCESS Interface to Impala to work with your Hadoop environment.

3 Intermediate Classroom
Introduction to SAS/ACCESS Interface to Teradata
This course teaches you how to read Teradata tables in Teradata using SAS 9.4 SAS/ACCESS Interface to Teradata. You learn how to connect to Teradata, query a single Teradata table and mulitple Teradata tables, and you also learn efficiency techniques and options for optimizing data access performance.

3 Intermediate Classroom
Propensity Score Matching, Adjustment, and Randomized Experiments Business Knowledge Series
This course focuses on testing whether the results of a program can be attributed to a given cause. For example, was the increase in customer sales due to mailing of sales flyers? Was the health improvement due to the new medication? What conclusion can be drawn? The following cases are examined: randomized controlled experiments and observational studies that require adjustment to reduce bias by using propensity score analysis through either propensity score matching or propensity score adjustment.

3 Intermediate Classroom
SAS High-Performance Markdown Optimization 4.3 Analytics and Modeling
This course is for those responsible for demand modeling within a retail organization in which SAS High-Performance Markdown Optimization 4.3 has been implemented.

3 Intermediate Classroom
ODS Graphics: Essentials
This course teaches you how to produce high-quality presentation graphics using ODS Graphics, which is a part of Base SAS beginning with SAS 9.3.

3 Intermediate Classroom Live Web Classroom
Using Perl Regular Expressions in SAS with the PRX Functions
This lecture addresses how to use Perl regular expressions and the PRX functions to subset and modify data in a SAS program. The following topics are addressed: writing and compiling regular expressions, using regular expressions to define a pattern for subsetting data, and using regular expressions to locate and modify data values.

3 Intermediate e-Learning
Modernizing Your SAS Code e-Lectures: Intermediate Topics
This SAS e-Lecture series bundles four lectures based on the overall theme of modernizing SAS code by exploiting recent enhancements and overlooked features in Base SAS software. The four lectures included in the bundle are
  • Modernizing Your SAS Code: Base SAS Procedure Techniques
  • Modernizing Your SAS Code: Referencing Variables and Data Sets
  • Modernizing Your SAS Code: Defining and Applying Formats
  • Modernizing Your SAS Code: Manipulating Data Using Functions.

3 Intermediate e-Learning
Developing Custom Tasks for SAS Enterprise Guide New Business Knowledge Series
SAS Enterprise Guide is a hugely popular application that is used by SAS programmers, SAS power users, and business analysts around the world. It does a lot, but does it do everything that you need it to do? Organizations often have a need to extend or customize their SAS Enterprise Guide environment to fit their particular industry or business processes.

4 Expert Classroom
DS2 Programming: Essentials
This course focuses on DS2, which is a fourth-generation SAS proprietary language for advanced data manipulation. DS2 enables parallel processing and storage of large data with re-usable methods and packages. This course is designed for programmers with large data who want to use modern programming techniques and structures.

4 Expert Classroom Live Web Classroom
DS2 Programming Essentials with Hadoop New
This course focuses on DS2, which is a fourth-generation SAS proprietary language for advanced data manipulation. DS2 enables parallel processing and storage of large data with reusable methods and packages. This course is designed for programmers with large data who want to use modern programming techniques and structures.

4 Expert Classroom Live Web Classroom
Producing Maps with SAS/GRAPH
This course teaches you to use SAS/GRAPH software to produce various types of maps to display geographically based data. In addition, you will learn how to add annotation to maps and create and modify map data sets.

4 Expert Classroom Live Web Classroom
Modernizing Your SAS Code e-Lectures: Advanced Topics
This SAS e-Lecture series bundles five advanced lectures based on the overall theme of modernizing SAS code by exploiting recent enhancements and overlooked features in Base SAS software and SAS/GRAPH software. The five lectures included in the bundle are
  • Modernizing Your SAS Code: External File Processing
  • Modernizing Your SAS Code: Techniques for Macro Applications
  • Modernizing Your SAS Code: Techniques for Macro Parameters
  • Modernizing Your SAS Code: Automating Programs Using SQL DICTIONARY Tables
  • Modernizing Your SAS Code: SAS/GRAPH Customization Techniques.

4 Expert e-Learning