Clinical Data Quality Checks for CDISC Compliance Using SAS

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

Table of Contents:
Overview of Data Quality and Compliance Checks SDTMs and ADaMs Vital Checks SDTMs and ADaMs Data Values Check CDISC Specification Compliance Checks CDISC Data Compliance Checks Protocol Compliance Checks Codelist Dictionary Compliance Checks Appendix

About the Author :
Sunil Gupta is an international speaker, best-selling SAS author, and a global corporate trainer. Sunil is a Principal SAS/CDISC Consultant. Most recently, he taught both of his CDISC online classes with the University of California at San Diego and SAS Institute India. New in 2019, Sunil is developing a new class on Data Science using SAS class. In 2011, Sunil launched his unique SAS resource blog, SASSavvy.com, for smarter SAS searches. Currently, SAS Savvy’s membership consists mostly of SAS programmers, university students and pharmaceutical corporate accounts

Review :
"This book is is indespensible for anyone implementing CDISC compliance and data quality checking. The practical examples will save a great deal of time and effort. Furthermore, the methods of the code are explained in detail to help the user understand how to create new checks as needed. Reader will improve understanding of CDISC principles and SQL . There are many highly developed diagrams to help organize and visualize." —Chris Weiner, Sr. Statistical Programmer, GCE Solutions "A must-read and reference for all clinical programmers. Data quality is fundamental for good clinical practice and this book is laser-focused on specific and critical programming techniques assuring compliant SDTM and ADAM data and reporting. It is a comprehensive desk reference which will become a standard for the industry. The included and well documented SAS code provides programmers with state of the art algorithms for validating and verifying STAM and ADAM datasets." - Roger DeAngelis, CEO CompuCraft Ltd "As I was reading this book, I instantly realized that the author has expert level knowledge in the clinical SAS programming arena. With the acceptance of CDISC as the standard for FDA submissions, it is imperative that companies submit air-tight data with complete compliance of clinical data standards. This is no easy task, but Sunil Gupta has done an outstanding job of providing a framework for creating standardized data. The SAS code is easy to use and generates compliant data without a hint of hardcoding. The book has a nice flow and diagrams are strategically interspersed to assist the reader in understanding the entire process. Another nice feature is that the book has sufficient detail without being tedious. This publication is very well organized allowing one to quickly find the requisite code by scanning the table of contents. I highly recommend this book for anyone in the clinical SAS environment, especially those involved in programming, validation, or project management." -Paul Gill, Clinical SAS Expert, BioClinicalData "This book is a must-read for programmers working with clinical trials data. It is a hands-on book with a wealth of examples that can be applied directly or with slight modification to your existing processes. What makes Mr. Gupta’s innovative SQL coding especially attractive is the way it yields concise, easy to interpret summary reports at each step from data capture through SDTM and AdAM data sets. His techniques for CDISC, protocol and codelist dictionary compliance are especially valuable for revealing errors at the coding stage, rather than later when rework would be costly and time-consuming. The programs in this book would make a valuable addition to any coder’s toolbox." -Vincent Rabatin, Founder, Rabatin Pharma Services "Nowadays, data quality and data checks are very important for agency submissions. If you don't have much knowledge of these issues and solution then this book is for you! Without this book, you may find it difficult and time consuming to create compliant SDTMs and ADaMs. This book covers lots of information that can be utilized to mitigate the issues at an early stage and also helps to increase data fitness scores. This book is very helpful for the Clinical and Statistical SAS programmers." - Ratheesh Gunda, Principal Statistical Programmer, Cytel "This book is is indespensible for anyone implementing CDISC compliance and data quality checking. The practical examples will save a great deal of time and effort. Furthermore, the methods of the code are explained in detail to help the user understand how to create new checks as needed. Reader will improve understanding of CDISC principles and SQL . There are many highly developed diagrams to help organize and visualize." —Chris Weiner, Sr. Statistical Programmer, GCE Solutions "A must-read and reference for all clinical programmers. Data quality is fundamental for good clinical practice and this book is laser-focused on specific and critical programming techniques assuring compliant SDTM and ADAM data and reporting. It is a comprehensive desk reference which will become a standard for the industry. The included and well documented SAS code provides programmers with state of the art algorithms for validating and verifying STAM and ADAM datasets." - Roger DeAngelis, CEO CompuCraft Ltd "As I was reading this book, I instantly realized that the author has expert level knowledge in the clinical SAS programming arena. With the acceptance of CDISC as the standard for FDA submissions, it is imperative that companies submit air-tight data with complete compliance of clinical data standards. This is no easy task, but Sunil Gupta has done an outstanding job of providing a framework for creating standardized data. The SAS code is easy to use and generates compliant data without a hint of hardcoding. The book has a nice flow and diagrams are strategically interspersed to assist the reader in understanding the entire process. Another nice feature is that the book has sufficient detail without being tedious. This publication is very well organized allowing one to quickly find the requisite code by scanning the table of contents. I highly recommend this book for anyone in the clinical SAS environment, especially those involved in programming, validation, or project management." -Paul Gill, Clinical SAS Expert, BioClinicalData "This book is a must-read for programmers working with clinical trials data. It is a hands-on book with a wealth of examples that can be applied directly or with slight modification to your existing processes. What makes Mr. Gupta’s innovative SQL coding especially attractive is the way it yields concise, easy to interpret summary reports at each step from data capture through SDTM and AdAM data sets. His techniques for CDISC, protocol and codelist dictionary compliance are especially valuable for revealing errors at the coding stage, rather than later when rework would be costly and time-consuming. The programs in this book would make a valuable addition to any coder’s toolbox." -Vincent Rabatin, Founder, Rabatin Pharma Services "Nowadays, data quality and data checks are very important for agency submissions. If you don't have much knowledge of these issues and solution then this book is for you! Without this book, you may find it difficult and time consuming to create compliant SDTMs and ADaMs. This book covers lots of information that can be utilized to mitigate the issues at an early stage and also helps to increase data fitness scores. This book is very helpful for the Clinical and Statistical SAS programmers." - Ratheesh Gunda, Principal Statistical Programmer, Cytel "CDISC provides a standard framework for describing data collected from clinical and preclinical studies. Now data submitted to FDA and some other regulatory agencies are required to be in CDISC compliant format. For many biometrics’ professionals (biostatisticians, programmers, and data managers), CDISC’s Foundational Standards, Data Exchange Standards, and Controlled Terminology Standards may be felt overwhelmed. In this book, Sunil explains these standards in plain language, and walks you through the roadmap of building a system of macros for in-house compliance check using many easy to understand SAS examples." - Jeff Cao, CEO, VIITAI