Brochure
Enquire
- Course Overview
The Simplest Guide to SAS Programming- SAS Base-SAS Advanced
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
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 !!!)
Articles
Popular Articles
prev
next
Latest Articles
Similar Courses
Courses of your Interest
Professional Certificate Course in Data Science
Newton School
JavaScript Foundations
PW Skills
Technical Analysis Series
PW Skills
C Programming Foundations
PW Skills
Python Foundations
PW Skills
Getting Started with Generative AI APIs
Codio via Coursera
Generating code with ChatGPT API
Codio via Coursera
Prompt Engineering for ChatGPT
Vanderbilt via Coursera
prev
next
More Courses by Udemy
prev
next
