Advanced SAS Course by Solving Questions and Use Cases

Name: Advanced SAS Course by Solving Questions and Use Cases
Rating: 4.2 (154 reviews)

Comprehensive and advanced SAS course: learning knowledge and skills, solving questions and passing exams

Created byDatagist INC

Last updated 6/2017

English

What you'll 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

Course content

3 sections • 102 lectures • 10h 55m total length

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

Learn first SAS Macro function and variable12:48
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.
Understand Macro evaluation function and usages5:52
Understand Macro evaluation function and usages (Cont.)3:48
Understand %scan function and application5:39
Learn %index(), %scan() and SAS Macro programming7:10
Length statement in data step programming and usages4:41
Learn how to join tables using SAS SQL12:22
Learn how to transfer parameters to SAS Macro functions10:37
Learn application by combining SAS SQL and Macro functions8:43
Understand ways for Resolving Macro variables12:38
Macro Do Loop and output5:35
Proc SQL and aggregation functions7:01
Alter names of data sets and proc datasets3:53
Proc SQL, aggregation function and subquery6:46
BUFSIZE and BUFNO options in data steps4:07
A practical and typical examples of SAS SQL (a)13:07
A practical and typical examples of SAS SQL (b)7:42
Automatic SAS Macro variables and usages8:22
Automatic SAS Macro variables and usages (Cont.)6:50
SAS SQL to join tables5:34
SAS SQL product join2:05
Data step function and format7:07
SAS internal macro function and application6:44
SAS internal macro function and application (Cont.)4:34
SAS internal macro function and application (Cont.)3:25
Extract data structures into Macro variables using Proc SQL10:00
Create index for SAS data set5:26
Create SAS macro function to export data4:52
Introduce REUSE option1:31
Understand %eval Macro function and %do loop3:52
Learn SAS PROC SQL and output4:31
Learn how to resolve multiple Macro variables9:01
Learn how to debug SAS Macro programs3:40
A comprehensive example of SAS macro program8:02
Learn case statement in PROC SQL8:49
Understand function of of index in SAS data sets2:15
Learn how to create index for SAS data sets3:12
Using SQL to generate index of SAS tables6:54
Learn how rename can change index in data step3:35
Understand label and format options in PROC SQL9:28
Learn SQL functions in SAS PROC SQL6:54
Query by passing Macro variable into SQL7:41
Query missing values using PROC SQL5:22
Learn a SAS Macro function using SAS SQL8:33
Learn how to use symput() and Macro %sysevalf() functions9:03
Methods to remove duplicates from SAS data sets13:08
Learn group by, having statements and aggregation functions in SAS SQL5:58
Learn sub query used in where statement in PROC SQL5:37
Learn SQL sub query and table joining10:58
Learn PROC SQL from a complex example8:55
Learn how to union data sets using SAS SQL (1)5:35
Learn how to union data sets using SAS SQL (2)2:58
Learn how to union data sets using SAS SQL (3)1:11
Learn how to intersect data sets using SAS SQL (1)5:49
Learn how to intersect data sets using SAS SQL (2)3:31
Learn filename statement6:04
Learn methods to concatenates data in SAS12:04
Insert record into SAS data set5:55
Modify data sets using PROC SQL5:09
Learn how to pass and resolve string-like Macro variables5:34
Create tables using SQL and left join using PROC SQL8:00
Using symput function to send data step variable into Macro variable8:42
Explain a Macro function7:35
Write a SAS macro program to print the contents of three data sets7:17
Write a SAS macro function to keep specific variables in a data set11:03
Learn a SAS macro function to print the contents of three data sets10:05
Learn how to use SAS automatic Macro variable in Macro function6:34
How to find SAS version and components list3:48
Execute Macro program by sending masked parameters10:27
Passing where statement into SQL by SAS Macro12:38
Learn how to use PROC SQL options correctly4:21
Learn how to return record number using SAS SQL4:25
Understand the function of the key word 'validate' in SQL2:35
Learn special SAS library4:34
Understand index name and usages in data steps6:19
Remove tables from library using SAS SQL1:46
Display the data structure of a SAS data set in a library1:37
Save the value of a variable at specific record into a macro variable10:05
Learn how to use the STRIP function in SAS8:16
Learn how to use the STRIP function in SAS (Cont.)2:48
Create indexes on a SAS data set for efficient processing2:07
Learn cross joining tables in SAS SQL6:36
Learn how to create non-duplicated pair observations using SAS SQL5:05
Using SAS Macro program and SQL to generate various table merging8:06
Learn how to calculate summary statistics using SAS SQL5:16
Learn how to calculate summary statistics using SAS SQL (Cont.)9:37
Learn how to calculate summary statistics using SAS SQL (Cont.)9:11
Understand SQL Syntax in SAS PROC SQL4:05
Generate automatic report using PROC SQL5:27
Set bufno to use the most amount of memory resources for output buffers3:08
Use proc sql options to eliminate identical observations2:32
Use Macro function to create a data set by keeping numeric variables7:10
Create a new data set by calculating average amount for each item group8:06
Explain a type PROC SQL example with calculated expression8:32
Use PROC SQL to return the successive integers (1,2,3,…) in data set5:41
Explain LIKE 'J%' in the where statement in SAS PROC SQL6:10
Learn sound alike query in SAS PROC SQL1:22
Macro variables containing the return code from previously executed step0:49
Understand some where statements in SAS SQL1:47
A comprehensive study case to finalize this course18:01

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 this course is for:

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

Advanced SAS Course by Solving Questions and Use Cases

What you'll learn

Explore related topics

Course content

Course Introduction1 lecture • 4min

Introduce video and downloadable files1 lecture • 1min

Walk through each question and case by explanation100 lectures • 10hr 50min

Requirements

Description

Who this course is for: