Advanced SAS Course by Solving Questions and Use Cases
4.3 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
159 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Advanced SAS Course by Solving Questions and Use Cases to your Wishlist.

Add to Wishlist

Advanced SAS Course by Solving Questions and Use Cases

Comprehensive and advanced SAS course: learning knowledge and skills, solving questions and passing exams
4.3 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
159 students enrolled
Created by Datagist INC
Last updated 6/2017
English
Current price: $10 Original price: $40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 11 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Advanced SAS programming, especially in SQL and SAS Macro. Students will be able to become advanced SAS programmers
  • Acquire SAS knowledge and skills to pass certificate exam
  • Get rich study materials in learning and practicing
  • Master efficient SAS programming to solve real world problems
  • Perform data analysis, data automation using advanced SAS
View Curriculum
Requirements
  • Basic computer skills
  • Know little programming knowledge
Description

If you need a comprehensive SAS  course that helps you

1) pass advanced SAS certificate exam;

2) master advanced SAS programming by solving 100 questions including study cases;

3) understand how SAS codes Macro and SQL are working;

4) walk through questions by testing programming codes;

5) practice and review SAS examples by yourself using my handout; 

Then this course is right for you. I am using a special but effective teaching method in this course. You are not just leaning SAS knowledge and skills, but also examining yourself by solving each question! You are not just seeking the correct solution, but also figuring out why other answers are incorrect.

I will show you both theories in slides and code implementation in programming interface. With the questions, multiple choices, code interpretation, examples and data sets I provided, you will be able to start SAS programming efficiently and confidently pass certificate exam! 

Who is the target audience?
  • People wish to learn advanced SAS programming and pass exam
  • People wish to find job in business and data analytics
  • Anyone who performs data analysis using SAS Macro and SQL
  • Anyone who likes to learn while solving questions
Students Who Viewed This Course Also Viewed
Curriculum For This Course
102 Lectures
10:55:23
+
Course Introduction
1 Lecture 04:27

You will learn  1) Why This Course  2) Course coverage 3) How to use this course

Preview 04:27
+
Introduce video and downloadable files
1 Lecture 00:56
How to use the course materials
00:56
+
Walk through each question and case by explanation
100 Lectures 10:50:00

In this question I will introduce the concept of SAS Macro, variable and how to write Macro function by an example. The testing code is also provided to review the question.

Learn first SAS Macro function and variable
12:48

Understand Macro evaluation function and usages
05:52

Understand Macro evaluation function and usages (Cont.)
03:48

Understand %scan function and application
05:39

Learn %index(), %scan() and SAS Macro programming
07:10

Length statement in data step programming and usages
04:41

Learn how to join tables using SAS SQL
12:22

Learn how to transfer parameters to SAS Macro functions
10:37

Learn application by combining SAS SQL and Macro functions
08:43

Understand ways for Resolving Macro variables
12:38

Macro Do Loop and output
05:35

Proc SQL and aggregation functions
07:01

Alter names of data sets and proc datasets
03:53

Proc SQL, aggregation function and subquery
06:46

BUFSIZE and BUFNO options in data steps
04:07

A practical and typical examples of SAS SQL (a)
13:07

A practical and typical examples of SAS SQL (b)
07:42


Automatic SAS Macro variables and usages (Cont.)
06:50

SAS SQL to join tables
05:34

SAS SQL product join
02:05

Data step function and format
07:07

SAS internal macro function and application
06:44

SAS internal macro function and application (Cont.)
04:34

SAS internal macro function and application (Cont.)
03:25


Create index for SAS data set
05:26

Create SAS macro function to export data
04:52

Introduce REUSE option
01:31

Understand %eval Macro function and %do loop
03:52

Learn SAS PROC SQL and output
04:31

Learn how to resolve multiple Macro variables
09:01

Learn how to debug SAS Macro programs
03:40

A comprehensive example of SAS macro program
08:02

Learn case statement in PROC SQL
08:49

Understand function of of index in SAS data sets
02:15

Learn how to create index for SAS data sets
03:12

Using SQL to generate index of SAS tables
06:54

Learn how rename can change index in data step
03:35

Understand label and format options in PROC SQL
09:28

Learn SQL functions in SAS PROC SQL
06:54

Query by passing Macro variable into SQL
07:41

Query missing values using PROC SQL
05:22

Learn a SAS Macro function using SAS SQL
08:33

Learn how to use symput() and Macro %sysevalf() functions
09:03

Methods to remove duplicates from SAS data sets
13:08

Learn group by, having statements and aggregation functions in SAS SQL
05:58

Learn sub query used in where statement in PROC SQL
05:37

Learn SQL sub query and table joining
10:58

Learn PROC SQL from a complex example
08:55

Learn how to union data sets using SAS SQL (1)
05:35

Learn how to union data sets using SAS SQL (2)
02:58

Learn how to union data sets using SAS SQL (3)
01:11

Learn how to intersect data sets using SAS SQL (1)
05:49

Learn how to intersect data sets using SAS SQL (2)
03:31

Learn filename statement
06:04

Learn methods to concatenates data in SAS
12:04

Insert record into SAS data set
05:55

Modify data sets using PROC SQL
05:09

Learn how to pass and resolve string-like Macro variables
05:34

Create tables using SQL and left join using PROC SQL
08:00

Using symput function to send data step variable into Macro variable
08:42

Explain a Macro function
07:35

Write a SAS macro program to print the contents of three data sets
07:17

Write a SAS macro function to keep specific variables in a data set
11:03

Learn a SAS macro function to print the contents of three data sets
10:05

Learn how to use SAS automatic Macro variable in Macro function
06:34

How to find SAS version and components list
03:48

Execute Macro program by sending masked parameters
10:27

Passing where statement into SQL by SAS Macro
12:38

Learn how to use PROC SQL options correctly
04:21

Learn how to return record number using SAS SQL
04:25

Understand the function of the key word 'validate' in SQL
02:35

Learn special SAS library
04:34

Understand index name and usages in data steps
06:19

Remove tables from library using SAS SQL
01:46

Display the data structure of a SAS data set in a library
01:37

Save the value of a variable at specific record into a macro variable
10:05

Learn how to use the STRIP function in SAS
08:16

Learn how to use the STRIP function in SAS (Cont.)
02:48

Create indexes on a SAS data set for efficient processing
02:07

Learn cross joining tables in SAS SQL
06:36

Learn how to create non-duplicated pair observations using SAS SQL
05:05

Using SAS Macro program and SQL to generate various table merging
08:06

Learn how to calculate summary statistics using SAS SQL
05:16

Learn how to calculate summary statistics using SAS SQL (Cont.)
09:37

Learn how to calculate summary statistics using SAS SQL (Cont.)
09:11

Understand SQL Syntax in SAS PROC SQL
04:05

Generate automatic report using PROC SQL
05:27

Set bufno to use the most amount of memory resources for output buffers
03:08

Use proc sql options to eliminate identical observations
02:32

Use Macro function to create a data set by keeping numeric variables
07:10

Create a new data set by calculating average amount for each item group
08:06

Explain a type PROC SQL example with calculated expression
08:32

Use PROC SQL to return the successive integers (1,2,3,…) in data set
05:41

Explain LIKE 'J%' in the where statement in SAS PROC SQL
06:10

Learn sound alike query in SAS PROC SQL
01:22

Macro variables containing the return code from previously executed step
00:49

Understand some where statements in SAS SQL
01:47

A comprehensive study case to finalize this course
18:01
About the Instructor
Datagist INC
4.4 Average rating
37 Reviews
314 Students
2 Courses
teacher

We are a group of data analytics experts involved in different industry fields -- finance, marketing, health, telecommunication and entertainment. We all have at least Master Degree of Science in computer science, mathematics and business. We all have very rich experience in education. 

Our goal is to educate persons who wish to learn various data analytics knowledge, skills and tools. We are always seeking innovative methods in delivering what we know.