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

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

by Aslam Khan
Released February 2021
Publisher(s): Packt Publishing
ISBN: 9781801077293

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

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.

What You Will Learn

  • Perform data analysis with the powerful SAS programming language
  • Import any type of data into SAS and construct meaningful reports
  • Analyze data with SAS that reveal amazing insights within your data
  • Create beautiful visualizations and reports for a better understanding
  • Strengthen your foundation for SAS base and advanced certification exams
  • Apply all topics learned and finish the ‘Project Heavyweight’ exercise

Audience

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.

About The Author

Aslam Khan: Aslam Khan works with businesses in understanding their complex problems, surfacing their business needs and offering viable technical solutions, overseeing change management, program benefits realization, and organizational project management. He has also worked in the clinical data management, biostatistics, and SAS programming areas of the life sciences industry.

He is a certified Project Management Professional (PMP) and a SAS Base and Advanced Certified Programmer, with a master’s degree in management information systems.

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 Character Functions - Scan Function
    35. SAS Character Functions - Index Function
    36. SAS Numeric Functions - Sum Function
    37. Null Dataset
    38. SAS Numeric Functions - Abs Function
    39. SAS Numeric Functions - Ceiling, Floor, and Integer Functions
    40. SAS Numeric Functions - Minimum and Maximum Functions
    41. SAS Formats - Introduction
    42. Format Statement
    43. Format Naming Conventions
    44. Format Using the PUT Function
    45. SAS Informats
    46. SAS Informats - Code
    47. Custom Formats Using Proc Format
    48. Custom Formats Using Proc Format - Code
    49. Program Data Vector (PDV)
    50. Implicit Output- Descriptor Portion
    51. Implicit Output - var and Data Portion
    52. Explicit Output
    53. Explicit Output - Code
    54. Do Loops
    55. Guided Exercise – 'Project Cars' - Introduction
    56. 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 Heavyweight' - 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