Buy Now AED 170.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Getting Started with SAS Programming
  • Level Foundation
  • المدة 25 ساعات hours
  • الطبع بواسطة SAS
  • Offered by

عن

This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. It is a prerequisite to many other SAS courses. By the end of this course, you will know how to use SAS Studio to write and submit SAS programs that access SAS, Microsoft Excel, and text data. You will know how to explore and validate data, prepare data by subsetting rows and computing new columns, analyze and report on data, export data and results to other formats, use SQL in SAS to query and join tables. Prerequisites: Learners should have experience using computer software. Specifically, you should be able to understand file structures and system commands on your operating systems and access data files on your operating systems. No prior SAS experience is needed.

الوحدات

Course Overview and Logistics

    • 2 Videos
    • 2 Readings
Show info about module content

2 Videos

  • Welcome to the Course!
  • Demo: Programming in SAS

2 Readings

  • Learner Prerequisites
  • Using Forums and Getting Help

Access SAS Software and Set Up Data for the Course (REQUIRED)

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Practicing in This Course

1 Readings

  • Access SAS Software and Set Up Practice Files (REQUIRED)

Module Overview

    • 1 Videos
Show info about module content

1 Videos

  • Overview

Using SAS Programming Tools

    • 2 Videos
    • 1 Readings
Show info about module content

2 Videos

  • SAS Programming Interfaces
  • Demo: Programming with SAS Studio

1 Readings

  • Practice Using SAS Studio

Understanding SAS Syntax

    • 4 Videos
    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Activity 1.01
  • Activity 1.02

1 Discussions

  • Your turn - Are you new to programming?

4 Videos

  • SAS Program Structure
  • SAS Program Syntax
  • Demo: Understanding SAS Program Syntax
  • Demo: Finding and Resolving Syntax Errors

Review

    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Essentials Review

1 Readings

  • Syntax Review

Module Overview

    • 1 Videos
Show info about module content

1 Videos

  • Overview

Understanding SAS Data

    • 4 Videos
    • 3 Assignment
Show info about module content

3 Assignment

  • Question 2.01
  • Activity 2.02
  • Activity 2.03

4 Videos

  • Types of Data
  • What is a SAS Table?
  • Required Column Attributes for SAS Tables
  • Listing Table and Column Attributes

Accessing Data Through Libraries

    • 6 Videos
    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Activity 2.04: Create a Library for This Course (Required)
  • Activity 2.05

1 Discussions

  • Your turn - Do you understand SAS libraries?

6 Videos

  • Accessing Data in a Program
  • Using a Library to Read SAS Data
  • Automatic SAS Libraries
  • Demo: Exploring Automatic SAS Libraries
  • Using a Library to Read Other File Types
  • Demo: Using a Library to Read Excel Files

Importing Data into SAS

    • 3 Videos
    • 1 Discussion
    • 3 Assignment
Show info about module content

3 Assignment

  • Activity 2.06
  • Level 1 Practice: Importing Excel Data from a Single Worksheet
  • Level 2 Practice: Importing Data from a CSV File

1 Discussions

  • Your turn - What type of data do you have?

3 Videos

  • Importing Unstructured Data
  • Demo: Importing a Comma-Delimited (CSV) File
  • Importing an Excel File

Review

    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Accessing Data

1 Readings

  • Syntax Review

Module Overview

    • 1 Videos
Show info about module content

1 Videos

  • Overview

Exploring Data

    • 2 Videos
    • 3 Assignment
Show info about module content

3 Assignment

  • Activity 3.01
  • Level 1 Practice: Exploring Data with Procedures
  • Level 2 Practice: Using Procedures to Validate Data

2 Videos

  • Exploring Data with Procedures
  • Demo: Exploring Data with SAS Procedures

Filtering Rows

    • 6 Videos
    • 4 Assignment
Show info about module content

4 Assignment

  • Activity 3.02
  • Activity 3.03
  • Level 1 Practice: Filtering Rows in a Listing Report Using Character Data
  • Level 2 Practice: Using Macro Variables to Subset Data in Procedures

6 Videos

  • Filtering Rows with the WHERE Statement
  • Combining Expressions in a WHERE Statement
  • Demo: Filtering Rows with Basic Operators
  • Using Special WHERE Operators
  • Creating and Using Macro Variables
  • Demo: Filtering Rows Using Macro Variables

Formatting Columns

    • 4 Videos
    • 2 Assignment
Show info about module content

2 Assignment

  • Activity 3.04
  • Activity 3.05

4 Videos

  • Formatting Data Values in Results
  • Common Formats for Numeric Values
  • Common Formats for Date Values
  • Demo: Formatting Data Values in Results

Sorting Data and Removing Duplicates

    • 3 Videos
    • 3 Assignment
Show info about module content

3 Assignment

  • Activity 3.06
  • Level 1 Practice: Sorting Data and Creating an Output Table
  • Level 2 Practice: Sorting Data to Remove Duplicate Rows

3 Videos

  • Sorting Data
  • Identifying and Removing Duplicates
  • Demo: Identifying and Removing Duplicate Values

Review

    • 1 Readings
    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Exploring and Validating Data

1 Discussions

  • Your turn - What you learned in this module

1 Readings

  • Syntax Review

Module Overview

    • 1 Videos
Show info about module content

1 Videos

  • Overview

Reading and Filtering Data

    • 3 Videos
    • 5 Assignment
Show info about module content

5 Assignment

  • Question 4.01
  • Question 4.02
  • Activity 4.03
  • Level 1 Practice: Creating a SAS Table
  • Level 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table

3 Videos

  • Using the DATA Step to Create a SAS Data Set
  • DATA Step Processing
  • Demo: Working with the DATA Step

Computing New Columns

    • 4 Videos
    • 3 Readings
    • 1 Discussion
    • 5 Assignment
Show info about module content

5 Assignment

  • Activity 4.04
  • Activity 4.05
  • Activity 4.06
  • Level 1 Practice: Creating New Columns
  • Level 2 Practice: Creating New Columns with Character and Date Functions

1 Discussions

  • Your turn - Using Functions

4 Videos

  • Demo: Using Expressions to Create New Columns
  • Using Numeric Functions to Create Columns
  • Demo: Using Character Functions
  • Demo: Using Date Functions

3 Readings

  • Common Summary Functions for Creating Columns
  • Common Character Functions for Creating Columns
  • Common Date Functions for Creating Columns

Conditional Processing

    • 5 Videos
    • 5 Assignment
Show info about module content

5 Assignment

  • Activity 4.07
  • Activity 4.08
  • Activity 4.09
  • Level 1 Practice: Processing Statements with IF-THEN/ELSE
  • Level 2 Practice: Processing Statements Conditionally with DO Groups

5 Videos

  • Demo: Conditional Processing with IF-THEN
  • Conditional Processing with IF-THEN/ELSE
  • Creating Character Columns with the LENGTH Statement
  • Processing Multiple Statements with IF-THEN/DO
  • Demo: Processing Multiple Statements with IF-THEN/DO

Review

    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Preparing Data

1 Readings

  • Syntax Review

Module Overview

    • 1 Videos
Show info about module content

1 Videos

  • Overview

Enhancing Reports with Titles, Footnotes, and Labels

    • 6 Videos
    • 2 Assignment
Show info about module content

2 Assignment

  • Activity 5.01
  • Activity 5.03

6 Videos

  • Using Titles and Footnotes
  • Using Macro Variables and Functions in Titles and Footnotes
  • Applying Temporary Labels to Columns
  • Segmenting Reports
  • Demo: Enhancing Reports
  • Applying Permanent Labels to Columns

Creating Frequency Reports

    • 2 Videos
    • 3 Assignment
Show info about module content

3 Assignment

  • Activity 5.04
  • Level 1 Practice: Creating One-Way Frequency Reports
  • Level 2 Practice: Creating Two-Way Frequency Reports

2 Videos

  • Demo: Creating Frequency Reports and Graphs
  • Demo: Creating Two-Way Frequency Reports

Creating Summary Reports and Data

    • 2 Videos
    • 1 Readings
    • 4 Assignment
Show info about module content

4 Assignment

  • Activity 5.05
  • Activity 5.06
  • Level 1 Practice: Producing a Descriptive Statistics Report
  • Level 2 Practice: Creating an Output Table with Custom Columns

2 Videos

  • Demo: Creating a Summary Statistics Report
  • Creating an Output Summary Table

1 Readings

  • Examples of Procedures that Analyze Data

Review

    • 1 Readings
    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Analyzing and Reporting on Data

1 Discussions

  • Your turn - What analyses will you use?

1 Readings

  • Syntax Review

Module Overview

    • 1 Videos
Show info about module content

1 Videos

  • Overview

Exporting Data

    • 2 Videos
    • 1 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Activity 6.01
  • Activity 6.02

2 Videos

  • Exporting Data
  • Demo: Exporting Data to an Excel Workbook

1 Readings

  • Create a Macro Variable (REQUIRED)

Exporting Reports

    • 5 Videos
    • 1 Readings
    • 3 Assignment
Show info about module content

3 Assignment

  • Activity 6.03
  • Level 1 Practice: Creating an Excel File Using ODS EXCEL
  • Level 2 Practice: Creating a Document with ODS RTF

5 Videos

  • Using the SAS Output Delivery System
  • Exporting Results to CSV
  • Demo: Exporting Results to Excel
  • Exporting Results to PowerPoint and Microsoft Word
  • Demo: Exporting Results to PDF

1 Readings

  • Activity: Create PowerPoint and RTF Files

Review

    • 1 Readings
    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Exporting Results

1 Discussions

  • Your turn - Exporting Data and Results

1 Readings

  • Syntax Review

Module Overview

    • 1 Videos
    • 1 Discussion
Show info about module content

1 Discussions

  • Your turn - Do you have SQL experience?

1 Videos

  • Overview

Using Structured Query Language (SQL) in SAS

    • 5 Videos
    • 2 Assignment
Show info about module content

2 Assignment

  • Activity 7.01
  • Activity 7.02

5 Videos

  • SQL and SAS
  • PROC SQL Syntax
  • Filtering and Sorting Output
  • Demo: Reading and Filtering Data with SQL
  • Creating and Deleting Tables in SQL

Joining Tables Using SQL in SAS

    • 3 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Activity 7.03

3 Videos

  • Creating Inner Joins in SQL
  • Demo: Joining Tables with PROC SQL
  • Using Table Aliases

Review

    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Using SQL in SAS

1 Readings

  • Syntax Review

Course Wrap Up

    • 1 Videos
    • 1 Discussion
Show info about module content

1 Discussions

  • Your turn - Let Us Know!

1 Videos

  • You've Finished the Course!

Auto Summary

"Getting Started with SAS Programming" is a foundational course in Data Science & AI, ideal for beginners. Taught by Coursera, it covers writing SAS programs to access, explore, and analyze data, and is essential for further SAS studies. The course spans approximately 1500 minutes and offers Starter, Professional, and Paid subscription options. Perfect for those new to SAS, it requires basic computer skills but no prior SAS experience.

Stacey Syphus
Instructor

Stacey Syphus