The Simplest Guide™ to SAS Programming | Base SAS | Advanced SAS

Video description

A comprehensive, simple, and visual guide to data analysis using SAS programming, this course is simplified into 4 main areas: data preparation, data structuring, data visualization, and optimizing code using powerful SAS macros.

About This Video

  • A guide to the two SAS certification exams: SAS Base and SAS Advanced
  • This course uses the SAS OnDemand for Academics Edition that is free to be used on a PC or Mac
  • Quiz and practice tests after each section are included

In Detail

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 the cutting-edge tool used in many industries, primarily in pharma, finance, and insurance areas.

Simplified into just 4 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.

Who this book is for

This course is designed for individuals looking to quickly acquire data manipulation and data analytics skills in order to get placed in job roles that involve a lot of data processing, or as part of data science university coursework, or to pass the Base SAS or Advanced SAS certification. No prior experience is required. This course uses SAS OnDemand for Academics Edition as the software tool to work with data.

Publisher resources

Download Example Code

Table of contents

  1. Chapter 1 : Why Learn SAS
    1. Course Overview
  2. Chapter 2 : Getting Started with SAS Programming
    1. Why is SAS so Easy to Learn
    2. SAS Studio through SAS OnDemand - Registration
    3. Logging In to a SAS Session after Installation
    4. SAS User Interface
  3. Chapter 3 : Preparing Data
    1. Section Overview
    2. SAS Dataset, Variables, and Observations
    3. SAS Libraries
    4. Library Naming Conventions
    5. Dataset Naming Conventions
    6. SAS Program Syntax
    7. SAS Data Step and Proc Step
    8. Referencing Data in SAS
    9. Bringing Data into SAS
    10. Bringing Data into SAS Using the Import Wizard
    11. Bringing Data into SAS Using the LIBNAME Statement
    12. Bringing Data into SAS Using the FILENAME Statement
    13. Bringing Data into SAS Using the DELIMITER Option
    14. Bringing Data into SAS Using the DSD Option
    15. Bringing Data into SAS Using Column Input
    16. Bringing Data into SAS Using Column Pointer @ Symbol
    17. Bringing Data into SAS Using the Line Pointer # Symbol
    18. Bringing Data into SAS Using Line Pointer Slash Symbol
    19. Bringing Data into SAS Using the Trailing @ Symbol
    20. Bringing Data into SAS Using the Trailing Double @ Symbol
    21. Bringing Data into SAS Using Proc Import for XLS (MS Excel) Files
    22. Bringing Data into SAS Using Proc Import for TXT Files
    23. Creating New Variables
    24. Creating New Variables - Code
    25. Keeping, Dropping, and Renaming Variables in a Dataset
    26. If-else Conditional Statements - Deriving BMI Variable
    27. If-else Conditional Statements - Deriving STATUS Variable
    28. Filtering Data
    29. SAS Dates
    30. SAS Functions - Upcase
    31. SAS Functions - Lowcase, Propcase, Len, Cat
    32. SAS Functions - Substr
    33. SAS Functions - Trim, Left, Strip, Compress, Compbl
    34. SAS Formats - Introduction
    35. Format Statement
    36. Format Naming Conventions
    37. Format Using the PUT Function
    38. SAS Informats
    39. SAS Informats - Code
    40. Custom Formats Using Proc Format
    41. Custom Formats Using Proc Format - Code
    42. Program Data Vector (PDV)
    43. Implicit Output- Descriptor Portion
    44. Implicit Output - var and Data Portion
    45. Explicit Output
    46. Explicit Output - Code
    47. Do Loops
    48. Guided Exercise – ‘Project Cars’ - Introduction
    49. Section Conclusion
  4. Chapter 4 : Structuring Data
    1. Section Overview
    2. Stacking Data Using a Data Step
    3. Stacking Data Using Proc Append
    4. Stacking Data Using Proc Append - Code
    5. Interleaving of Data
    6. Sorting Data Using Proc SortT
    7. Sorting Data Using Proc Sort - Multi-Level Sorting
    8. Removing Duplicates - NODUP Option
    9. Removing Duplicates - NODUPKEY Option
    10. Simple Merging of Data
    11. Merging Data Using Joins - Introduction
    12. Merging Data Using Inner Join
    13. Merging Data Using Inner Join - Code
    14. Merging Data Using Full Join.
    15. Merging Data Using Left Join
    16. Merging Data Using Right Join
    17. Merging Data Using ‘Far’ Joins
    18. PROC SQL - Copying Data
    19. Proc SQL - Copying Data - Code
    20. Proc SQL - Filtering Data
    21. Proc SQL - Sorting Data
    22. Proc SQL - Removing Duplicates
    23. Transposing Data - ID Statement
    24. Transposing Data - ID Statement - Code
    25. Transposing Data - BY Statement
    26. Transposing Data - BY Statement - Code
    27. Retain Statement - Introduction
    28. Retain Statement - How to Use
    29. Retain Statement - Example
    30. Section Conclusion
  5. Chapter 5 : Visualizing Data
    1. Section Overview
    2. Charts - Introduction - Vertical Bar Chart
    3. Charts - Horizontal Bar and Pie Charts
    4. Vertical Bar Chart - DISCRETE Option
    5. Horizontal Bar Chart - DISCRETE Option
    6. Vertical Bar Chart - Groups and Subgroups
    7. Horizontal Bar Chart - Groups and Subgroups
    8. Plots
    9. Report Output Using Proc Print
    10. Report Output Using Proc Report - DISPLAY Option
    11. Report Output Using Proc Report - ORDER and GROUP Option
    12. Summary Statistics - Proc Freq
    13. Summary Statistics - Proc Means
    14. Summary Statistics - Proc Univariate
    15. Output Delivery System (ODS) - Report Formats
    16. ODS with Proc Freq
    17. ODS with Proc Means
    18. ODS with Proc Univariate
    19. Section Conclusion
  6. Chapter 6 : Optimizing Code
    1. Section Overview
    2. Macro Variables - Introduction
    3. Macro Variables - Introduction - Code
    4. Application of Macro Variables
    5. Application of Macro Variables - Code
    6. Nested Macro Variables and Ampersand Resolutions
    7. More on Ampersand Resolutions Using a Cool Example
    8. SAS Macros - Introduction
    9. SAS Macros - Examples
    10. Macro Functions
    11. Macro Functions - Code
    12. Optimizing Code - Section Conclusion
  7. Chapter 7 : Practice Exercise | Case Study
    1. Guided Exercise – ‘Project Heavy-weight’ - Introduction to the Project and Data

Product information

  • Title: The Simplest Guide™ to SAS Programming | Base SAS | Advanced SAS
  • Author(s): Aslam Khan
  • Release date: February 2021
  • Publisher(s): Packt Publishing
  • ISBN: 9781801077293