This handbook shows readers how best to manage and manipulate data by using the DATA step in SAS, helping them avoid common problems when creating SAS data sets. The author explains that learning syntax does not solve all problems; rather, a thorough comprehension of SAS processing is needed for successful programming. He also guides readers through a programming task. In most of the examples, the author first presents strategies and steps for solving the problem, then offers a solution, and finally gives a more detailed explanation of the solution.

The SAS® Certified Specialist Prep Guide: Base Programming Using SAS® 9.4 prepares you to take the new SAS 9.4 Base Programming -- Performance-Based Exam. This is the official guide by the SAS Global Certification Program. This prep guide is for both new and experienced SAS users, and it covers all the objectives that are tested on the exam. New in this edition is a workbook whose sample scenarios require you to write code to solve problems and answer questions. Answers for the chapter quizzes and solutions for the sample scenarios in the workbook are included. You will also find links to exam objectives, practice exams, and other resources such as the Base SAS® glossary and a list of practice data sets. Major topics include importing data, creating and modifying SAS data sets, and identifying and correcting both data syntax and programming logic errors. All exam topics are covered in these chapters: Setting Up Practice Data Basic Concepts Accessing Your Data Creating SAS Data Sets Identifying and Correcting SAS Language Errors Creating Reports Understanding DATA Step Processing BY-Group Processing Creating and Managing Variables Combining SAS Data Sets Processing Data with DO Loops SAS Formats and Informats SAS Date, Time, and Datetime Values Using Functions to Manipulate Data Producing Descriptive Statistics Creating Output Practice Programming Scenarios (Workbook)

Providing both a compendium of reusable and adaptable code, and opportunities for deepening your understanding and growing as a SAS programmer, this pragmatic, example-driven reference offers nearly 400 ready-to-use macros, macro functions, and macro tools that enable you to convert SAS code to macros, define macro variables, and more. --

The official guide by the SAS Global Certification Program, SAS Certified Professional Prep Guide: Advanced Programming Using SAS 9.4 prepares you to take the new SAS 9.4 Advanced Programming Performance-Based Exam. New in this edition is a workbook whose sample scenarios require you to write code to solve problems and answer questions. Answers to the chapter quizzes and solutions to the sample scenarios in the workbook are included. You will also find links to exam objectives, practice exams, and other resources such as the Base SAS Glossary and a list of practice data sets. Major topics include SQL processing, SAS macro language processing, and advanced SAS programming techniques. All exam topics are covered in the following chapters: SQL Processing with SAS PROC SQL Fundamentals Creating and Managing Tables Joining Tables Using PROC SQL Joining Tables Using Set Operators Using Subqueries Advanced SQL Techniques SAS Macro Language Processing Creating and Using Macro Variables Storing and Processing Text Working with Macro Programs Advanced Macro Techniques Advanced SAS Programming Techniques Defining and Processing Arrays Processing Data Using Hash Objects Using SAS Utility Procedures Using Advanced Functions Practice Programming Scenarios (Workbook)

Whether you are using SAS Enterprise Guide for the first time, or are looking to expand your skills, this book provides a series of carefully designed tutorials to help you master the basics of the tasks you'll want to do most frequently. --

Carpenter's Guide to Innovative SAS Techniques offers advanced SAS programmers an all-in-one programming reference that includes advanced topics not easily found outside the depths of SAS documentation or more advanced training classes. Art Carpenter has written fifteen chapters of advanced tips and techniques, including topics on data summary, data analysis, and data reporting. Special emphasis is placed on DATA step techniques that solve complex data problems. There are numerous examples that illustrate advanced techniques that take advantage of formats, interface with the macro language, and utilize the Output Delivery System. Additional topics include operating system interfaces, table lookup techniques, and the creation of customized reports.

Although the web and online SAS® communities can provide volumes of information for programmers, these resources are often overwhelming and lack a simple path to guide coding SAS. This reference, however, does provide such a path from a data user’s standpoint vs. seeing things as a code writer. Written by an experienced SAS programmer, this book lets SAS coders easily find explanations and clarification to typical programming problems. This book presents practical real-world data analysis steps encountered by analysts in the field. These steps include the following: Getting to know raw data Understanding variables Getting data into SAS Creating new data variables Performing data manipulations, including sorting, ranking, grouping, subtotal, total, and percentage Statistical testing under a broad range of logical and conditional settings Data visualization Throughout this book, statements and codes are accompanied by thorough annotation. Line-by-line explanations ensure that all terms are clearly explained. Code examples and sample codes have broad usages. All the examples are related to highway transportation where the use of big data is exploding and presenting new challenges and opportunities for growth. Clear and precise practical introductory material on statistics is integrated into the relevant SAS procedures to bolster users’ confidence in applying such methods to their own work. Comprehensive and foundational coverage, systematic introduction of programming topics, thoroughly annotated code examples, and real-world code samples combine to make SAS® Coding Primer and Reference Guide an indispensable reference for beginners and experienced programmers.

Must-have study guide for the SAS® Certified Statistical Business Analyst Using SAS®9: Regression and Modeling exam! Written for both new and experienced SAS programmers, the SAS® Certification Prep Guide: Statistical Business Analysis Using SAS®9 is an in-depth prep guide for the SAS® Certified Statistical Business Analyst Using SAS®9: Regression and Modeling exam. The authors step through identifying the business question, generating results with SAS, and interpreting the output in a business context. The case study approach uses both real and simulated data to master the content of the certification exam. Each chapter also includes a quiz aimed at testing the reader’s comprehension of the material presented. Major topics include: ANOVA Linear Regression Logistic Regression Inputs for Predictive Modeling Model Performance For those new to statistical topics or those needing a review of statistical foundations, this book also serves as an excellent reference guide for understanding descriptive and inferential statistics. Appendices can be found here.

Start your journey with SAS. Have you just accepted a new job as a data analyst and need to learn SAS fast? Or perhaps you want to make a career change into programming and you’re not sure where to begin. The Simple Guide to SAS: From Null to Novice is the perfect book to get you started. Written for individuals with no prior programming experience, this book teaches the basics of learning SAS using hands-on examples and step-by-step explanations in a short, easy-to-understand guide. Topics covered in this book include: DATA and PROC Steps DATA Step Processing Setting Up SAS Libraries Importing and Exporting Data Viewing and Summarizing Data Sorting and De-duplicating Data Filtering Data and Conditional Logic SAS Functions Formatting Variables Combining and Aggregating Data The Simple Guide to SAS provides solutions to common business problems, identifies pitfalls to avoid, and includes sample code with data for readers to practice their knowledge.

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.