SAS Programming: Data Manipulation and Analysing Techniques

Learn Data Transformation with SAS. Clean dirty data with SAS. Analyse your data with SAS. Lots of SAS Practices !

3.75 (43 reviews)
Udemy
platform
English
language
Programming Languages
category
instructor
SAS Programming: Data Manipulation and Analysing Techniques
1,536
students
7 hours
content
Nov 2018
last update
$49.99
regular price

What you will learn

You can do data analysis easliy.

You can transpose your data, add new calculated columns.

You can delete some values in your data, and impute them also.

After you finish this course, you can start applying data mining techniques and create data models.

Description

What are we going to learn in this course?

  1. Firstly we are going to download and install SAS University Edition which is totaly free.

  2. We will convert Excel tables to SAS tables.

  3. We will write lots of SAS functions and create new variables/columns.

  4. We will write SQL scripts also, and we will compare SAS and SQL codes.

  5. We will join different tables, and filter&sort tables.

  6. We will create graphs easily.


Creating meaningful data is the first step for the all data processes. If you want to create a model, apply data mining model, you have to apply this step firstly.

If you want to become a data engineer or data scientist, this course is really helpful.

You can understand and analysis data with some basic and easy functions in SAS which will be explained in the lesson.

Then you can manipulate data, impute missing variables and create new columns, merge different tables with SAS.

At the end of the course, you can apply all techniques to create clean and meaningful data with SAS.

Lots of functions and examples are applied in this course, if you have any question about a function, I can answer you quickly and also you can suggest new topics or functions to me. Lots of additions will be done in this course.

Content

Introduction

Course Content
Introduction to SAS
SAS Installation
Introduction to SAS Panels
First SAS Program

SAS Variable Types

SAS Variable Types
Create Variable Types
Set Statement
Drop and Keep Variables
Drop and Keep Variables

Import and Export Tables in SAS

Length Function
Create Datalines
Create New SAS Library
Import Excel Tables into SAS
Convert SAS Table to Excel Table
Rename Statement
Compress Function
Import and Export Tables in SAS

Filter and Sort SAS Tables

Filter Table with Where Statement
Sort SAS Table
Limit Data Observation
Filter and Sort Tables

SAS Functions

Min and Max Functions
Sum Function
Divide Function
Round Function
Range Function
Stdev Function
Log Function
Special _N_ Character
Date Functions
Date Calculation Functions
Numeric Functions
Uppercase and Lowercase Functions
Length and Count Functions
Substring Function
Tranword Function
Compress Function
Any Functions
Find Function
Cat Functions
Character Functions
Convert Character to Numeric
Convert Numeric to Character
Convert Character to Date

If-Else Conditions

If Else Condition : Part1
If Else Condition : Part2
If Else Condition: Part3
If Else Condition : Part4
If - Else Conditions

SAS Procedures

Introduction to SAS Procedures
Procedure Means
Procedure Correlation
Procedure Summary
Procedure Append
Procedure Transpose

Join / Merge SAS Tables

Introduction to Join Types
Inner Join
Full Outer Join
Left and Right Joins
Join Types

Using SQL in SAS

Introduction to SQL
First SQL Code in SAS
SQL Rename Statement
SQL Keep Columns
SQL Create Columns
SQL Select Distinct Columns
SQL Filtering Data
SQL Sorting Data
SQL Filtering and Sorting Data
SQL Length Function
SQL Numeric Functions
SQL Character Functions
SQL Case-When Condition
SQL Join Types
SQL Inner Join
SQL Full Outer Join
SQL Left Join
SQL Right Join
SQL Join and Filter&Sort

Creating Charts and Plots

Bar Chart
Box Plot
Distribution Graph
Line Plot
Scatter Plot
Pie Plot

Statistical Analysis with Tools

One Way Frequencies Task
Summary Statistics Table
Table Analysis

Advenced SAS

First and Last Statement - Part1
First and Last Statement - Part2
First and Last Statement - Part3
Retain Statement - Part1
Retain Statement - Part2
Do - While Loop
Do - Until Loop
Do - By Loop
Introduction to Macros
Macro - Mend Blocks
Using Dynamic Inputs in Macro Blocks

Reviews

Sapphire
October 8, 2022
The course is outdated and the audio is terrible. First, the SAS download in voice box is not applicable because the software is no longer supported. Second, the audio is high pitched and grating, it sounds as if a wind screen wasn't used to reduce the sharpness of the P's and S's. The speaker has a thick accent and poor grammar which makes it a little more difficult to understand.
Maria
August 3, 2022
I really like the course, but I think could be better if were more test/tast to practice :), The audio is not so bad, but i think could be better. Thanks.
William
February 10, 2021
The topics covered and the interactive nature of the course was really useful. The way she kept demonstrating the subject matter and reinforcing the material really made it stick.
Kirsty
July 14, 2020
The screen shots in the videos so far are all out of focus so I can't see what the presenter is referring to.
David
October 1, 2019
The course has a very logical and easy-to-follow step-by-step lessons. Although the instructor's English language is not 100% perfect, she takes student through the concepts with a suitable speed. I recommend this course to beginners. It is a good course for beginners.
Jimmie
November 3, 2018
Although there is a language barrier, I feel the instructor is very knowledgeable and I'm learning a lot from this course. This is my first introduction to SAS but I have programmed in other languages like C/C++, Java, HTML, & Python over the years so I know programming concepts.
Enes
September 6, 2018
I must say that I think the course is really successful. The instructor is very expert about the subject and is interested in her students. So I would definitely recommend it.

Charts

Price

SAS Programming: Data Manipulation and Analysing Techniques - Price chart

Rating

SAS Programming: Data Manipulation and Analysing Techniques - Ratings chart

Enrollment distribution

SAS Programming: Data Manipulation and Analysing Techniques - Distribution chart

Related Topics

1862932
udemy ID
8/17/2018
course created date
7/1/2019
course indexed date
Bot
course submited by