The Simplest Guide to SAS Programming- SAS Base-SAS Advanced

BY
Udemy

Lavel

Beginner

Mode

Online

Fees

₹ 3099

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
₹ 3,099
certificate availability

Yes

certificate providing authority

Udemy

The syllabus

Why learn SAS | Course Introduction and Overview

  • Course Overview

Getting started with SAS Programming

  • Why is SAS so easy to learn
  • SAS Studio through SAS OnDemand - Registration
  • Logging-in to a SAS Session
  • SAS User Interface
  • SAS user interface/ windowing environment

Preparing Data

  • Preparing Data - Section Overview
  • SAS Dataset, Variables and Observations
  • SAS Libraries
  • Library Naming Conventions
  • Dataset Naming Conventions
  • SAS Program Syntax
  • SAS Data Step and Proc Step
  • Referencing data in SAS
  • SAS Elements
  • Bringing data into SAS
  • Brinding data into SAS using the Import Wizard
  • Bringing data into SAS using the LIBNAME statement
  • Bringing data into SAS using the FILENAME statement
  • Bringing data into SAS
  • Bringing data into SAS
  • Bringing data into SAS using DELIMITER option
  • Bringing data into SAS using Delimiter option
  • Bringing data into SAS using DSD option
  • Bringing data into SAS using column input
  • Bringing data into SAS using column pointer @ symbol
  • Bringing data into SAS using the line pointer # symbol
  • Bringing data into SAS using line pointer slash symbol
  • Bringing data into SAS using the trailing @ symbol
  • Bringing data into SAS using the trailing double @ symbol
  • Bringing data into SAS - Advanced Methods
  • Bringing data into SAS using advanced options
  • Bringing data into SAS using Proc Import for XLS (MS Excel) Files
  • Bringing data into SAS using Proc Import for TXT Files
  • Bringing data into SAS using Import procedure
  • Get "berries" data into your SAS session
  • Creating new variables
  • Creating new variables - code
  • Keeping, Dropping and Renaming Variables in a Dataset
  • Conditional logic and filtering data
  • If-else conditional statements - deriving BMI variable
  • If-else conditional statements - deriving STATUS variable
  • Filtering data
  • New variables, conditional logic
  • Finding the most expensive cars
  • SAS Dates
  • SAS Functions - Upcase
  • SAS Functions - Lowcase, Propcase, Len, Cat
  • SAS Functions - Substr
  • SAS Functions -Trim, Left, Strip, Compress, Compbl
  • SAS Dates And SAS Functions
  • Applying SAS Functions
  • SAS Formats - Introduction
  • Format Statement
  • Format Naming Conventions
  • Format using the PUT function
  • SAS Informats
  • SAS Informats - code
  • Custom formats using Proc Format
  • Custom formats using Proc Format - code
  • Formats in SAS
  • Applying SAS formats
  • Program Data Vector (PDV)
  • Implicit Output- Descriptor portion
  • Implicit Output - var and data portion
  • Explicit Output
  • Explicit Output - code
  • Do Loops
  • Behind the scenes
  • Using explicit output statement
  • Preparing data
  • Guided Exercise - "Project Cars" - Introduction
  • Guided Exercise - "Project Cars" - Exercise 1
  • Secret SAS Proc revealed !
  • Preparing data - Section Conclusion

Structuring Data

  • Structuring Data - Section Overview
  • Stacking Data using a Data Step
  • Stacking Data using PROC APPEND
  • Stacking Data using PROC APPEND- code
  • Interleaving of data
  • Stacking of data
  • Sorting Data using PROC SORT
  • Sorting Data using PROC SORT - multi-level sorting
  • Interleaving Data
  • Removing duplicates -NODUP Option
  • Removing duplicates -NODUPKEY Option
  • Sorting data
  • Removing Duplicates
  • Simple merging of data
  • Merging data using Joins - Introduction
  • Merging data using Inner Join
  • Merging data using Inner join - code
  • Merging data using Full Join
  • Merging data using Left Join
  • Merging data using Right Join
  • Merging data using "far" joins
  • Merging data
  • Merging of data
  • PROC SQL - copying data
  • Proc SQL - copying data - code
  • PROC SQL - filtering data
  • PROC SQL - sorting data
  • PROC SQL - removing duplicates
  • Proc SQL
  • Proc SQL
  • Transposing data - ID Statement
  • Transposing data - ID Statement - code
  • Transposing data - BY statement
  • Transposing data - BY statement - code
  • Transposing Data
  • Transposing of data
  • Retain Statement - Introduction
  • Retain Statement - how to use
  • Retain Statement - Example
  • Retain statement
  • Structuring data
  • Guided Exercise - "Project Cars" - Exercise 2
  • Structuring data - Section Conclusion

Visualizing Data

  • Visualizing Data - Section Overview
  • Charts - Introduction - Vertical Bar Chart
  • Charts - Horizontal Bar and Pie Charts
  • Vertical bar chart - DISCRETE option
  • Horizontal bar chart - DISCRETE option
  • Vertical bar chart - groups and subgroups
  • Horizontal bar chart - groups and subgroups
  • Plots
  • Charts - advanced options
  • Report Output using PROC PRINT
  • Report Output using PROC REPORT - DISPLAY option
  • Report Output using PROC REPORT - ORDER & GROUP option
  • Report output
  • Summary statistics - PROC FREQ
  • Summary statistics - PROC MEANS
  • Summary statistics - PROC UNIVARIATE
  • Statistical Report Output
  • Output Delivery System (ODS) - Report Formats
  • ODS with Proc Freq
  • ODS with Proc Means
  • ODS with Proc Univariate
  • Output Delivery System
  • Visualizing Data
  • Guided Exercise - "Project Cars" - Exercise 3
  • Visualizing data - Section Conclusion

Optimizing Code

  • Optimizing Code - Section Overview
  • Macro Variables - introduction
  • Macro Variables - introduction - code
  • Application of Macro variables
  • Application of Macro variables - code
  • Nested macro variables and ampersand resolutions
  • More on Ampersand resolutions using a cool example
  • Macro Variables
  • SAS Macros - introduction
  • SAS Macros - Examples
  • Macro Functions
  • Macro Functions - code
  • SAS Macros
  • Test on Structuring data, visualizing data and macros
  • Guided Exercise - "Project Cars" - Exercise 4
  • Optimizing code - Section Conclusion

Practice Exercise | Case Study

  • Guided Exercise - "Project Heavy-weight" - Introduction to the project and data
  • Guided Exercise - "Project Heavy-weight" - Project 1
  • Guided Exercise - "Project Heavy-weight" - Project 2
  • Guided Exercise - "Project Heavy-weight" - Project 3
  • Project Airlines
  • And one last thing... (bonus !!!)

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