![The Simplest Guide™ to SAS Programming | Base SAS | Advanced SAS [Video]](https://content.packt.com/V17307/cover_image_small.jpg)
The Simplest Guide™ to SAS Programming | Base SAS | Advanced SAS [Video]
Subscription
FREE
Video + Subscription
$29.99
Video
$119.99
What do you get with a Packt Subscription?
What do you get with a Packt Subscription?
What do you get with Video + Subscription?
What do you get with a Packt Subscription?
What do you get with eBook?
What do I get with Print?
What do I get with Print?
What do you get with video?
What do you get with Audiobook?
Subscription
FREE
Video + Subscription
$29.99
Video
$119.99
What do you get with a Packt Subscription?
What do you get with a Packt Subscription?
What do you get with Video + Subscription?
What do you get with a Packt Subscription?
What do you get with eBook?
What do I get with Print?
What do I get with Print?
What do you get with video?
What do you get with Audiobook?
-
Free ChapterWhy Learn SAS
-
Getting Started with SAS Programming
-
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
- Bringing Data into SAS
- Bringing 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 Using the DELIMITER Option
- Bringing Data into SAS Using the 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 Using Proc Import for XLS (MS Excel) Files
- Bringing Data into SAS Using Proc Import for TXT Files
- Creating New Variables
- Creating New Variables - Code
- Keeping, Dropping, and Renaming Variables in a Dataset
- If-else Conditional Statements - Deriving BMI Variable
- If-else Conditional Statements - Deriving STATUS Variable
- Filtering Data
- SAS Dates
- SAS Functions - Upcase
- SAS Functions - Lowcase, Propcase, Len, Cat
- SAS Functions - Substr
- SAS Functions - Trim, Left, Strip, Compress, Compbl
- SAS Character Functions - Scan Function
- SAS Character Functions - Index Function
- SAS Numeric Functions - Sum Function
- Null Dataset
- SAS Numeric Functions - Abs Function
- SAS Numeric Functions - Ceiling, Floor, and Integer Functions
- SAS Numeric Functions - Minimum and Maximum 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
- Program Data Vector (PDV)
- Implicit Output- Descriptor Portion
- Implicit Output - var and Data Portion
- Explicit Output
- Explicit Output - Code
- Do Loops
- Guided Exercise – 'Project Cars' - Introduction
- Section Conclusion
-
Structuring Data
- Section Overview
- Stacking Data Using a Data Step
- Stacking Data Using Proc Append
- Stacking Data Using Proc Append - Code
- Interleaving of Data
- Sorting Data Using Proc SortT
- Sorting Data Using Proc Sort - Multi-Level Sorting
- Removing Duplicates - NODUP Option
- Removing Duplicates - NODUPKEY Option
- 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
- PROC SQL - Copying Data
- Proc SQL - Copying Data - Code
- Proc SQL - Filtering Data
- Proc SQL - Sorting Data
- Proc SQL - Removing Duplicates
- Transposing Data - ID Statement
- Transposing Data - ID Statement - Code
- Transposing Data - BY Statement
- Transposing Data - BY Statement - Code
- Retain Statement - Introduction
- Retain Statement - How to Use
- Retain Statement - Example
- Section Conclusion
-
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
- Report Output Using Proc Print
- Report Output Using Proc Report - DISPLAY Option
- Report Output Using Proc Report - ORDER and GROUP Option
- Summary Statistics - Proc Freq
- Summary Statistics - Proc Means
- Summary Statistics - Proc Univariate
- Output Delivery System (ODS) - Report Formats
- ODS with Proc Freq
- ODS with Proc Means
- ODS with Proc Univariate
- Section Conclusion
-
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
- SAS Macros - Introduction
- SAS Macros - Examples
- Macro Functions
- Macro Functions - Code
- Optimizing Code - Section Conclusion
-
Practice Exercise | Case Study
About this video
This course is for absolute beginners as well as advanced users who wish to learn SAS programming. Delivered in a highly visual style, these immersive lectures will equip you with cutting-edge tools used in many industries, primarily in pharma, finance, and insurance areas.
Simplified into just four main areas, this course is an accelerated path to learning SAS programming. Data preparation will teach you how to import data from multiple sources, create new variables, write SAS functions, and understand what goes on behind the scenes in SAS datasets. Data structuring will make you leap into transforming data to a new level by merging and joining multiple datasets together, or turning them upside-down (sorting) and sideways (transposing). Data visualization will propel you further into the world of analytics and obtain insightful inferences from what is inside your data.
The final section will take you into the world of macro programming that teaches you how to write your code professionally and elegantly.
At the end of the course, you will try out most concepts discussed in this course through a coding exercise that will take you through these sections in preparation for your own SAS certification.
The code files and all related files are uploaded on GitHub at https://github.com/PacktPublishing/The-Simplest-Guide-to-SAS-Programming-Base-SAS-Advanced-SAS-
- Publication date:
- February 2021
- Publisher
- Packt
- Duration
- 11 hours 43 minutes
- ISBN
- 9781801077293