Complete SAS Programming Bootcamp 2019: Go from zero to hero

BY
Udemy

Lavel

Beginner

Mode

Online

Fees

₹ 1499

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course and certificate fees

Fees information
₹ 1,499
certificate availability

Yes

certificate providing authority

Udemy

The syllabus

Setting Up Your SAS Environment and Download the Data!

  • Setup your SAS Environment with SAS WPS Analytics
  • Setup your SAS Environment with SAS University Edition

Welcome to the world of SAS!

  • What can you do with SAS?
  • What is a SAS Program? How does the syntax work in SAS?
  • SAS Libraries (Libname Statement)
  • What is a SAS Data Set? Proc Contents and Proc Print
  • Types of Variables in SAS
  • Filter data using the WHERE statement - Operators (Logic, Comparison, Arithmetic
  • Special Operators for the WHERE statement
  • What is a SAS Format?
  • Dates and Date Formats in SAS
  • Creating a user-defined format using Proc Format
  • Ordering data and creating reports by Groups using the BY statement
  • Improve the aesthetics of a report adding Titles, Footnotes, Labels.

Data Manipulation I (Learn to use the powerful Data Step!)

  • Learn to read a SAS Data Set with the Data Step
  • Creating Variables and Filtering Variables with the KEEP & DROP statements
  • Difference between filtering with the WHERE and Subsetting IF statements
  • Adding Permanent Attributes using the LABEL, FORMAT, and LENGTH statements
  • How does Data Step Processing works?
  • Using simple functions and learning to get frequencies using PROC FREQ
  • Process data conditionally using IF-THEN/ELSE statements
  • Execute multiple statements conditionally using DO and END statements

Summarizing Character and Numeric Data! (Proc Freq, Means, Univariate)

  • Summarize Character Data in Frequencies using Proc Freq!
  • Create Contingency Tables (2x2 table) with Proc Freq!
  • Summarize Numeric Variables with Proc Means (N Mean Median Std Min Max etc..)
  • Summarize Numeric Data (Proc Univariate: Quantiles, Central Tendency Measures)

Importing Data (Excel, CSV, Tab) in different formats/structures

  • Using the PUT function to convert Numeric Variable to Character Variable
  • Using INPUT function and INFORMATS to convert Character to Numeric variables
  • Using PROC IMPORT to import different file formats (csv, xlsx, txt)
  • [Advanced] Other techniques to Read Data using Data Step
  • [Advanced] COLUMN INPUT technique to read data organized in columns
  • [Advanced] FORMATTED INPUT technique to read Non Standard data organized in columns
  • [Advanced] MODIFIED LIST INPUT technique to read delimited data (Non/Standard Data

Data Manipulation II (Controlling Input and Output, Accumulating Totals & more!)

  • Writing Observations Explicitly (Output Statement)
  • Writing to Multiple SAS Data Sets
  • Optimize the processing using SAS Data Set Options (Firstobs=, obs=, Keep=)
  • More Data Set Options (Rename = , Where=)
  • Create an Accumulating Total Variable (Process data vertically - RETAIN statement)
  • Accumulating Totals for a Group of Data using the BY Statement and Data Step
  • Accumulating Totals for more than One Group using the By statement and Retain

SAS Functions (Character & Numeric Functions)!

  • Character Functions to Extract Text ! (SUBSTR, LENGTH)
  • More functions to Extract Text from String! (RIGHT, LEFT, CHAR, PROPCASE)
  • More Character Functions (SCAN, INDEX, CATX, TRIM, STRIP)!
  • Character Functions to Concatenate Strings (CAT, CATT, CATS)!

Working with Dates Values (Dates - , Datetime - , Time Values

  • Introduction to SAS Dates (Date Values - Datetime Values - Time Values)
  • Converting Dates stored in text (Character) to Date Values (Numeric)
  • Converting Date Values (Numeric) to text (Character)
  • Using the INTCK() function to calculate difference of 2 dates (in months, years)
  • Using INTNX() function to increment a date (in years, months, qtrs, days, etc)
  • Calculate difference between Dates using the DATDIF() function

Learning to Combine Data (Concatenating and Merging/Joins)

  • Concatenate Data using the Set Statement in the Data Step - Part 1
  • Concatenate Data using the Set Statement in the Data Step - Part 2
  • Concatenate Data using Proc Append
  • Understand how data can be related (One-to-One, One-to-Many, Many-Many)
  • Using Merge to get all types of Joins (Left, Right, Inner, Full Join, etc)
  • Learn how to merge data in a One-to-One and One-to-Many Scenario
  • Warning on Merge Statement in a Many-to-Many scenario, use SQL instead.

Do Loops - Processing Data Iteratively

  • Introduction to Do Loops (Iterative, Do Loop)
  • Business Scenario using Iterative, Do-Loops
  • Introduction to Infinite Loops (Do While and Do Until)
  • Business Scenario using Do While/Do Until
  • Solving a Business Scenario Using Iterative, Do Loops and Do While/Until
  • Learn to use Nested Do Loops to solve real problems!

Working with Arrays and Learning to Transpose Data

  • Introduction to Arrays
  • Ways to reference Variable Lists in Arrays
  • Create and Compare different variables using Arrays
  • Using Arrays as a LookUp Table to make comparisons
  • Exercise 1 - Using Arrays to look for the Max Sale using INDEX and VNAME function
  • Exercise 2 - Using Arrays as a lookup Table to find Antibiotics in prescriptions
  • Using Arrays to Restructure a Dataset (Transpose and Stack Columns)
  • Intro to Proc Transpose (Easiest way to Transpose/Stack Columns in SAS)

Pivot Tables in SAS using Proc Tabulate!

  • Introduction to Proc Tabulate
  • Creating the Structure of the Table: One- ,Two- , Three- Dimensional Tables
  • Creating the Structure of the Table: Concatenating and Crossing Variables
  • Adding Overall Summarizations using the Keyword ALL (Totals, SubTotals)
  • Adding Statistics to the Analysis Variables (Median, Quartiles, Percentiles)
  • Adding different Percentages (Column-, Row-, Report- Percentages)
  • Specify a denominator to calculate Percentages using keyword PCTN
  • Improve the Aesthetics changing Labels, KeyLabels, Formats
  • Adding Formats to Percentages and Customize missing Values
  • Creating a Professional Report with Proc Tabulate in 20 mins!

Creating Reports with Proc Report!

  • Introduction to Proc Report - Variable Usages
  • Learn to Create Detail Report Using the Display and Order Usage
  • Learn to Create Summary Reports using the GROUP Usage and Add Statistics
  • Learn to Transpose a Variable with the Across Usage
  • Learn how to create a variable in a Report using the Computed Usage

Similar Courses

Programming in SAS for Beginners

Udemy

Online
Beginner
₹449 ₹3,499

Getting Started with SAS Programming

SAS Institute via Coursera

Online
Beginner

Courses of your Interest

Professional Certificate Course in Data Science

Professional Certificate Course in Data Science

Newton School

8 Months Online
Beginner

JavaScript Foundations

PW Skills

Online
Beginner
Free

Technical Analysis Series

PW Skills

3 Months Online
Beginner
Free

C Programming Foundations

PW Skills

Online
Beginner
Free

Cracking the Coding Interview in Java Foundation

PW Skills

5 Months Online
Beginner
Free

Python Foundations

PW Skills

Online
Beginner
Free
Getting Started with Generative AI APIs

Getting Started with Generative AI APIs

Codio via Coursera

3 Weeks Online
Beginner
Generating code with ChatGPT API

Generating code with ChatGPT API

Codio via Coursera

3 Weeks Online
Beginner
Prompt Engineering for ChatGPT

Prompt Engineering for ChatGPT

Vanderbilt via Coursera

Online
Beginner

Data Structures and Algorithms in Java

Great Learning

Online
Beginner
Free

More Courses by Udemy

Microsoft Excel 2013 Course Beginners Intermediate...

Udemy

Online
Beginner
₹399 ₹2,699

Python for Beginners to Advance

Udemy

Online
Beginner
₹ 2,499

Learn Python Turtle Using Block Coding

Udemy

Online
Beginner
₹399 ₹799

Master Python Basics For Developer

Udemy

Online
Beginner
₹475 ₹3,499

Programming in Python for Beginners

Udemy

Online
Beginner
₹ 799

Learn Python 3 Programming from Scratch

Udemy

Online
Beginner
₹475 ₹1,299

Automate Your Life With Python

Udemy

Online
Beginner
₹ 2,899

Learn Python Python for Beginners

Udemy

Online
Beginner
₹ 1,799

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books