SAS Data-Driven Development


Book Description

SAS(R) Data-Driven Development is the only comprehensive text that demonstrates how to build dynamic SAS software driven by control data. Data-driven design enables developers to create flexible, reusable software that adapts to diverse industries, organizations, and data sources because business rules, data mappings, formatting, report style, program logic, and other dynamic elements are maintained as external control data — not as static code. Data-driven design is the key to unlocking highly configurable, "codeless" software that developers, SAS administrators, end users, and other stakeholders can reuse and configure — without modifying one line of code! This text introduces high-level design concepts, patterns, and principles, after which real-world scenarios demonstrate SAS development best practices: Part I. Data-Driven Design: Learn how to harness procedural abstraction, data abstraction, iteration abstraction, software modularity, and data independence, with concepts drawn from object-oriented programming (OOP), master data management (MDM), table-driven design, and business rules engines. Part II. Control Data: Understand the limitless data structures that can drive SAS software, including parameters, configuration files, control tables, decision tables, SAS data sets, SAS arrays, and CSV, Excel, XML, and CSS files. Interoperability is modeled through control data that can be accessed by SAS and other applications. Throughout the text, requirements-based examples demonstrate data analysis, data modeling, data mapping, data governance, dynamic "traffic light" reporting, and other use cases. Examples contrast concrete, code-driven design with abstract, data-driven design to illustrate the clear advantages of the latter. Application of the SAS Macro Language often signifies the first milestone in a SAS practitioner's career — because macros facilitate flexible, reusable software. Data-driven design represents the next milestone and this text provides the guidebook for that incredible journey. Start your journey today!




SAS Programming for R Users


Book Description

SAS Programming for R Users, based on the free SAS Education course of the same name, is designed for experienced R users who want to transfer their programming skills to SAS. Emphasis is on programming and not statistical theory or interpretation. You will learn how to write programs in SAS that replicate familiar functions and capabilities in R. This book covers a wide range of topics including the basics of the SAS programming language, how to import data, how to create new variables, random number generation, linear modeling, Interactive Matrix Language (IML), and many other SAS procedures. This book also explains how to write R code directly in the SAS code editor for seamless integration between the two tools. Exercises are provided at the end of each chapter so that you can test your knowledge and practice your programming skills.




PROC SQL


Book Description

PROC SQL: Beyond the Basics Using SAS®, Third Edition, is a step-by-step, example-driven guide that helps readers master the language of PROC SQL. Packed with analysis and examples illustrating an assortment of PROC SQL options, statements, and clauses, this book not only covers all the basics, but it also offers extensive guidance on complex topics such as set operators and correlated subqueries. Programmers at all levels will appreciate Kirk Lafler’s easy-to-follow examples, clear explanations, and handy tips to extend their knowledge of PROC SQL. This third edition explores new and powerful features in SAS® 9.4, including topics such as: IFC and IFN functions nearest neighbor processing the HAVING clause indexes It also features two completely new chapters on fuzzy matching and data-driven programming. Delving into the workings of PROC SQL with greater analysis and discussion, PROC SQL: Beyond the Basics Using SAS®, Third Edition, explores this powerful database language using discussion and numerous real-world examples.




Exploring SAS Viya


Book Description

This first book in the series covers how to access data files, libraries, and existing code in SAS Studio. You also learn about new procedures in SAS Viya, how to write new code, and how to use some of the pre-installed tasks that come with SAS Visual Data Mining and Machine Learning. In the last chapter, you learn how to use the features in SAS Data Preparation to perform data management tasks using SAS Data Explorer, SAS Data Studio, and SAS Lineage Viewer. Also available free as a PDF from sas.com/books.




Fundamentals of Programming in SAS


Book Description

Unlock the essentials of SAS programming! Fundamentals of Programming in SAS: A Case Studies Approach gives a complete introduction to SAS programming. Perfect for students, novice SAS users, and programmers studying for their Base SAS certification, this book covers all the basics, including: working with data creating visualizations data validation good programming practices Experienced programmers know that real-world scenarios require practical solutions. Designed for use in the classroom and for self-guided learners, this book takes a novel approach to learning SAS programming by following a single case study throughout the text and circling back to previous concepts to reinforce material. Readers will benefit from the variety of exercises, including both multiple choice questions and in-depth case studies. Additional case studies are also provided online for extra practice. This approach mirrors the way good SAS programmers develop their skills—through hands-on work with an eye toward developing the knowledge necessary to tackle more difficult tasks. After reading this book, you will gain the skills and confidence to take on larger challenges with the power of SAS.




Text as Data


Book Description

Text As Data: Combining qualitative and quantitative algorithms within the SAS system for accurate, effective and understandable text analytics The need for powerful, accurate and increasingly automatic text analysis software in modern information technology has dramatically increased. Fields as diverse as financial management, fraud and cybercrime prevention, Pharmaceutical R&D, social media marketing, customer care, and health services are implementing more comprehensive text-inclusive, analytics strategies. Text as Data: Computational Methods of Understanding Written Expression Using SAS presents an overview of text analytics and the critical role SAS software plays in combining linguistic and quantitative algorithms in the evolution of this dynamic field. Drawing on over two decades of experience in text analytics, authors Barry deVille and Gurpreet Singh Bawa examine the evolution of text mining and cloud-based solutions, and the development of SAS Visual Text Analytics. By integrating quantitative data and textual analysis with advanced computer learning principles, the authors demonstrate the combined advantages of SAS compared to standard approaches, and show how approaching text as qualitative data within a quantitative analytics framework produces more detailed, accurate, and explanatory results. Understand the role of linguistics, machine learning, and multiple data sources in the text analytics workflow Understand how a range of quantitative algorithms and data representations reflect contextual effects to shape meaning and understanding Access online data and code repositories, videos, tutorials, and case studies Learn how SAS extends quantitative algorithms to produce expanded text analytics capabilities Redefine text in terms of data for more accurate analysis This book offers a thorough introduction to the framework and dynamics of text analytics—and the underlying principles at work—and provides an in-depth examination of the interplay between qualitative-linguistic and quantitative, data-driven aspects of data analysis. The treatment begins with a discussion on expression parsing and detection and provides insight into the core principles and practices of text parsing, theme, and topic detection. It includes advanced topics such as contextual effects in numeric and textual data manipulation, fine-tuning text meaning and disambiguation. As the first resource to leverage the power of SAS for text analytics, Text as Data is an essential resource for SAS users and data scientists in any industry or academic application.




Getting Started with SAS Programming


Book Description

Get up and running with SAS using Ron Cody’s easy-to-follow, step-by-step guide. Aimed at beginners, Getting Started with SAS Programming: Using SAS Studio in the Cloud uses short examples to teach SAS programming from the basics to more advanced topics in the point-and-click interactive environment of SAS Studio. To begin, you will learn how to register for SAS OnDemand for Academics, an online delivery platform for teaching and learning statistical analysis that provides free access to SAS software via the cloud. The first part of the book shows you how to use SAS Studio built-in tasks to produce a report, summarize data, and create charts and graphs. It also describes how you can perform basic statistical tests using the interactive point-and-click environment. The second part of the book uses easy-to-follow examples to show you how to write your own SAS programs and how to use SAS procedures to perform a variety of tasks. This part of the book also explains how to read data from a variety of sources: text files, Excel workbooks, and CSV files. In order to get familiar with the SAS Studio environment, this book also shows you how to access dozens of interesting data sets that are included with the SAS OnDemand for Academics platform.




Exploring SAS Viya


Book Description

SAS Visual Data Mining and Machine Learning, powered by SAS Viya, means that users of all skill levels can visually explore data on their own while drawing on powerful in-memory technologies for faster analytic computations and discoveries. You can manually program with custom code or use the features in SAS Studio, Model Studio, and SAS Visual Analytics to automate your data manipulation and modeling. These programs offer a flexible, easy-to-use, self-service environment that can scale on an enterprise-wide level. In this book, we will explore some of the many features of SAS Visual Data Mining and Machine Learning including: programming in the Python interface; new, advanced data mining and machine learning procedures; pipeline building in Model Studio, and model building and comparison in SAS Visual Analytics.




Exploring SAS Viya


Book Description

Data visualization enables decision makers to see analytics presented visually so that they can grasp difficult concepts or identify new patterns. SAS offers several solutions for visualizing your data, many of which are powered by SAS Viya. This book includes four visualization solutions powered by SAS Viya: SAS Visual Analytics, SAS Visual Statistics, SAS Visual Text Analytics, and SAS Visual Investigator. SAS visualization software is designed for anyone in your organization who wants to use and derive insights from data-from influencers, decision makers, and analysts to statisticians and data scientists. Also available as a free e-book from sas.com/books.




Mastering SAS Programming for Data Warehousing


Book Description

Build a strong foundation in SAS data warehousing by understanding data transformation code and policy, data stewardship and management, interconnectivity between SAS and other warehousing products, and print and web reporting Key FeaturesUnderstand how to use SAS macros for standardizing extract, transform, and load (ETL) protocolsDevelop and use data curation files for effective warehouse managementLearn how to develop and manage ETL, policies, and print and web reports that meet user needsBook Description SAS is used for various functions in the development and maintenance of data warehouses, thanks to its reputation of being able to handle ’big data’. This book will help you learn the pros and cons of storing data in SAS. As you progress, you’ll understand how to document and design extract-transform-load (ETL) protocols for SAS processes. Later, you’ll focus on how the use of SAS arrays and macros can help standardize ETL. The book will also help you examine approaches for serving up data using SAS and explore how connecting SAS to other systems can enhance the data warehouse user’s experience. By the end of this data management book, you will have a fundamental understanding of the roles SAS can play in a warehouse environment, and be able to choose wisely when designing your data warehousing processes involving SAS. What you will learnDevelop efficient ways to manage data input/output (I/O) in SASCreate and manage extract, transform, and load (ETL) code in SASStandardize ETL through macro variables, macros, and arraysIdentify data warehouse users and ensure their needs are metDesign crosswalk and other variables to serve analyst needsMaintain data curation files to improve communication and managementUse the output delivery system (ODS) for print and web reportingConnect other products to SAS to optimize storage and reportingWho this book is for This book is for data architects, managers leading data projects, and programmers or developers using SAS who want to effectively maintain a data lake, data mart, or data warehouse.