Sharpening Your Advanced SAS Skills presents sophisticated SAS programming techniques, procedures, and tools, such as Proc SQL, hash tables, and SAS Macro programming, for any industry. Drawing on his more than 20 years' experience of SAS programming in the pharmaceutical industry, the author provides a unique approach that empowers both advanced p

Clinical Data Quality Checks for CDISC Compliance using SAS is the first book focused on identifying and correcting data quality and CDISC compliance issues with real-world innovative SAS programming techniques such as Proc SQL, metadata and macro programming. Learn to master Proc SQL’s subqueries and summary functions for multi-tasking process. Drawing on his more than 25 years’ experience in the pharmaceutical industry, the author provides a unique approach that empowers SAS programmers to take control of data quality and CDISC compliance. This book helps you create a system of SDTM and ADaM checks that can be tracked for continuous improvement. How often have you encountered issues such as missing required variables, duplicate records, invalid derived variables and invalid sequence of two dates? With the SAS programming techniques introduced in this book, you can start to monitor these and more complex data and CDISC compliance issues. With increased standardization in SDTM and ADaM specifications and data values, codelist dictionaries can be created for better organization, planning and maintenance. This book includes a SAS program to create excel files containing unique values from all SDTM and ADaM variables as columns. In addition, another SAS program compares SDTM and ADaM codelist dictionaries with codelists from define.xml specifications. Having tools to automate this process greatly saves time from doing it manually. Features SDTMs and ADaMs Vitals SDTMs and ADaMs Data CDISC Specifications Compliance CDISC Data Compliance Protocol Compliance Codelist Dictionary Compliance

Learn how to read, understand, and write better SAS programs Understand the key differences between similar SAS syntax and programming approaches Save time in writing SAS code with organized summaries of important facts Improve your trouble-shooting skills in common programming and data related problems Reinforce your SAS knowledge with more than 150 technically challenging questionsIdeal for intermediate to advanced SAS users, Sharpening Your SAS Skills shows how to write and diagnose the most common programming tasks in data access, data management, and data analysis. This book organizes, prioritizes, and compares key facts about SAS for easy usage and reference. It includes SAS version 9.1 features and examples for improving data quality with integrity constraints, generation data sets, and audit trials. Each example will help you better understand the SAS syntax by showing the results expected from the input data and potential errors, notes, or warning messages the program may generate if written incorrectly.

Sharpening Your Advanced SAS Skills presents sophisticated SAS programming techniques, procedures, and tools, such as Proc SQL, hash tables, and SAS Macro programming, for any industry. Drawing on his more than 20 years' experience of SAS programming in the pharmaceutical industry, the author provides a unique approach that empowers both advanced p

Learn how to read, understand, and write better SAS programs � Understand the key differences between similar SAS syntax and programming approaches � Save time in writing SAS code with organized summaries of important facts � Improve your trouble-shooting skills in common programming and data related problems � Reinforce your SAS knowledge with more than 150 technically challenging questions Ideal for intermediate to advanced SAS users, Sharpening Your SAS Skills shows how to write and diagnose the most common programming tasks in data access, data management, and data analysis. This book organizes, prioritizes, and compares key facts about SAS for easy usage and reference. It includes SAS version 9.1 features and examples for improving data quality with integrity constraints, generation data sets, and audit trials. Each example will help you better understand the SAS syntax by showing the results expected from the input data and potential errors, notes, or warning messages the program may generate if written incorrectly.

Prepare for the SAS Base Programming for SAS 9 exam with the official guide by the SAS Global Certification Program. New and experienced SAS users who want to prepare for the SAS Base Programming for SAS 9 exam will find this guide to be an invaluable, convenient, and comprehensive resource that covers all of the objectives tested on the exam. Now in its fourth edition, the guide has been extensively updated, and revised to streamline explanations. Major topics include importing and exporting raw data files, creating and modifying SAS data sets, and identifying and correcting data syntax and programming logic errors. The chapter quizzes have been thoroughly updated and full solutions are included at the back of the book. In addition, links are provided to the exam objectives, practice exams, and other helpful resources, such as the updated Base SAS glossary and an expanded collection of practice data sets.

Quick and Easy Access to Key Elements of Documentation Includes worked examples across a wide variety of applications, tasks, and graphicsA unique companion for statistical coders, Using SAS for Data Management, Statistical Analysis, and Graphics presents an easy way to learn how to perform an analytical task in SAS, without having to navigate thro