Setup Menus in Admin Panel

Morbi sem erat, molestie ornare nisl mollis, tempor sodales mauris. Cras hendrerit, neque cursus ornare aliquam, massa massa posuere purus.

Welcome to DS2 Programming Essentials with Hadoop!

I’m Mark Jordan, and I’ve been a SAS programmer for over 22 years. I worked in heavy manufacturing and financial services before coming to SAS Institute. After 3 years working for SAS in Latin America, I moved into SAS Education as a Technical Training Consultant, where I’ve taught and authored a wide range of Foundation SAS programming courses, including this one. I wrote a book for SAS Press titled Mastering the SAS DS2 Procedure: Advanced Data Wrangling Techniques and I periodically contribute Jedi SAS Tricks to the SAS Learning Post blog.

This course focuses on DS2, a fourth-generation SAS proprietary language designed for advanced data manipulation in today’s big data environments. DS2 enables parallel processing at full precision with reusable methods and packages. And, with the SAS In-Database Code Accelerator, DS2 can execute directly on massively parallel processing platforms like Hadoop. With the traditional SAS DATA step, we bring the data to the code, but with DS2 we can bring the code to the data!

This course was written with the experienced SAS programmer in mind. If you have several months of SAS programming experience or have completed the SAS Programming 2: Data Manipulation Techniques course, and know how to write SQL joins, you should be quite comfortable in this class.

Let’s get started!

Course Curriculum

1.1a Chapter Overview
1.1a Chapter Overview 00:00:00
1.2a- What Is DS2
1.2a- What Is DS2 00:00:00
1.2b- Creating and Executing DS2 Programs
1.2b- Creating and Executing DS2 Programs 00:00:00
1.2c- When to Use DS2 Programs
1.2c- When to Use DS2 Programs 00:00:00
2.1a- Introduction
2.1a- Introduction 00:00:00
2.2a- DS2 Data Programs versus the SAS Data Step
2.2a- DS2 Data Programs versus the SAS Data Step 00:00:00
2.2b- Demo A DS2 'Hello World' Program
2.2b- Demo A DS2 ‘Hello World’ Program 00:00:00
2.2d- Basic DS2 Syntax
2.2d- Basic DS2 Syntax 00:00:00
2.2e- Methods
2.2e- Methods 00:00:00
2.2g- Declarative Statements
2.2g- Declarative Statements 00:00:00
2.2h- Variable Scope
2.2h- Variable Scope 00:00:00
2.3a- Converting to DS2
2.3a- Converting to DS2 00:00:00
2.3d- When to Choose DS2
2.3d- When to Choose DS2 00:00:00
3.1a- Chapter Overview
3.1a- Chapter Overview 00:00:00
3.2a- Similar, but Different
3.2a- Similar, but Different 00:00:00
3.2b- Demo Strict Variable Declaration
3.2b- Demo Strict Variable Declaration 00:00:00
3.2d- Working with ANSI Quotation Marks
3.2d- Working with ANSI Quotation Marks 00:00:00
3.2e- The 'Subtle Six'
3.2e- The ‘Subtle Six’ 00:00:00
3.3a- FedSQL Queries
3.3a- FedSQL Queries 00:00:00
3.3b- DS2 Arrays
3.3b- DS2 Arrays 00:00:00
3.3c- Additional Missing Statements and Their Equivalents
3.3c- Additional Missing Statements and Their Equivalents 00:00:00
3.3d- What DS2 Doesn't Do
3.3d- What DS2 Doesn’t Do 00:00:00
4.1a- Introduction
4.1a- Introduction 00:00:00
4.2a- PROC DS2 Global Statements
4.2a- PROC DS2 Global Statements 00:00:00
4.2b- Block Global Declaration Statements
4.2b- Block Global Declaration Statements 00:00:00
4.3a- DS2 Data Types
4.3a- DS2 Data Types 00:00:00
4.3b- Character Types
4.3b- Character Types 00:00:00
4.3c- Fractional Numeric Data Types
4.3c- Fractional Numeric Data Types 00:00:00
4.3d- Fractional Numeric Constants
4.3d- Fractional Numeric Constants 00:00:00
4.3g- Demo DS2 Data Type Conversions
4.3g- Demo DS2 Data Type Conversions 00:00:00
4.3h- Integer Numeric Data Types
4.3h- Integer Numeric Data Types 00:00:00
4.3j- Binary Data Types
4.3j- Binary Data Types 00:00:00
4.3k- Date and Time Data Types
4.3k- Date and Time Data Types 00:00:00
4.4a- Automatic Type Conversions
4.4a- Automatic Type Conversions 00:00:00
4.4c- DS2 Processing Modes
4.4c- DS2 Processing Modes 00:00:00
4.4e- Testing for Missing and Null Values
4.4e- Testing for Missing and Null Values 00:00:00
4.6e- Executing FedSQL Statements
4.6e- Executing FedSQL Statements 00:00:00
4.6f- Demo Executing FedSQL Statements with SQLEXEC
4.6f- Demo Executing FedSQL Statements with SQLEXEC 00:00:00
5.1a- Chapter Overview
5.1a- Chapter Overview 00:00:00
5.2a- User-Defined Methods
5.2a- User-Defined Methods 00:00:00
5.2c- Overloading Methods
5.2c- Overloading Methods 00:00:00
5.2d- Demo Overloaded Methods
5.2d- Demo Overloaded Methods 00:00:00
5.3a- DS2 Packages
5.3a- DS2 Packages 00:00:00
5.3b- DS2 User-Defined Packages
5.3b- DS2 User-Defined Packages 00:00:00
5.3d- Demo Creating and Using a User-Defined Package
5.3d- Demo Creating and Using a User-Defined Package 00:00:00
5.4a- Using the FCMP Package
5.4a- Using the FCMP Package 00:00:00
5.4b- Demo Using the FCMP Package
5.4b- Demo Using the FCMP Package 00:00:00
5.4c- Using the SQLSTMT Package
5.4c- Using the SQLSTMT Package 00:00:00
5.4d- SQLSTMT Package Details
5.4d- SQLSTMT Package Details 00:00:00
5.4e- Demo Using the SQLSTMT Package
5.4e- Demo Using the SQLSTMT Package 00:00:00
5.4f- Selected Additional Predefined Packages
5.4f- Selected Additional Predefined Packages 00:00:00
5.4g- Accessing Internet APIs
5.4g- Accessing Internet APIs 00:00:00
5.4h- Demo Using the HTTP and JSON Packages
5.4h- Demo Using the HTTP and JSON Packages 00:00:00
5.5a- Processing and Threading
5.5a- Processing and Threading 00:00:00
5.5b- Threading on the SAS Server
5.5b- Threading on the SAS Server 00:00:00
5.5c- Converting a DATA step to a Threaded DS2 DATA Program
5.5c- Converting a DATA step to a Threaded DS2 DATA Program 00:00:00
5.5d- Using DS2 Threads
5.5d- Using DS2 Threads 00:00:00
5.5e- Demo Executing DS2 Threads in Base SAS
5.5e- Demo Executing DS2 Threads in Base SAS 00:00:00
6.1a- Introduction
6.1a- Introduction 00:00:00
6.2a- Bringing Processing to the Data
6.2a- Bringing Processing to the Data 00:00:00
6.2b- Using the SAS In-Database Code Accelerator
6.2b- Using the SAS In-Database Code Accelerator 00:00:00
6.2c- Using the Code Accelerator for Hadoop
6.2c- Using the Code Accelerator for Hadoop 00:00:00
6.2d- Code Accelerator Execution Overview
6.2d- Code Accelerator Execution Overview 00:00:00
6.2e- Demo Running DS2 Code In-Database
6.2e- Demo Running DS2 Code In-Database 00:00:00
6.3a- Using PROC HPDS2
6.3a- Using PROC HPDS2 00:00:00
6.3b- Demo Running DS2 Code in PROC HPDS2
6.3b- Demo Running DS2 Code in PROC HPDS2 00:00:00
1.3a- What Is Hadoop
1.3a- What Is Hadoop 00:00:00
1.3b- Core Hadoop Modules
1.3b- Core Hadoop Modules 00:00:00
1.3c- HDFS Hadoop Distributed File System
1.3c- HDFS Hadoop Distributed File System 00:00:00
1.3d-MapReduce Distributed Processing
1.3d-MapReduce Distributed Processing 00:00:00
1.3e- Hadoop versus Traditional Databases
1.3e- Hadoop versus Traditional Databases 00:00:00
1.3f- The Hadoop Ecosystem
1.3f- The Hadoop Ecosystem 00:00:00
1.3g- How SAS Leverages Hadoop
1.3g- How SAS Leverages Hadoop 00:00:00
1.3h- Demo Starting and Setting Up the Virtual Lab
1.3h- Demo Starting and Setting Up the Virtual Lab 00:00:00
DS2 Programming Essentials with Hadoop- Course Overview
DS2 Programming Essentials with Hadoop- Course Overview 00:00:00
2.2i- Level 1- Declaring Variables in a DS2 DATA Program
2.2i- Level 1- Declaring Variables in a DS2 DATA Program 00:00:00
2.2i- Level 1 Solution- Declaring Variables in a DS2 DATA Program
2.2i- Level 1 Solution- Declaring Variables in a DS2 DATA Program 00:00:00
2.2i- Level 2- Reading a Data Set in a DS2 DATA Program
2.2i- Level 2- Reading a Data Set in a DS2 DATA Program 00:00:00
2.2i- Level 2 Solution- Reading a Data Set in a DS2 DATA Program
2.2i- Level 2 Solution- Reading a Data Set in a DS2 DATA Program 00:00:00
2.2i- Challenge- Controlling Variable Scope
2.2i- Challenge- Controlling Variable Scope 00:00:00
2.2i- Challenge Solution- Controlling Variable Scope
2.2i- Challenge Solution- Controlling Variable Scope 00:00:00
2.3e- Exercise- Level 1 Converting a DATA Step to a DS2 DATA Program
2.3e- Exercise- Level 1 Converting a DATA Step to a DS2 DATA Program 00:00:00
2.3e- Exercise Solution- Level 1 Converting a DATA Step to a DS2 DATA Program
2.3e- Exercise Solution- Level 1 Converting a DATA Step to a DS2 DATA Program 00:00:00
2.3e- Exercise- Level 2 Leveraging User-Defined Methods
2.3e- Exercise- Level 2 Leveraging User-Defined Methods 00:00:00
2.3e- Exercise- Challenge Converting a DATA Step Program to a DS2 DATA Program
2.3e- Exercise- Challenge Converting a DATA Step Program to a DS2 DATA Program 00:00:00
2.3e- Exercise Soln- Challenge Converting a DATA Step Program to a DS2 DATA Program
2.3e- Exercise Soln- Challenge Converting a DATA Step Program to a DS2 DATA Program 00:00:00
3.2f- Activity- Level 1 Reviewing an Undeclared Variable
3.2f- Activity- Level 1 Reviewing an Undeclared Variable 00:00:00
3.2f- Activity Answer- Level 1 Reviewing an Undeclared Variable
3.2f- Activity Answer- Level 1 Reviewing an Undeclared Variable 00:00:00
3.2f- Activity- Level 2 Modifying a Program to Include an Undeclared Variable
3.2f- Activity- Level 2 Modifying a Program to Include an Undeclared Variable 00:00:00
3.2f- Activity Answer Level 2 Modifying a Program to Include an Undeclared Variable
3.2f- Activity Answer Level 2 Modifying a Program to Include an Undeclared Variable 00:00:00
3.2f- Activity- Challenge Converting a DATA Step and Examining the Results
3.2f- Activity- Challenge Converting a DATA Step and Examining the Results 00:00:00
3.2f- Activity Answer- Challenge Converting a DATA Step and Examining the Results
3.2f- Activity Answer- Challenge Converting a DATA Step and Examining the Results 00:00:00
3.3f- Exercise- Level 1 Converting a DATA Step to a DS2 Data Program
3.3f- Exercise- Level 1 Converting a DATA Step to a DS2 Data Program 00:00:00
3.3f- Exercise Solution- Level 1 Converting a DATA Step to a DS2 Data Program
3.3f- Exercise Solution- Level 1 Converting a DATA Step to a DS2 Data Program 00:00:00
3.3f- Exercise- Level 2 Converting a DATA Step to a DS2 Data Program
3.3f- Exercise- Level 2 Converting a DATA Step to a DS2 Data Program 00:00:00
3.3f- Exercise Solution- Level 2 Converting a DATA Step to a DS2 Data Program
3.3f- Exercise Solution- Level 2 Converting a DATA Step to a DS2 Data Program 00:00:00
4.3m- Excercise
4.3m- Excercise 00:00:00
4.3m- Exercise Solution
4.3m- Exercise Solution 00:00:00
4.5h-Exercise- Level 1- Determining Variable Types
4.5h-Exercise- Level 1- Determining Variable Types 00:00:00
4.5h-Exercise Answer- Level 1- Determining Variable Types
4.5h-Exercise Answer- Level 1- Determining Variable Types 00:00:00
4.5h-Exercise- Level 2 Adding Variables to a New Data Set
4.5h-Exercise- Level 2 Adding Variables to a New Data Set 00:00:00
4.5h-Exercise ANswer- Level 2 Adding Variables to a New Data Set
4.5h-Exercise ANswer- Level 2 Adding Variables to a New Data Set 00:00:00
4.5h-Exercise- Challenge- Creating a New Data Set with Specific Variables in Uppercase
4.5h-Exercise- Challenge- Creating a New Data Set with Specific Variables in Uppercase 00:00:00
4.5h-Exercise Answer- Challenge- Creating a New Data Set with Specific Variables in Uppercase
4.5h-Exercise Answer- Challenge- Creating a New Data Set with Specific Variables in Uppercase 00:00:00
4.6g- Exercise- Level 1 Examining the Data Types
4.6g- Exercise- Level 1 Examining the Data Types 00:00:00
1.3i- Creating Course Data (required)
1.3i- Creating Course Data (required) 00:00:00
2.3e- Exercise Solution- Level 2 Leveraging User-Defined Methods
2.3e- Exercise Solution- Level 2 Leveraging User-Defined Methods 00:00:00
4.4b-New Data Types and Syntax Activity
4.4b-New Data Types and Syntax Activity 00:00:00
4.4f- Resolving MISSING and NULL in Expressions
4.4f- Resolving MISSING and NULL in Expressions 00:00:00
4.4g- Demo Processing Null and Missing Values
4.4g- Demo Processing Null and Missing Values 00:00:00
4.5a- Performing Conditional Processing
4.5a- Performing Conditional Processing 00:00:00
4.5b- Using DS2 IFTHEN-ELSE Statements
4.5b- Using DS2 IFTHEN-ELSE Statements 00:00:00
4.5c- Using the DS2 IF Expression
4.5c- Using the DS2 IF Expression 00:00:00
4.5d- Using the DS2 SELECT Expression
4.5d- Using the DS2 SELECT Expression 00:00:00
4.5e- Demo Division by Zero Errors in DS2
4.5e- Demo Division by Zero Errors in DS2 00:00:00
4.5f- Question
4.5f- Question 00:00:00
4.5g- Subsetting Data Based on Text Patterns
4.5g- Subsetting Data Based on Text Patterns 00:00:00
4.6a-Converting Values between DS2 and Base SAS
4.6a-Converting Values between DS2 and Base SAS 00:00:00
4.6b- Selected Functions
4.6b- Selected Functions 00:00:00
4.6c- Demo Storing Date, Time, and Timestamp Data in Hadoop
4.6c- Demo Storing Date, Time, and Timestamp Data in Hadoop 00:00:00
4.6d- Incrementing Expressions
4.6d- Incrementing Expressions 00:00:00
4.6g- Exercise SOlution- Level 1 Examining the Data Types
4.6g- Exercise SOlution- Level 1 Examining the Data Types 00:00:00
4.6g- Exercise- Level 2 Modifying a Program to Apply Specific Conditions
4.6g- Exercise- Level 2 Modifying a Program to Apply Specific Conditions 00:00:00
4.6g- Exercise Solution- Level 2 Modifying a Program to Apply Specific Conditions
4.6g- Exercise Solution- Level 2 Modifying a Program to Apply Specific Conditions 00:00:00
4.6g- Exercise- Challenge- Adding DATA Program Code to Create Results Base on Conditions
4.6g- Exercise- Challenge- Adding DATA Program Code to Create Results Base on Conditions 00:00:00
4.6g- Exercise Solution- Challenge- Adding DATA Program Code to Create Results Base on Conditions
4.6g- Exercise Solution- Challenge- Adding DATA Program Code to Create Results Base on Conditions 00:00:00
4.7a - Quiz
4.7a – Quiz 00:00:00
4.7a - Quiz Answer
4.7a – Quiz Answer 00:00:00
5.2f- Exercise-Level 1 Creating the Gross Margin Percentage Report
5.2f- Exercise-Level 1 Creating the Gross Margin Percentage Report 00:00:00
5.2f- Exercise Solution-Level 1 Creating the Gross Margin Percentage Report
5.2f- Exercise Solution-Level 1 Creating the Gross Margin Percentage Report 00:00:00
5.2f-Exercise- Level 2 Creating a Report with the Watch List Sales Items
5.2f-Exercise- Level 2 Creating a Report with the Watch List Sales Items 00:00:00
5.2f-Exercise SOlution- Level 2 Creating a Report with the Watch List Sales Items
5.2f-Exercise SOlution- Level 2 Creating a Report with the Watch List Sales Items 00:00:00
5.2f- Exercise- Challenge Creating a Marketing Model
5.2f- Exercise- Challenge Creating a Marketing Model 00:00:00
5.2f- Exercise Solution- Challenge Creating a Marketing Model
5.2f- Exercise Solution- Challenge Creating a Marketing Model 00:00:00
5.3e- Exercise- Level 1 Modifying the Gross Margin Percentage Report
5.3e- Exercise- Level 1 Modifying the Gross Margin Percentage Report 00:00:00
5.3e- Exercise Solution- Level 1 Modifying the Gross Margin Percentage Report
5.3e- Exercise Solution- Level 1 Modifying the Gross Margin Percentage Report 00:00:00
5.3e- Exercise- Level 2 Modifying the Marginal Sales Items Reporting Process
5.3e- Exercise- Level 2 Modifying the Marginal Sales Items Reporting Process 00:00:00
5.3e- Exercise Solution- Level 2 Modifying the Marginal Sales Items Reporting Process
5.3e- Exercise Solution- Level 2 Modifying the Marginal Sales Items Reporting Process 00:00:00
5.4i- Exercise- Level 1 Updating a Column in a Report
5.4i- Exercise- Level 1 Updating a Column in a Report 00:00:00
5.4i- Exercise SOlution- Level 1 Updating a Column in a Report
5.4i- Exercise SOlution- Level 1 Updating a Column in a Report 00:00:00
5.4i- Exercise- Level 2 Updating Values in a Data Set
5.4i- Exercise- Level 2 Updating Values in a Data Set 00:00:00
5.4i- Exercise SOlution- Level 2 Updating Values in a Data Set
5.4i- Exercise SOlution- Level 2 Updating Values in a Data Set 00:00:00
5.5f- Exercise- Level 1 Modifying a Report to Leverage DS2 Threads
5.5f- Exercise- Level 1 Modifying a Report to Leverage DS2 Threads 00:00:00
5.5f- Exercise SOlution- Level 1 Modifying a Report to Leverage DS2 Threads
5.5f- Exercise SOlution- Level 1 Modifying a Report to Leverage DS2 Threads 00:00:00
5.5f- Exercise- Level 2 Modifying a Report Process to Use DS2 Threads
5.5f- Exercise- Level 2 Modifying a Report Process to Use DS2 Threads 00:00:00
5.5f- Exercise SOlution- Level 2 Modifying a Report Process to Use DS2 Threads
5.5f- Exercise SOlution- Level 2 Modifying a Report Process to Use DS2 Threads 00:00:00
5.6a- Quiz
5.6a- Quiz 00:00:00
5.6a- Quiz Answer
5.6a- Quiz Answer 00:00:00
6.2g- Exercise- Level 1 Executing DS2 Code In-Database
6.2g- Exercise- Level 1 Executing DS2 Code In-Database 00:00:00
6.2g- Exercise SOlution- Level 1 Executing DS2 Code In-Database
6.2g- Exercise SOlution- Level 1 Executing DS2 Code In-Database 00:00:00
6.2g- Exercise- Level 2 Executing DS2 Code In-Database
6.2g- Exercise- Level 2 Executing DS2 Code In-Database 00:00:00
6.2g- Exercise Solution- Level 2 Executing DS2 Code In-Database
6.2g- Exercise Solution- Level 2 Executing DS2 Code In-Database 00:00:00
6.3c- Exercise- Level 1 Using DS2 Code in PROC HPDS2
6.3c- Exercise- Level 1 Using DS2 Code in PROC HPDS2 00:00:00
6.3c- Exercise Solution- Level 1 Using DS2 Code in PROC HPDS2
6.3c- Exercise Solution- Level 1 Using DS2 Code in PROC HPDS2 00:00:00
6.3c- Exercise Solution- Level 2 Converting the PROC DS2 Step into a PROC HPDS2 Step
6.3c- Exercise Solution- Level 2 Converting the PROC DS2 Step into a PROC HPDS2 Step 00:00:00
6.3c- Exercise- Level 2 Converting the PROC DS2 Step into a PROC HPDS2 Step
6.3c- Exercise- Level 2 Converting the PROC DS2 Step into a PROC HPDS2 Step 00:00:00
6.4a- Quiz
6.4a- Quiz 00:00:00
6.4a- Quiz Answer
6.4a- Quiz Answer 00:00:00
Self-Study- Tracing and Debugging File
Self-Study- Tracing and Debugging File 00:00:00
Course Notes- DS2 Programming- Essentials with Hadoop File
Course Notes- DS2 Programming- Essentials with Hadoop File 00:00:00
4.3e- Activity
4.3e- Activity 00:00:00
4.3f- Activity
4.3f- Activity 00:00:00
4.3l Activity
4.3l Activity 00:00:00

Course Reviews

4.3

4.3
4 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • £20.00
  • 3 months
  • Course Badge
  • Course Certificate
39 STUDENTS ENROLLED
    Copyright @2019