Proc SQL offers users the option of deleting, altering, and updating records. Along with looking at examples of how to do this in Proc SQL, we will also talk about alternatives that are available in SAS. We will use our 36 million record dataset to also try to understand the time that was taken to complete these tasks. Although the number of records is high, please beware that it is a long table, not a wide one. In practice, tables will be wider, and the time that it would take to process a typical table with such a structure may be longer.
-
Book Overview & Buying
-
Table Of Contents
Hands-On SAS for Data Analysis
By :
Hands-On SAS for Data Analysis
By:
Overview of this book
SAS is one of the leading enterprise tools in the world today when it comes to data management and analysis. It enables the fast and easy processing of data and helps you gain valuable business insights for effective decision-making. This book will serve as a comprehensive guide that will prepare you for the SAS certification exam.
After a quick overview of the SAS architecture and components, the book will take you through the different approaches to importing and reading data from different sources using SAS. You will then cover SAS Base and 4GL, understanding data management and analysis, along with exploring SAS functions for data manipulation and transformation. Next, you'll discover SQL procedures and get up to speed on creating and validating queries. In the concluding chapters, you'll learn all about data visualization, right from creating bar charts and sample geographic maps through to assigning patterns and formats. In addition to this, the book will focus on macro programming and its advanced aspects.
By the end of this book, you will be well versed in SAS programming and have the skills you need to easily handle and manage your data-related problems in SAS.
Table of Contents (17 chapters)
Preface
Introduction to SAS Programming
Data Manipulation and Transformation
Section 2: Merging, Optimizing, and Descriptive Statistics
Combining, Indexing, Encryption, and Compression Techniques Simplified
Power of Statistics, Reporting, Transforming Procedures, and Functions
Section 3: Advanced Programming
Advanced Programming Techniques - SAS Macros
Powerful Functions, Options, and Automatic Variables Simplified
Section 4: SQL in SAS
Advanced Programming Techniques Using PROC SQL
Deep Dive into PROC SQL
Section 5: Data Visualization and Reporting
Data Visualization
Reporting and Output Delivery System
Other Books You May Enjoy
