by Ekta Saraogi | Released April 2019 | ISBN: 9781838824921

Learn and master the skills required for SAS proficiency and SAS Base certification, including SQL procedures and macrosAbout This VideoCoverage of the technical and analytical concepts of SAS, from beginner to expert levelLearn the fundamental principles and benefits of SAS to perform tasks ranging from data exploration to data manipulation and report generationUnderstand advanced concepts such as macro programming and running SQL queries in SASIn DetailAre you looking to become a data analyst or data scientist? If so, there are various tools and techniques to implement data analytics, but SAS offers many benefits as your first programming language to master: it's easy to learn and has a user-friendly GUI. To date, it holds the highest market share of all the analytics tools available. If you have little or no programming background and want to get started with SAS, then this is the right course for you!This course will help you become a confident and proficient data analyst and SAS programmer by giving you the hands-on knowledge and in-depth understanding of the SAS programming suite and how to utilize it effectively. Additionally, it will help you master different techniques in SAS to manipulate your data. You'll learn how to work with SQL queries and generate effective data reports. Moreover, this course will provide all the content you're looking for to prepare for the SAS Base certification exam.By the end of this course, you'll have a thorough understanding of the fundamental SAS concepts, along with rich hands-on experience of the SAS suite.Downloading the example code for this course: You can download the example code files for this course on GitHub at the following link: https://github.com/PacktPublishing/SAS-in-Practice. If you require support please email: [email protected] Show and hide more

1. Chapter 1 : Introduction to SAS
   • The Course Overview 00:05:29
   • Data Analytics and SAS 00:06:58
   • Installation of SAS 00:06:22
   • SAS Console 00:04:37
   • Create Temporary and Permanent Libraries 00:10:58
   • Import and Export Data in SAS 00:07:25
2. Chapter 2 : Combining and Merging Datasets
   • Why Combine or Merge Data? 00:16:15
   • Interleaving 00:09:22
   • One-to-One Merging 00:05:48
3. Chapter 3 : Data Manipulation – Using DATA Step
   • What is Data Manipulation? 00:03:08
   • Delete and Group Observations 00:08:32
   • DO and END Statements 00:03:54
   • Modify Variable attributes 00:06:39
   • Use the BY statement to aggregate by Subgroups 00:07:33
4. Chapter 4 : Working with SAS Functions
   • SAS Functions 00:10:43
   • SAS Numeric Functions 00:08:36
   • Extract the Month, Year, and Interval from A SAS Date Value 00:11:55
5. Chapter 5 : Validate and Clean Data with SAS Functions and PROC procedures
   • SAS Automatic Data Type Conversions 00:09:11
   • SAS Statistical Procedures 00:08:22
   • PROC FREQ 00:05:47
   • PROC UNIVARIATE 00:04:28
6. Chapter 6 : Report Generation
   • Generate List Reports using PROC PRINT 00:09:13
   • Generate Summary Reports 00:09:44
   • Generate Reports using ODS Statements 00:11:49
7. Chapter 7 : Error Handling
   • Types of Errors 00:03:32
   • Recognize and correct Syntax errors 00:10:18
   • Identify and Resolve Programming Logic errors 00:08:17
   • Examine and Resolve Data errors 00:06:07
8. Chapter 8 : Introduction to SQL and Macros
   • Introduction to SQL 00:03:02
   • PROC SQL and clauses 00:09:09
   • Introduction to SAS Macros 00:01:56
   • Automatic and User-Defined Variables 00:09:39
   • Macro Statements 00:06:13
Show and hide more