Base SAS 9 Programming E-Learning

Order this unique E-Learning Base SAS 9 Programming course online!
✔️ 1 year 24/7 access to rich interactive videos, voice, progress monitoring through reports and chapter-by-chapter tests to instantly test your knowledge.

Why choose this course?

SAS is one of the most widely used systems for managing and analyzing data worldwide. Base SAS is at the heart of this powerful system and provides a versatile programming language for data analysis and reporting.

With this training you will learn:

Manipulate and manage data: Develop skills to clean, merge, and transform data with Base SAS.
Report Generation: Design and implement structured reports for data analysis and presentation.
Build programming experience: Write well-formed programs in Base SAS 9 and understand the underlying logic.
Preparing for Certification: Cover all objectives of the SAS Certified Base Programmer for SAS 9 exam so you can confidently participate.

This course offers an excellent balance between theory and practice, allowing you to test your skills and apply them to realistic scenarios.

Who should participate?

This training is suitable for:

Data analysts who want to delve into data management and statistical analysis.
IT professionals who want to expand their knowledge with Base SAS programming for data projects.
Novice programmers who want to start with a versatile programming language for data analysis.
Aspiring SAS certifiers who want to prepare for the SAS Certified Base Programmer for SAS 9 exam.

Course content

SAS Overview

Course: 27 Minutes

Course Introduction
SAS Overview
SAS Environments
Obtaining and Installing a SAS environment
SAS Interfaces
Introducing SAS Programs
Submitting a Program

SAS Studio

Course: 52 Minutes

SAS Studio Overview
SAS Studio Interface Elements
SAS Studio Navigation Pane
SAS Studio Code Tab
SAS Studio Log Tab
SAS Studio Results Tab
SAS Studio Autocomplete
Working with Tasks
Working with Libraries

Practice: SAS Basics

Course: 3 Minutes

Exercise: Running an SAS Program

SAS Data Sets

Course: 25 Minutes

Course Introduction
Data Set Descriptors
Printing a Data Set
Data Library Overview
Using Data Libraries
Assigning a Libref to a Relational Database
Connecting to a Relational Database Source

Reading Data Sets

Course: 29 Minutes

SAS Data Sources
Using the DATA Statement to Create a Data Step
Using the SET Statement for Data Step Processing
Using the WHERE Statement to Subset Observations
Using the DROP and KEEP Statements
Adding Labels Using the LABEL Statement
Adding Formats Using the FORMAT Statement

Reading from Excel

Course: 23 Minutes

Creating a Data Set from an Excel Sheet
Reading from an Excel Sheet
Using the PROC Step to Create an Excel Sheet
Using the ODS to Create an Excel Sheet
Using the IMPORT Wizard with Excel
Using the EXPORT Wizard with Excel

Reading Text Files

Course: 34 Minutes

Creating a Data Set from a Delimited File
Using the LENGTH Statement
Reading Nonstandard Data with Informats
Processing Nonstandard Data in the DATA Step
Using the List Input DSD Option
Using the MISSOVER Option

Practice: Work with Data

Course: 9 Minutes

Exercise: Reading Data

Data Errors

Course: 18 Minutes

Course Introduction
Data Errors in Raw Data
Validating and Cleaning Data
Examining Data Errors
Handling Data Errors

Data Validation and Cleaning

Course: 24 Minutes

Validating Data Using PRINT and WHERE
Validating Data Using FREQ and TABLES
Validating Data Using MEANS and VAR
Validating Data Using UNIVARIATE and VAR
Cleaning Data At the Source
Cleaning Data Using Assignment Statements
Cleaning Data Using Conditionals in the DATA Step

Data Manipulation

Course: 22 Minutes

Creating Variables with DATA Step Assignments
Creating Values Using Operators and SAS Functions
Executing Statements Conditionally
Using the ELSE Statement in a Conditional
Using IF and WHERE to Subset Observations
Using IF-THEN DELETE to Subset Observations

Combining Data Sets

Course: 34 Minutes

Combining SAS Data Sets
Using APPEND to Combine Data Sets
Using the FORCE Option to an APPEND Procedure
Using SET in a DATA Step to Concatenate Data Sets
Using RENAME to Change Variable Names
Merging Data Sets One-To-One
Merging Data Sets One-To-Many
Merging Data Sets with Nonmatches

Practice: Validate, Clean, and Combine Data

Course: 9 Minutes

Exercise: Validating, Cleaning, and Combining Data

Reports

Course: 40 Minutes

Course Introduction
Producing a Basic Report
Producing an Enhanced Report in SAS
Using the LABEL Statement to Add Column Headings
Formatting Values Using the FORMAT Statement
Creating and Applying User-defined Formats
Subsetting and Grouping Reports Using WHERE and BY
Directing Output Using ODS Statements
Specifying Styles in an ODS Statement

Summary Reports

Course: 28 Minutes

Creating Frequency Tables with the FREQ Procedure
Creating Enhanced Frequency Tables
Creating Summary Tables with the MEANS Procedure
Creating Summary Tables with the SUMMARY Procedure
Creating Enhanced Summary Tables
Creating Tabular Reports with the TABULATE Procedure
Creating Output Data Sets Using the OUT= Option

Graphics

Course: 21 Minutes

Overview of SAS/GRAPH SG Procedures
Creating Pie Charts with SAS/GRAPH SG Procedures
Creating Bar Charts with SAS/GRAPH SG Procedures
Creating Histograms with SAS/GRAPH SG Procedures
Producing Scatter Plots with SAS/GRAPH SG Procedures

Practice: Reports and Charts

Course: 4 Minutes

Exercise: Creating Reports and Charts

Input and Output

Course: 24 Minutes

Course Introduction
Outputting Multiple Observations
Writing to Multiple SAS Data Sets
Controlling Variable Input and Output
Controlling Observation Input and Output

Data Summarization

Course: 16 Minutes

Creating an Accumulating Variable Using RETAIN
Creating an Accumulating Variable Using SUM
Summarizing Data by Groups
Summarizing Data by Multiple Groups

Read Raw Data

Course: 26 Minutes

Using Column Input
Using Formatted Input
Creating a Single Observation from Multiple Records
Controlling When a Record Loads
Reading Raw Data with Missing Values

Data Transformation

Course: 45 Minutes

Using SAS Functions
Extracting and Transforming Character Values
Separating and Concatenating Character Values
Finding and Modifying Character Values
Using Descriptive Statistics Functions
Truncating Numeric Values
Converting Values Between Data Types

Debugging

Course: 10 Minutes

Debugging with PUTLOG
Debugging Logic Errors

Practice: Data Manipulation

Course: 5 Minutes

Exercise: Manipulating Data

Iterative DO Loops

Course: 21 Minutes

Course Introduction
Creating a Simple DO Loop
DO WHILE Loops
DO UNTIL Loops
Nesting DO Loops
Using a DO Loop to Reduce Redundant Code

SAS Arrays

Course: 25 Minutes

SAS Array Overview
Creating a SAS Array
Processing a SAS Array
Using SAS Arrays to Create Variables
Using SAS Arrays to Perform Calculations
Assigning Initial Values to an Array

Restructuring and Combining Data Sets

Course: 29 Minutes

Using the TRANSPOSE Procedure to Manipulate Data
Rotating a Data Set with the TRANSPOSE
Match-Merging SAS Data Sets
Manipulations with a Match-Merge
Match-Merging Data Sets that Lack a Common Variable
Match-Merging a SAS Data Set and an Excel Workbook
Match-Merging Data Sets with Same-named Variables

Proc SQL

Course: 12 Minutes

Proc SQL Overview
Querying with Proc SQL
Joining Tables with Proc SQL

Practice: Array Processing & Merges

Course: 6 Minutes

Exercise: Processing an Array & Merging Data Sets

Get started with Base SAS 9 Programming!

✔️ Interactive learning tools: Rich videos and practical assignments help you get the most out of the course.
✔️ Progress monitoring: Test your knowledge per chapter and monitor your learning results.
✔️ Certificate of participation: Show your commitment and skills with a recognized certificate.

Order your course now and start your journey to expertise in Base SAS 9 Programming!

SAS Base SAS 9 Programming Training