SAS Training by Reviewing and Solving Certificate Questions

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

(196 ratings)

1,119 students

Created by Datagist INC

Last updated 5/2017

English

English [Auto]

30-Day Money-Back Guarantee

What you'll learn

understand concepts in SAS basics
perform data manipulation, exploration and analysis using SAS
acquire SAS knowledge and skills to pass certificate exam
master SAS programming to solve real world problems
learn SAS while solving different types of questions
get rich study materials in learning and practicing

Requirements

Basic computer skills
Intention to learn

Description

If you need a comprehensive SAS course that helps you

1) pass SAS certificate exam;

2) master SAS programming by solving 101 questions;

3) understand how SAS codes are working;

4) walk through each question by patient interpretation ;

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

6) extend SAS knowledge and skills beyond these 101 questions

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:

Anyone who wishes to learn data analysis using SAS
Beginners who want to learn SAS and pass certificate exams
Anyone who needs to learn 'why' by slower-pace interpretation
Anyone who likes to learn while solving questions

2 sections • 104 lectures • 10h 31m total length

Preview05:32
SAS installation, version and environment
08:14

Teaching approach (with PDF downloadable)
05:06
Know SAS library and current folder
04:48
Preview03:06
Learn set statement, _n_ and logical operators in SAS
07:18
Know if statement to restrict or subset SAS data sets
02:46
Understand output statement, do loop structure
05:31
Know page number setting for SAS procedure output
01:20
Learn SAS format to display data as you want
04:18
How to input data from data step using position input
04:45
Learn data input using DSD, how to input missing values
06:10
How to use filename statement in SAS for data input and output
03:20
Rename methods and how it affects other operations
06:52
About date type, data conversion, functions and informat
06:38
Understand data line holding, strongly holding and training sign @
04:51
Understand holding, strong holding and trailing
03:51
Learn in operator, if then statement
11:15
Learn output statement, merge statement
04:12
Understand set statement, (in=) and if statement
02:25
Test sort and merge data sets in SAS
04:09
Learn relational merging data sets
06:12
Learn sorting data, nodupkey option
04:22
Understand ranuni() function and random sampling
06:15
Preview06:12
Setting multiple data sets in one data step
05:47
Learn date type data and operations
06:26
Learn date format and date operations
07:39
Concatenate string, date type, input() and put() functions
07:03
Compbl() function, do loop and output statement
05:01
Test date function -- weekday()
02:35
Understand how to use informat in reading date and missing values
08:53
Know how to save observations into external files
07:49
data _null_, put statement, infile statement and DSD option
05:57
Test variable expression, logical expression
06:20
About usages of the keep statements
06:58
Learn the output about proc contents
06:50
Learn statements and options in proc datasets
03:15
Understand functionality of proc flist
01:16
Delete data in the library
04:34
Understand array and data transformation
06:37
Learn SAS array and its relationship with variables
04:09
Extract variables with a specified data type using array
05:14
Learn how to transform data set using data step
12:59
Use array and summarized function in data step
06:51
Understand usage of SAS array in data step
02:54
About proc sort and its nodupkey option
07:30
Know how to use data step to get cumulative data
10:50
Knowledge about do loop, output and return statements
08:01
Know how to use _error_ and error handling method in SAS
07:11
Understand merging data sets by consistent order
03:20
Learn round() function in data step
07:47
Understand missing value and logical operation
06:52
How to use lag and dif function in SAS
10:22
Understand date format and relationship with string
06:13
Test how to use proc format to create format used in data step
08:59
Learn how to create format based on numerical range
08:49
Test your understanding about proc means
06:47
Understand by and class statements in proc means
01:27
About debug option and usage in data step
01:13
Data conversion: substr(), input() and put() functions
08:17
Understand the concept about SAS macro _error_
03:43
Define valid library
02:45
Read data based on position, informat and modifier
09:56
Understand firstobs, obs options in SAS data step and procedures
04:18
Understand firstobs and obs options (2)
06:05
Read raw data into SAS table from external files
04:22
Test output, _n_ and if..else statements in one data step
04:01
Know SAS format definition and location
04:04
Test how to use do while and break condition
04:44
Understand how to use label statement in data step
03:09
Know how to apply cat() and catx() functions
06:16
Learn string function: finding positions in a string
04:24
Learn how to split data based on coditions
05:33
Use array and create missing values
07:24
Use array and create missing values (2)
04:21
Use array to create variables in data step
04:11
Understand logical conditions in if statements
04:43
Learn how to apply multiple filters based on several if statements
05:55
Understand date, character types in data step
10:07
Learn how to apply universal string matching to query data
09:30
Apply proc means to create descriptive statistics and output
10:10
Apply proc means to create descriptive statistics and output (2)
04:12
Apply proc freq and obtain the intended output
11:39
Create two ways frequency cross tab and intended output
07:51
Understand options in proc report
08:03
How to apply ODS in SAS to create intended output
09:13
Getting resulting table based on if then filters
06:56
Use if...else if statement
05:30
Debug syntax errors in data step
03:55
Understand trailing symbols used to read data
10:25
Data type conversion using put() function
06:37
Data tytpe conversion (2)
03:13
Keep and drop variables in data step
05:48
Use single trailing to conditionally read data
08:21
Transpose data, create cumulative data using retain statement
16:01
About data error and log
04:40
Correctly use firstobs and obs option in SAS procedures
05:11
Apply composite functions in data step
05:40
Apply eof option in SAS data step
00:58
How to split data in one column when reading raw data
09:56
Understand output containing descriptive statistics in proc means
09:35
Understand how SAS variables are listed
04:14
Learn how to merge two tables with different manners
05:55

Datagist INC

teacher

4.2 Instructor Rating
464 Reviews
2,863 Students
4 Courses

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.

SAS Training by Reviewing and Solving Certificate Questions

What you'll learn

Requirements

Description

Who this course is for:

Course content

Course introduction2 lectures • 14min

Walk through each question by reviewing SAS102 lectures • 10hr 18min

Instructor