SQL Fundamentals | Complete SAS Programming Guide - Learn SAS and Become a Data Ninja

Book Overview & Buying
Table Of Contents

Complete SAS Programming Guide - Learn SAS and Become a Data Ninja

By : Ermin Dedic

Buy this Video

Complete SAS Programming Guide - Learn SAS and Become a Data Ninja

By: Ermin Dedic

Buy this Video

Overview of this book

SAS programming continues to be the language of choice for most enterprises/corporations. In 2018, 92% of Fortune 100 companies used SAS. It is the go-to for many industries, including banking/finance, insurance, healthcare, pharmaceutical, and automotive. The first part of the course utilizes the Data Step; the second part looks at SAS SQL, and the third part looks at Macro Programming/Programs. The author has added a section on SAS predictive modeling using logistic regression. Here, we will build a SAS Model. In other words, we will build a predictive model (also known as predictive analytics) while following critical principles to ensure we get things right. This course is also developed to help you become SAS Certified Specialist: Base Programming certified. By the end of this course, you will learn how to code in the SAS programming language, to help you start a career/gain employment, or move up at your current company. If you are studying SAS at a post-secondary institution, this course can not only help you with school projects but prepare you for a career after you complete your education. Disclaimer: This course uses a commercial license from WPS. Learning SAS programming means that you will be able to accomplish the same goal on any software that supports the SAS language. The author personally uses WPS. All the resource files are added to the GitHub repository at: https://github.com/PacktPublishing/SAS-Programming-Complete-Learn-SAS-and-Become-a-Data-Ninja

Introduction to the Course

SAS Studio/SAS OnDemand for Academics – Register, Upload, Run Code

WPS – How to Find, Install, Register for, Use, and Upload Datasets

Common Problems with Install/Upload (Watch for Best Course Experience!)

Importing

Import .txt

Import .csv

Import .XLSX

SAS Syntax, Data Step Versus Proc Step, SAS Compared to R/Python

Data Step Versus Proc Step

SAS Syntax

Manually Creating Data with R, Python, and SAS

Working with Data

Data Set Options

What If Your Data Is Separated by a Dot or Something Else? (Delimiters)

Reading Data Instream in Data Step (Typing Data Right into Coding Area)

Reading DATES in Data

Creating Variables/Calculations

More on the WHERE Expression/Statement

Sorting Observations (PROC SORT and BY Statements)

Merging Two Datasets

Using SET Statement to Merge

Data Reduction and Cleaning Your Data

LENGTH Statement

Creating a Counting (Enumeration) Variable

Back to Importing

Importing SPSS File with SAS Language

Input Types and Informats + User-Defined Formats

List Input

Column Input

Formatted Input and Informats

User-Defined Formats

Arrays

Arrays 1 (Recoding Variables)

Arrays 2 (Constructing New Variables)

SAS Functions

Understanding SAS Functions

RAND Function (Producing a Sample with Distribution of Your Choice)

LENGTH, LENGTHN, LENGTHC Functions (Are You Working with a Large Dataset?)

TRIM Function (Want to Get Rid of Trailing Blanks?)

COMPRESS Function (Remove Characters from String, and All Types of Blanks)

Input and Put Functions

CATX Function

SCAN Function

Coalesce Function

Verify Function

Substr Function

Advanced Techniques – Flexibilities and Efficiency

Flexible Programming 1 - Combining multiple raw data files vertically

Visual Representation of Data

Scatter Plot

Bar Graph

Statistical Analysis

T-Test Independent Samples Overview (Example)

Doing an Independent Samples T-Test Analysis

Chi-Square Independence Overview (Example)

Doing a Chi-Square (Independent Groups) Analysis

Statistical Analysis – Part 2 (Linear and Multiple Regression)

Refresh Your Memory - Regression Edition

Performing the Linear Regression

Performing Multiple Regression

Case Studies

Case Study (HealthCare Case Study) - Part 1

Case Study (HealthCare Case Study) - Part 2

Congrats on Finishing Part 1: Data Step

SQL Fundamentals

SQL Syntax

WHERE Clause

SELECT Statement and Columns

CASE Logic

Summary Functions

SAS SQL and Joining

How to Perform an Inner Join

How to Join Three Tables

How to Perform a Left/Right Join

How to Perform a Full Join

Working with Tables Using SAS SQL

How to Create a Table Using SAS SQL

Altering Columns (Add, Modify, Delete, Add Values to Column)

Inserting Rows with a Query and Set Statement

Practical Application of SAS SQL

How to Compare Tables with SAS SQL

Finding Duplicate Observations

Customize the Way You Sort

How to Update a Table Under Certain Conditions with SAS SQL

Fundamentals of Utilizing SAS Indexes

Intro to Indexes/Indices

Should You Use an Index?

Types of Indices

Index Options

Testing with Large Datasets

Selecting Variable(s) for Your Index

PROC Datasets and WHERE Expression

BY Statement (Sorting Variables, While Exploiting Your Index)

Handling Common Tasks with an Indexed Dataset

Updating the Master Dataset with New Variables or Observations

Macro Facility Fundamentals

Types of Macro Variables

Don't Lose Track of Your Macro Variables

Macro Variable Assignment Rules

Masking Special Characters

Macro Functions (%Index and %Upcase)

Macro Functions 2 (%Scan)

Creating a Macro Variable (Helps You Modify Data Easier)

Macro Programs Introduction

Creating a Macro Example 1 (Greater Flexibility and Useful for Repetitive Coding)

Creating a Macro Example 2 (Unique Sales Reports for Different Days)

Creating a Macro Example 3 (Calculating Average Sales for Multiple Years)

Debugging Options

Storing Macros (External)

Brainstorming for Logistic Macro Case Study

Logistic Macro, Case Study – Part 1

Logistic Macro, Case Study – Part 2

Introduction to SAS Predictive Modeling Using Logistic Regression

Business Applications of Predictive Modeling

Analytics Challenges

The Major Steps in Predictive Modeling

Intuitive Understanding of Logistic Regression

SAS Model – Predictive Modeling, Understanding the Problem and the Data

Problem Statement/Hypothesis Generation

Data Audit

Univariate Analysis

Bivariate Analysis

Important Housekeeping

SAS Predictive Modeling, Prepare the Input Variables

Sources, Patterns, and Mechanisms of Missing Data

Evaluating Missing Data Patterns with SAS

3 Phase Multiple Imputation Process Using SAS

Considering the Output from PROC MI

Oversampling and Adjusting for Oversampling

Categorical Inputs

Variable Clustering

Multicollinearity

Subset Selection

Parameter Estimates

SAS Predictive Modeling, Evaluation Metrics

ROC Curve

Scoring Validation Dataset Using Code

Decile Calibration Plot

Feature Engineering

Extra Content

Top Five SAS Certification Questions Answered

Complete SAS Programming Guide - Learn SAS and Become a Data Ninja

By : Ermin Dedic

Complete SAS Programming Guide - Learn SAS and Become a Data Ninja

By: Ermin Dedic

Overview of this book

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access