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

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