SAS Programming in 7 Steps
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
0 students enrolled

SAS Programming in 7 Steps

A step-by-step guide to learn SAS programming from scratch
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
0 students enrolled
Created by Packt Publishing
Last updated 8/2019
English
English [Auto-generated]
Current price: $86.99 Original price: $124.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understand SAS as a programming language and see the benefits of SAS over Excel
  • See the workings of the SAS environment with PC-SAS and methods of importing data into SAS
  • Understand the SAS environment, for example whether fields in the data are numeric, character, or date, or whether there are non-required fields in the data
  • Import data into SAS sorting data, merging two datasets and using if-then-else commands
  • Use logical operators such as “AND” and “OR” to select particular portions of the data
  • Work with data and procedure statements in SAS. Report a graphical presentation, and create an output
  • Learn to utilize key features such as arithmetic operators and pulling variables from the database using SQL
Requirements
  • Analyst without any programming background or are new to SAS programming,
Description

SAS is a programming language designed specifically to analyze statistical data. SAS transforms data into insights, which can give you a fresh perspective on business. This course teaches you about SAS studio to write SAS code.

In this course, you’ll learn how to get your data into SAS by reading data through various methods. You’ll see how to create and import SAS data. You’ll work with data by using conditional statements and functions in SAS. You’ll also learn about various SAS procedures to work with your data.

All of the concepts are covered using a structured, practical implementation through mini-projects. You’ll learn by coding in a hands-on way, working in a SAS programming environment, and getting a detailed step-by-step explanation and implementation of each concept.

About the Author

Aditi Pratap Sampat completed her Master’s in Statistics at the University of Bombay. She has worked extensively on various analytics platforms during her professional experience with several large multi-national organizations such as GE Capital, Oracle, Morgan Stanley, and ICICI. Currently, she is working on many projects related to research in the analytical and legal spheres.

Who this course is for:
  • If you’re an analyst without any programming background or are new to SAS programming, this is the course for you. Those looking to prepare for the SAS Certified Base exam will also find this tutorial a key resource.
Course content
Expand all 33 lectures 02:29:25
+ Basic SAS programming in SAS
7 lectures 14:58

This video will give you an overview about the course.

Preview 02:02

In this video, you’ll learn the different types of SAS.

   •  Learn different benefits of the different types of SAS

Types of SAS
01:01

In this video, you’ll learn about the components of SAS system.

   •  Briefly talk about the three windows of SAS

Components of the SAS System
01:29

In this video, you’ll learn about the program editor and log windows.

   •  Learn the features of program editor window

   •  Discuss and learn about the features of log editor

Understand the Program Editor and Log Window
02:56

In this video, you’ll learn in detail about temporary and permanent libraries in SAS as well as explaining the work library in detail.

   •  Learn about the concept of library

   •  Learn how to access the libraries

   •  Understand the different types of library

Concept of Library – Permanent and Temporary Libraries
03:05

In this video, you’ll learn the importance of semicolon and run commands in SAS. This video will highlight the mistakes made by SAS programmers while writing SAS program.

   •  Understand the importance of semicolon in SAS

   •  Learn about the RUN command in SAS

Writing Semicolon and Run Commands in SAS
01:46

In this video, you’ll learn about obtaining the access to SAS studio and importing files in SAS studio.

   •  Create your profile in SAS studio

   •  Import the files from local drive

Importing Files in SAS
02:39
+ Getting a Feel of the Data
5 lectures 24:31

In this video, you’ll learn about the CONTENTS procedure to find the variables and the variable types in the data.

   •  Understand the CONTENTS procedure to find the variable names, their types, length, and so on

   •  Execute the different types of variables in live SAS studio

Preview 03:07

In this video, you’ll learn how to print procedure in SAS.

   •  Understanding the PRINT procedure to obtain the values of the variables in the data

   •  Print the variables in the SAS studio

Printing a Few Observations in the Data
05:22

In this video, you’ll learn how to find the missing values by the frequency procedure.

   •  Explain the concept of categorical variable

   •  Run the frequency procedure for distinct values of categorical variables

   •  Obtain the count of missing observations in the data

Find Missing Values Using the Frequency Procedure
04:14

In this video, you’ll find out the average, minimum, and maximum values of the numeric variables in SAS.

   •  Derive the descriptive statistics using the means procedure on numeric and continuous variables

   •  Use the minimum and maximum of observations to find the extreme values in the data

Using Means Procedure to Find Average, Max, and Min Values
06:14

In this video, you’ll learn about the univariate procedure to obtain various statistical results in SAS.

   •  Understanding the univariate procedure as an exploratory data analysis tool for numeric variables

   •  Derive normality tests for avariable

Using Univariate Procedure to Obtain Various Statistical Results in SAS
05:34
+ Using Data and Proc Commands in SAS
5 lectures 28:56

In this video, you’ll learn about the sort procedures of the SAS.

   •  Understand the SORT procedure and its iterations

   •  Use the SORT procedure in SAS

Preview 04:02

In this video, you’ll learn on how to merge the datasets of SAS.

   •  Understand the merge statement

   •  Understand the requirement of sorting the data on basis of variable common to the underlying datasets before merging

Merging Datasets on the Basis of Common Variable
07:23

In this video, you’ll learn appending SAS datasets.

   •  Understand the concept of combining two datasets

   •  Learn the uses of datasets to the user

Appending Datasets
05:32

In this video, you’ll use the conditional statement and derive the new variables.

   •  Explain the use of arithmetic operators in deriving new variables

   •  Create new datasets with the help of arithmetic operators

Using Conditional Statements and Deriving New Variable
05:56

In this video, you’ll use to learn If-Then-Else statements as conditional operators.

   •  Understand the process for applying conditional operators in SAS

   •  Create new variables on the basis of conditions applied to existing variables

Using If-Then-Else Statement as Conditional Operators
06:03
+ Arithmetic Logical and Comparison Operators
5 lectures 26:53

In this video, you’ll introduce to different types of arithmetic operators.

   •  Create new dataset with new variable in dataset

   •  Understand the arithmetic operators such as addition, subtraction, multiplication, and division in SAS

Preview 06:33

In this video, you’ll learn about the logical operator – AND and OR.

   •  Use logical operators to construct logical sequence of comparisons

   •  Create a new dataset based on underlying criteria applied to existing variables

Introduction to Logical Operators – “AND” and “OR”
07:35

In this video, you’ll understand the logic operator – IN.

   •  Determine whether the value is part of a specified list

   •  Select specific observations of an existing dataset and creating a new dataset

Using Comparison Operators – “IN”
04:19

In this video, you’ll learn the comparison operators – Equal to and Not Equal to.

   •  Set up comparison, operation, or calculation of two variables

   •  Create new datasets/modify existing datasets on the basis of criteria applied to existing variable

Using Comparison Operators – Equal To, Not Equal To
04:41

In this video, you’ll learn about the operators – greater than and less than.

   •  Create new datasets/ modify existing oneson the basis of criteria applied to existing variable

Using Comparison Operators – Greater Than, Less Than
03:45
+ Enhancing the Output Using Graphs, Tabulate, and ODS HTML
5 lectures 22:53

The aim of this section is to gain an understanding of the process, to enhance the output using ODS HTML, label, and title statements.

   •  Learn how to label variables and values in SAS

   •  Understand ODS HTML in SAS

   •  Talk about the title statement in SAS

Using Label, ODS HTML, and Title to Enhance the Output in SAS
12:25

The goal of this video is to understand the process of creating Vertical and Horizontal bar charts in SAS.

   •  Give an overview of graphs in SAS

   •  Know the Horizontal and Vertical bar charts in SAS with a simple code example

Graphs – Creating Vertical and Horizontal Bar Charts in SAS
03:02

In this video we will understand the process of creating Pie charts in SAS.

   •  Provide an overview for Pie charts in SAS

   •  Create a Pie chart in SAS with a simple code example

Graphs – Creating Pie Charts in SAS
03:04

In this video we will learn how to use the Tabulate procedure to generate descriptive statistics.

   •  Give an overview of Proc Tabulate

   •  Show a basic code example to create Proc Tabulate

   •  Summarize the Proc Tabulate

Understanding the Syntax of Proc Tabulate
03:23

The aim of this video is to understand the advantages of the Tabulate procedure over Pivot table of Excel.

   •  Display the comparison between Proc Tabulate in SAS and Pivot table in Excel

   •  Understand why Proc Tabulate is better than Pivot table in Excel

Comparison of Proc Tabulate to Pivot Table of Excel
00:59
+ Using SQL in SAS
3 lectures 12:04

In this video, you are going to discuss PROC SQL command usage in SAS.

   •  Learn the features of SQL

   •  Introduce the concept of PROC SQL along with the tasks performed by PROC SQL

   •  Discuss different tasks performed by PROC SQL

PROC SQL Command Usage in SAS
02:27

In this video, you’ll learn how to pull variables from the database

   •  Use the SELECT statement to select one or more variables from the database

   •  Understand the FROM statement

   •  Learn this in the SAS Studio

Pulling Certain Variables from the Database
03:51

In this video, you’ll learn aboutusing the Group By statement in PROC SQL.

   •  Understanding the use of the Group By statement

   •  Discuss the procedure in SAS studio

Using the Group By Statement
05:46
+ Using Dates in SAS
3 lectures 19:10

Understanding the SAS treat date values internally.

   •  Provide an overview for the concepts of date values in SAS

   •  Show a code example in SAS Studio for Date Values

   •  Summarize the date values in SAS

Date Values in SAS
05:08

Using the FORMAT and INFORMAT statements with regards to dates in SAS.

   •  Provide an overview for the usage of MDY function in SAS

   •  Show a code example in SAS Studio for the MDY function to create dates using FORMAT statement

   •  Show a code example in SAS Studio for the MDY function to create dates using INFORMAT statement

Usage of MDY Function to Create Dates in SAS
06:21

Calculating the number of days/years using the DATDIF and YRDIF functions in SAS.

   •  Provide an overview for the DATDIF function

   •  Show a code example in SAS Studio to find days/years between two dates using DATDIF function

   •  Provide an overview and show a code example in SAS Studio to find days/years between two dates using YRDIF function

Finding Days/Years between Two Dates in SAS
07:41