SAS Programming 2021-22

This series of tutorials will help you understand the basic and advanced of SAS Programming on SAS Studio environment

4.40 (17 reviews)

Udemy

platform

English

language

IT Certification

What you will learn

Students will have a good working knowledge on SAS Programming and can use it for their Educational as well as Business projects and assignments.

Working professionals can also benefit from this course as this course provides many tips and tricks which they can use it for their Corporate presentations.

The topics that will be covered in this course are as follows:

1. Introduction to SAS

2. The Procedure step in SAS

3. Subsetting in SAS

4. Sorting and finding the unique values in SAS

5. Table creation in SAS

6. Descriptive statistics in SAS

7. Exporting and Importing datafiles in SAS

8. Formats and Functions in SAS

9. Appending and Merging of data sets in SAS

10. Arrays and reading raw files in SAS

11. Structured Query Language (SQL) in SAS using Proc SQL

12. Data Manipulation and Joining using Proc SQL

13. SAS Macros

Why take this course?

The following topics will be covered as part of this series. Each topic is described in detail with hands-on exercises done on SAS Studio to help students learn with ease. We will cover all the nitty-gritty that you need to know to get started with SAS along with the data manipulation, extraction, merging, sql and macros. The lessons in this course are meant to be taken in order, as each lesson builds up on knowledge, and may mention some important ideas/concepts. If you skip videos, it may appear that some aspects are not being explained. For example, if you skip the import.txt lecture because you only care about importing .csv files, you may miss explanations about certain lines of codes.This series of tutorials will help you understand the basic and advanced of SAS Programming on SAS Studio environment. The topics that we will cover in this course are as follows:

Introduction to SAS
The Procedure step in SAS
Subsetting in SAS
Sorting and finding the unique values in SAS
Table creation in SAS
Descriptive statistics in SAS
Exporting and Importing datafiles in SAS
Formats and Functions in SAS
Appending and Merging of data sets in SAS
Arrays and reading raw files in SAS
Structured Query Language (SQL) in SAS using Proc SQL
Data Manipulation and Joining using Proc SQL
SAS Macros

Content

Introduction to SAS

What is SAS?

Different SAS products, interface and how to use it?

Concept of SAS Libraries

Different steps in SAS commands

Creating temporary and permanent SAS datasets

Metadata structures of a SAS dataset

Using Rename and Label for variables in a dataset

The Procedure step in SAS

Generating list of reports using print procedure

Print procedure for specific variables

Supressing the OBS number and setting an ID variable

Using custom labels in Print procedure

Using keywords like Sum and N with print procedure

Generating reports using proc contents

Using Proc contents for multiple data

Using additional keywords with proc contents

Subsetting in SAS

Creating subsets of a data using FIRST OBS and OBS technique

Using keep and drop in SAS data step

Introduction to basic where clause in SAS

Patterns matching using where clause

Wildcard matching and more using where clause

If, then, else in SAS

Select, when, otherwise in SAS

Splitting of data sets in SAS

Sorting and finding the unique values in SAS

Sorting datasets using Proc sort

Sorting existing data Vs. Creating a new sorted data

Finding unique values using Nodup

Finding unique values using Nodupkey

Table creation in SAS

Frequency distribution table in SAS

Cross-tabulation in SAS

Using additional keywords with cross-table

Understanding the basics of Proc Tabulate technique

More applications using Proc Tabulate

Descriptive statistics in SAS

What is descriptive statistics and what are the techniques available in SAS?

Understanding Proc Summary technique in SAS

Understanding Proc Means technique in SAS

Understanding Proc Univariate technique in SAS

Exporting and Importing datafiles in SAS

Exporting SAS data file to CSV file

Exporting SAS data file to Text file formats

Exporting SAS data file to Excel file formats

Importing CSV to SAS data file

Importing Text file formats to SAS data file

Importing Excel file formats to SAS data file

Formats and Functions in SAS

Creating user defined character formats in SAS

Creating user defined numeric formats in SAS

Data functions in SAS

Calculating date difference in SAS

Standard text functions in SAS

More on text functions and matching strings

Standard numeric functions in SAS

Appending and Merging of data sets in SAS

Transposing existing data set in SAS

Appending of datasets in SAS

Appending keeping common variables

Merging of datasets in SAS

Left, Right, Inner and Outer Merging of data in SAS

One to many merging of data in SAS

Many to many merging of data in SAS

Arrays and reading raw files in SAS

Using Arrays for calculation part 1

Using Arrays for calculation part 2

Importing raw data in SAS

Importing raw delimited data with missing values in SAS

Structured Query Language (SQL) in SAS using Proc SQL

Introduction to SQL in SAS

Using Proc SQL to select columns and display reports

Labeling columns in Proc SQL

Assigning formats to columns

Sorting datasets using Proc SQL

Ordering by unselected columns and column references

Finding unique observations using Proc SQL

Creating new calculated columns using Proc SQL

Creating new columns using conditional statements

Using where clause in Proc SQL

Missing value treatment using Proc SQL

Grouping observations using Proc SQL

Simple summarization using Proc SQL

Conditional summarization using Proc SQL

Multiple subquery

Data Manipulation and Joining using Proc SQL

Using Union, Intersect and Except clause in Proc SQL

Storing the results in a new data set using Proc SQL

Inserting new observations in an existing data using Proc SQL

Updating and deleting observations using Proc SQL

Creating a new dataset from scratch using Proc SQL

Dropping and Adding columns in a data using Proc SQL

Joining datasets using full join method in Proc SQL

Joining datasets using Inner join method in Proc SQL

Joining datasets using Left join method in Proc SQL

Joining datasets using Right join method in Proc SQL

SAS Macros

Understanding SAS Macro and why it is used?

Creating a basic macro program

Creating dynamic macro program

Understanding macro variables

Creating and using Global Macro variables

Creating and using Local Macro variables

Arithmetic operations using macro variables

Creating macro variable in SAS data step

Creating macro variables in Proc SQL

Storing macros in a permanent library for future use

Using pre-created macro programs in a new session

Reviews

Matheus

July 4, 2023

This course delivers what has been proposed, and is great for those people who know little about SAS programming, I recommend it to beginners, but for those who want to go deeper into SAS programming it may not be the best option, in general it is a good course.

Sebastiano

May 25, 2022

this training gives you a good basis for sas and proc sql. some of the data sets used are no longer in sas studio, so some of the trainings were hard to follow, or you needed to create the data set on the spot or try to find one that was comparable. but I walked away with a more thorough understanding of sas and proc sql.

Hlabirwa

June 8, 2021

The teacher is very good and knows how to teach SAS for beginners without complicating or losing you. However, the course need practice questions.

Charts

Price

Rating

Enrollment distribution

SAS Programming 2021-22 - Distribution chart