The Simplest Guide to SAS Programming | SAS Base | SAS Advanced
A visual and immersive guide, down to just 4 main areas - Data Preparation, Data Structuring, Data Visualization and Optimizing Code
Watch Promo
A comprehensive, visual and immersive guide to SAS Programming, this course is simplified into the 4 main areas : Data Preparation, Data Structuring, Data Visualization and Optimizing Code
- This course is for absolute beginners as well as advanced users who wish to learn SAS Programming
- Delivered in a highly visual style, you will experience a unique and immersive method of the lectures
- Equips you with the cutting-edge tool used in many industries, primarily in Pharma, Finance and Insurance areas
- Broken down to just 4 main areas, this course is an accelerated path to learning SAS programming
COURSE SECTIONS
- 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 side-ways (transposing)
- DATA VISUALIZATION will propel you further into the world of analytics and obtaining insightful inferences from what is inside your data
- OPTIMIZING CODE will take into the world of macro programming that teaches you how to write your code professionally and elegantly
Your Instructor
Hello, I am Aslam Khan. I work as a Project Manager at a large pharmaceutical company based in the USA. I have extensive experience in implementing end-to-end software solutions for the Life Science industry, change management, program benefits realization and organizational project management. I have also worked in the Clinical Data Management, Biostatistics and SAS Programming areas of the Life Science industry in the last 12 years, and am a certified Base and Advanced SAS Programmer. My other interests include solving challenging business problems through cognitive tools, and teaching impact-fully students and professionals through innovative visual tools. I have a Master’s degree in Management Information Systems, and am a certified Project Management Professional (PMP).
Course Curriculum
-
PreviewPreparing Data - introduction (0:05)
-
PreviewSAS Datasets, Variables and Observations (8:44)
-
StartSAS Libraries (4:50)
-
StartLibrary Naming Conventions (4:48)
-
StartDataset Naming Conventions (4:05)
-
StartSAS Program Syntax (6:57)
-
StartData Step and Proc Step (2:47)
-
StartReferencing Data in SAS (4:47)
-
StartBringing data into SAS (16:01)
-
StartBringing data into SAS using FILENAME statement (5:09)
-
StartBringing data into SAS using LIBNAME statement (5:21)
-
StartBringing data into SAS using DELIMITER option (3:19)
-
StartBringing data into SAS using DSD option (7:36)
-
StartBringing data into SAS using COLUMN input (4:02)
-
StartBringing data into SAS using COLUMN pointer @ symbol (1:53)
-
StartBringing data into SAS using LINE pointer # symbol (7:10)
-
StartBringing data into SAS using LINE pointer slash symbol (2:24)
-
StartBringing data into SAS using the Trailing @ symbol (3:09)
-
StartBringing data into SAS using the Trailing double @ symbol (2:26)
-
StartCreating new variables
-
StartIf-else conditional statements
-
StartFiltering Data
-
StartSAS Dates (6:48)
-
StartSAS Functions - Upcase, Lowcase, Propcase, Length, Cat (22:12)
-
StartSAS Functions - Substr, Trim, Left, Strip, Compress, Compbl (17:16)
-
StartSAS Formats - introduction (3:37)
-
StartSAS Format statement (6:35)
-
StartFormat Naming Convention (10:26)
-
StartFormat using Put function
-
StartProc Format
-
StartSAS Informats
-
StartProgram Data Vector (PDV)
-
StartPDV Implicit Output (14:34)
-
StartPDV Explicit Output