The Simplest Guide™ to SAS Programming | Base SAS | Advanced SAS [Video]
Video
Video
$119.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
What do you get with video?
What do you get with video?
What do you get with Audiobook?
What do you get with Exam Trainer?
Video
$119.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Access this title in our online reader
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with video?
Stream this video
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
What do you get with Exam Trainer?
Flashcards, Mock exams, Exam Tips, Practice Questions
Access these resources with our interactive certification platform
Mobile compatible-Practice whenever, wherever, however you want
-
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